Data Storage and Querying Notes Questions with Answers PDF Download – Test 67

MCQ 331: Storage manager translates of DML statements into:

1. Low-level file-system commands
2. High-level file-system commands
3. Inductive-level file-system commands
4. Deductive-level file-system commands

MCQ 332: The query processor component that interprets DDL statements and records the definitions in the data dictionary, is known as:

1. DDL interpreter
2. DDL compiler
3. DDL processor
4. DDL manager

MCQ 333: The basic structure of an SQL query consists of clauses of type:

1. 2 types
2. 3 types
3. 4 types
4. 5 types

MCQ 334: A view is updatable, if any attribute not listed in the select clause can be set to null and it does not have a constraint of:

1. Unknown
2. Not Null
3. Null
4. Union

MCQ 335: A scheme that creates a new version of a data item for each transaction is defined by:

1. Concurrency control scheme
2. Multiversion concurrency control scheme
3. Timestamp concurrency control scheme
4. Wound concurrency control scheme