Data Storage and Querying Quiz PDF: Questions and Answers - 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