Nested Subqueries Quiz PDF: Questions and Answers - 143

MCQ 711: The clause that permits a view definition to be used in multiple places within a query, is known to be

1. Not Like clause
2. Unique clause
3. With clause
4. Having clause

MCQ 712: The integrity constraints is included in the database by

1. SQL DDL
2. View definition
3. SQL DML
4. Authorization manager

MCQ 713: A guard against accidental damage to the database, is known to be

1. Redundancy constraints
2. Integrity constraints
3. Isolated integrity
4. Atomicity

MCQ 714: Ensuring the atomicity and durability properties is the responsibility of the

1. Recovery manager
2. Buffer manager
3. Transaction manager
4. File manager

MCQ 715: Cached Web pages and cached query results are forms of

1. Relational views
2. Legalized views
3. Materialized views
4. Logical views