The SQL query

SELECT columnsFROM TableARIGHT OUTER JOIN TableBON A.columnName = B.columnNameWHERE A.columnName IS NULL 

returns the following:
(A) All rows in Table B, which meets equality condition above and, none from Table A, which meets the condition
(B) All rows in Table A, which meets equality condition above and none from Table B, which meets the condition
(C) All rows in Table B, which meets equality condition
(D) All rows in Table A, which meets equality condition
(E) None of these

If every non-key attribute functionally dependent on the primary key, then the relation will be in
(A) First normal form
(B) Second normal form
(C) Third normal form
(D) Fourth normal form

To send same bit sequence, NRZ encoding require
(A) Same clock frequency as Manchester encoding
(B) Half the clock frequency as Manchester encoding
(C) Twice the clock frequency as Manchester encoding
(D) A clock frequency which depend on number of zeros and ones in the bit sequence

The persist timer is used in TCP to
(A) To detect crashes from the other end of the connection
(B) To enable retransmission
(C) To avoid deadlock condition
(D) To timeout FIN_Wait1 condition

An array of 2 two byte integers is stored in big endian machine in byte address as shown below. What will be its storage pattern in little endian machine ?

Address Data0 × 104 780 × 103 560 × 102 340 × 101 12 

(A)

0 × 104 120 × 103 560 × 102 340 × 101 78 

(B)

0 × 104 120 × 103 340 × 102 560 × 101 78 

(C)

0 × 104 560 × 103 780 × 102 120 × 101 34 

(D)

0 × 104 560 × 103 120 × 102 780 × 101 34 

Context free languages are closed under
(A) union, intersection
(B) union, kleene closure
(C) intersection, complement
(D) complement, kleene closure

What is the output of the following ‘c’ code assuming it runs on a byte addressed little endian machine?

(A) 622
(B) 311
(C) 22
(D) 110

What is the output in a 32 bit machine with 32 bit compiler ?

(A) 60 70
(B) 50 50
(C) 50 60
(D) 60 50

A new flip flop with inputs X and Y, has the following property.

Which of the following expresses the next state in terms of X, Y, current state ?
(A) X’Q’ + Y’Q
(B) X’Q + Y’Q’
(C) XQ’ + YQ
(D) XQ’ + Y’Q

Consider product of three matrices M1, M2 and M3 having w rows and x columns, x rows and y columns, and y rows and z columns. Under what condition will it take less time to compute the product as (M1M2)M3 than to compute M1(M2M3) ?

(A) Always take the same time
(B) (1/x + 1/z) < (1/w + 1/y)
(C) x > y
(D) (w + x) > (y + z)