CAT Questions

---

In SQL, a SQL view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table.

SQL views can be used to hide rows and columns and complicated SQL syntax.

The fields in a view are fields from one or more real tables in the database.

Let the speed of the boat in still water is 'w'

Speed of the current is 'c'

Let the distance between two places is 'd'

According to the question, motorboat takes half time to cover a certain distance downstream than upstream.

dw+c = 12dw-c

=> 2w - 2c = w + c

=> w = 3c

=> c : w = 1 : 3

Hence, the ratio between rate of current(c) and rate of boat in still water(w) = 1 : 3

India's most consistent middle-order batsman Cheteshwar Pujara stormed his way into record books after playing a marathon innings against Australia on fourth day of the third Test match
surpassing Rahul Dravid previous best of 495 balls. 

Assume Hebah has Rs. M

Since 25% more money at Poonam

=> Money at Poonam = M + (25% of M)

=> Money at Poonam = M + 0.25M = Rs. 1.25M

Money with Navaneet is thrice the money with Poonam,

=> Money at Navaneet = 3(1.25M) = Rs. 3.75M

Now, sum of all Money = (M + 1.25M + 3.75M) = Rs. 6M

But given the average of the money is Rs. 350

=> 6M/3 = 350

=> 2M = 350

=> M = 350/2 = Rs. 175

=> Amount of money Navaneet has = Rs. 3.75M = 3.75 x 175 = Rs. 656.25.

Let 'M' be the maximum marks in the examination.

Therefore, Madhu got 32% of M = 32M/100 = 0.32M
And Kumar got 42% of M = 42M/100 = 0.42M.
In terms of the maximum marks Kumar got 0.42M - 0.32M = 0.1M more than Madhu. ---- (1)

The problem however, states that Kumar got 16 marks more than the cut-off mark and Madhu got 8 marks less than the cut-off mark. Therefore, Kumar has got 16 + 8 = 24 marks more than Madhu. ---- (2)

Now, Equating (1) and (2), we get
0.1M = 24 => M = 24/0.1 = 240
'M' is the maximum mark and is equal to 240 marks.
We know that Madhu got 32% of the maximum marks.
Therefore, Madhu got 32 x 240/100 = 76.8 marks.
We also know that Madhu got 8 marks less than the cut-off marks.

Therefore, the cut-off marks will be 8 marks more than what Madhu got
= 76.8 + 8 = 84.8.

In computer network nodes are

* the computer that terminates the data

* the computer that originates the data

* the computer that routes the data

Let the total applicants be 100

Then, 20% got 85 marks

i.e 20 x 85 = 1700

and 25% got 95 marks

 i.e 25 x 95 = 2375

Now, the remaining applicants are 55 and let the average marks scored by them be x.

Therefore, 2375 + 1700 + 55x  =  60×100 

6000 - 4075 = 55x

55x=1925

x=35.