1. After 2001, in response to the increased demand for seafood worldwide, fishermen worldwide increased the use of the purse seine method. As a result, the productivity of fishing was doubled by 2015.
Since
2015,fishermen have sought to increase fishing productivity even further.
Nevertheless, the use of the purse seine net
has declined by 6 percent from 2015. Which of the following statement
required to solve the started
discrepancy?
- Since 2015, the demand in seafood has increased
by the rate at which the world’s population has increased.
- Between 2001 and 2015,seafood price temporarily
increased because of disputes in labour.
- Between
2001 and 2015, fishermen were able to increased the catch of many
varieties of seafood.
- Government has imposed a ban on the usage of
purse seine net since it damages
the sea bed
2. Based on the following tables, what is the
output of the SQL query
STUDENT
|
ID |
Name |
|
1 |
Ben |
|
2 |
Bob |
|
3 |
Mike |
|
4 |
Alice |
TEACHER
|
ID |
Name |
|
1 |
Lisa |
|
5 |
Mary |
|
3 |
John |
|
6 |
Paul |
Query
SELECT ID
FROM TEACHER WHERE ID <(SELECT AVG(ID) FROM TEACHER)
|
ID |
|
2 |
|
4 |
|
ID |
|
5 |
|
6 |
|
ID |
|
1 |
|
3 |
|
ID |
|
2 |
|
4 |
|
5 |
|
6 |
3. Which of the following SQL queries is used to
find all the cities from the table named weather with the weather conditions
whose humidity is in the range of 60 to 100:
Queries
Ø SELECT * FROM weather WHERE humidity
IN (60 to 100);
Ø SELECT * FROM weather WHERE
humidity NOT IN (60 to 100);
Ø SELECT * FROM weather WHERE humidity
BETWEEN 60 AND 100;
Ø SELECT * FROM weather WHERE humidity
NOT BETWEEN 60 AND 100;
- 3
- 2
- 4
- 1
4. Consider the following two tables named to Toys
and Category with their respective columns. In SQL Server, which of the
following queries is used to display the toy names and their respective
category names ?
Toys
|
ToyID |
vToyName |
Categoryid |
Category
|
cCategoryID |
cCategory |
- SELECT vToyName, cCategory FROM Toys JOIN
Category ON cCategoryid = cCategoryID
- SELECT t.vToyName, c.cCategory FROM Toys t INNER
JOIN Category ON cCategoryid = cCategoryID
- SELECT t.vToyName, c.cCategory FROM Toys t JOIN
Category c
- SELECT
t.vToyName, c.cCategory FROM Toys t, Category c ON cCategoryid = cCategoryID
5. A gas chamber of 100L consists of 60% oxygen
and 40% nitrogen. Some amount of the
gaseous ,mixture was removed from
the chamber and the same amount of nitrogen was added such that the nitrogen
%ge become 70.
What amount
of gas was removed?
- 50L
- 75L
- 25L
- 20L
6. A jar of whiskey originally contained alcohol
at 44%. A part of this whiskey is replaced by another drink containing alcohol
at 20%.
If the
resulting mixture contains alcohol at 24%, what fraction of whiskey was
replaced?
- 5/6
- 4/5
- 2/5
- 3/5
7. We have
a mixture of 70% orange juice and 30% water. We take out 5L of the
liquid and then add the same amount of pure orange juice to it.
If the
mixture contains 73% orange juice then
what is the total volume of mixture in L?
- 200L
- 100L
- 50L
- 25L
READ
NUMBER
8. k=2
i=2
while i <=
number
k = k*i
i = i + 1
end while
write k
- 1340
- 1700
- 1560
- 1400
9. Integer a,
b, c
Set b
= 5, a = 2, c = 2
if
(b>a && a>c
&& c>b)
b = a + 1
Else
a = b+1
End if
Print a + b
+ c
- 2
- 13
- 5
- 26
10. Integer i,
j, k, n
Set j=1,
k=1
for(each
i from 1 to 5 )
print k
j = j + 1
k = k + j
end for
- 1 3 6
10 15
- 2 4 6
8 10
- 1 1 2
3 5
- 1 2 3
4 5
11. Integer a,
b, c
Set b = 2
, a = 2
c = a^b
Print c
- 2
- 4
- 0
- 6
12. Integer i, j,
k
Set k
= 8
for (each
i from 1 to1 )
for (each j from the
value of i to 1
print k + 1
end for
End for
- 2
- 7
- 5
- 9
13. A juggler
is juggling several bails. The
probability that he drops a ball is given by the function
n/(n+10) where n is the number of bails he is juggling.
What is the probability that he will drop 4 balls in a
row when he starts with twice that many.
- 0.0455
- 0.0324
- 0.0124
- 0.0228
14. Suppose
there are three coins - gild, silver and
bronze.
If you tell a truth, you will get a coin. On the other
hand, if you tell a lie, you will get nothing.
Which one of
the following statements has the maximum probability of getting you a gold
coin?
- “You will give me
a gold coin”
- “You will give me
either gold or silver coin”
- “You will give me either silver or bronze coin”
- “You will give me
neither silver nor bronze coin ”
15. The
probability that a bullet fired a gun will hit the target is 5/7. Two such guns
fire simultaneously towards the target.
What is the probability that the target will be hit?
- 4/9
- 7/10
- 19/61
- 45/49
16. 65% of a
number is 21 less than 4/5th of a number . determine the number.
- 120
- 140
- 240
- 200
17. Determine the number of ways to arrange HACKEREARTH
so that all the vowels are placed adjacent to each other?
- 60480
- 21060
- 120960
- 10080
18. In
Statistics, you are carrying out primary market research to understand how many
days in a week people generally do physical activities. You asked three of your
friends .the answers you got were 2, 3 and 5
Which of the following statement about the results you
found is true?
- The mean of the sample is 3.33 and the variance
is 1.53
- The mean of the population is 3.33 and the
variance is 1.53
- The mean of the sample is 3.33 and the variance
is -1.53
- The mean of the sample is 3.33 and the variance
is 2.5
19. A
shopkeeper mixes three tea bags priced at Rs 50, Rs 60 and Rs 100 per kg
respectively.
In what ratio
must he mix the bags ,in order to achieve the final price at INR 80 per kg?
- 2:01:04
- 2:01:05
- 2:02:05
- Both Choice 1 and Choice 3
20. If the
first task is performed in X ways
and the second task second task
is performed is Y ways then both of them
can be performed in how many ways?
- X+2Y
- X+Y
- X*Y
- None of these
21. The
following pie charts represent the sales of different automobile companies in
two consecutive years . what was the approximate percentage increase in
sales of GM between 2016 and 2017?
- 120%
- 134%
- 126%
- 65%
No comments:
Post a Comment