Overview of SQL Query Language Multiple Choice Questions (MCQ) PDF Download

MCQ 1: The view definition in a SQL database is included by

1. Authorization manager
2. SQL DML
3. SQL DDL
4. Transaction control.

MCQ 2: Including commands for specifying constraints that the data stored in the database must satisfy, is said to be the

1. Authorization
2. View definition
3. Integrity
4. View declaration

MCQ 3: American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) published an SQL standard, named SQL-86, in

1. 1984
2. 1985
3. 1986
4. 1987

MCQ 4: SQL has clearly established itself as the standard relational

1. Database process
2. Database language
3. Database storage
4. Database manager

MCQ 5: Language that can define the structure of the data, modify data in the database, and specify security constraints, is

1. DB2
2. JAVA
3. XML
4. SQL