Disk File Records Notes Questions with Answers PDF Download – Test 75

MCQ 371: The command which returns the first record of the just opened file is classified as:

1. reorganize command
2. scan command
3. set-at-a-time command
4. insert command

MCQ 372: If matching tuples are not found, the kind of OUTER JOIN operation which keeps all the tuples of second relation out of the two relations is classified as:

1. UPWARD JOIN
2. DOWNWARD JOIN
3. LEFT OUTER JOIN
4. RIGHT OUTER JOIN

MCQ 373: Considering the device specifications, the byte sizes are usually from:

1. 2 to 8 bits
2. 8 to 16 bits
3. 4 to 8 bits
4. 2 to 4 bits

MCQ 374: The decomposition of one relation say R into two relations is classified as:

1. functional decomposition
2. ternary decomposition
3. binary decomposition
4. ordinary decomposition

MCQ 375: If matching tuples are not found, the kind of OUTER JOIN operation which keeps all the tuples of first relation out of the two relations is classified as:

1. LEFT OUTER JOIN
2. RIGHT OUTER JOIN
3. UPWARD JOIN
4. DOWNWARD JOIN