Disk File Records Notes Questions with Answers PDF Download - 75

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

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

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

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

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