GATE CS 2011

Question 61

Database table by name Loan_Records is given below.

Borrower    Bank_Manager   Loan_Amount
 Ramesh      Sunderajan     10000.00
 Suresh      Ramgopal       5000.00
 Mahesh      Sunderajan     7000.00

What is the output of the following SQL query?

SELECT Count(*) 
FROM  ( ( SELECT Borrower, Bank_Manager 
          FROM Loan_Records) AS S 
          NATURAL JOIN ( SELECT Bank_Manager, Loan_Amount 
                         FROM Loan_Records) AS T );

• 3
• 9
• 5
• 6

Question 62

If the difference between expectation of the square of a random variable (E[X²]) and the square of the expectation of the random variable (E[X])² is denoted by R, then?

• R = 0
• R < 0
• R >= 0
• R > 0

Question 63

Choose the most appropriate word from the options given below to complete the following sentence.

If you are trying to make a strong impression on your audience, you 
cannot do so by being understated, tentative or_____________.

• Hyperbolic
• Restrained
• Argumentative
• Indifferent

Question 64

A deck of 5 cards (each carrying a distinct number from 1 to 5) is shuffled thoroughly. Two cards are then removed one at time from the deck. What is the probability that the two cards are selected with the number on the first card being one higher than the number on the second card?

• 1/5
• 4/25
• 1/4
• 2/5