View of Data MCQ with Answers PDF Download – Test 120

MCQ 596: The abstraction level that describes complex low-level data structures in detail, is:

1. Physical level
2. View level
3. Virtual level
4. Logical level

MCQ 597: The third level of abstraction, that simplifies the user interaction to the system is:

1. Virtual level
2. Physical level
3. Logical level
4. View level

MCQ 598: An index on an attribute of a relation is a data structure that allows database system to find tuples in relation that have specified value for attribute:

1. Efficiently
2. Inefficiently
3. Costly
4. Optimized

MCQ 599: The expression r -s represents a:

1. Arity
2. Unity
3. Projection
4. Set-difference

MCQ 600: Declarative DMLS requires a user to specify what data are needed and:

1. Specifying how to get data
2. Provides data model
3. Provides Schema
4. Not specifying to get data