Ordered Indices MCQ with Answers PDF Download – Test 164

MCQ 816: Files that uses a clustering index for the search key, are called:

1. Sequenced-index files
2. Index-sequential files
3. Index-structured files
4. Sequence-structured files

MCQ 817: The natural join is a:

1. Unary operation
2. Structural operation
3. Non structural operation
4. Binary operation

MCQ 818: Like attribute inheritance, the inheritance that applies through all tiers of lower-level entity sets, is known to be:

1. Participation inheritance
2. Execution inheritance
3. Existence inheritance
4. Dependency inheritance

MCQ 819: SQL allows the creation of temporary tables using the command:

1. create temporary table
2. Define temporary table
3. declare temporary table
4. modify temporary table

MCQ 820: SQL language designed for decision support applications, was:

1. Query intensive
2. Logical model
3. Physical model
4. None of the above