SQL Objective Questions and Answers PDF Download - 38

MCQ 186: In SQL, the output of a union operation automatically eliminates

1. Non-Consistency
2. Duplication
3. Non-Integrity
4. Unauthorization

MCQ 187: A privilege in the SQL environment is granted to a role rather than by a

1. Administrator
2. Processor
3. Interpreter
4. User

MCQ 188: Clause used to define the limited form of recursion, supported by the SQL standard is said to be

1. recursive clause
2. declare recursive clause
3. with recursive clause
4. define recursive clause

MCQ 189: The original version of SQL developed by the IBM was said to be

1. Data language
2. Sequel
3. Operational language
4. Query language

MCQ 190: In SQL a nesting subquery can be declared in the

1. Select clause
2. Where clause
3. From clause
4. Distinct clause