Modification of Database Multiple Choice Questions (MCQ) PDF Download

MCQ 1: SQL supports nested subqueries in the where, and from clauses of an

1. Outer query
2. Inner query
3. Outer tuple
4. Inner tuple

MCQ 2: Performing all the tests before performing any deletion is

1. Important
2. Optional
3. Complex
4. Irrational

MCQ 3: SQL supports basic set operations on relations that includes

1. Union
2. Intersect
3. Except
4. All of the above

MCQ 4: Scalar subqueries are also useful in SQL

1. Insertion statements
2. Deletion statement
3. Update statements
4. Retrieval statement

MCQ 5: The SQL data-definition language is used to create relations with specified

1. Schema
2. Structure
3. Domain
4. Attributes