Basic Structure of SQL Queries Multiple Choice Questions (MCQ) PDF Download

MCQ 1: For understanding of operations, the clauses must be written in the order

1. Select, where, from
2. From, select, where
3. Select, from, where
4. From, where, select

MCQ 2: The query for finding the department names of all instructors, is

1. select dept_name about instructor;
2. define dept_name from instructor;
3. select dept_name from instructor;
4. define dept_name about instructor;

MCQ 3: Since duplicate retention is the default, we shall not use

1. Distinct
2. All
3. Describe
4. Whole

MCQ 4: The result relation has all attributes from all the relations in the

1. Select clause
2. IN clause
3. From clause
4. Define clause

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

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