MCQs – SQL Database

MCQ – Multiple choice questions on SQL Database with answers and explanation. Many of the objective questions are asked in IT jobs written interviews.

Q)Combination of primary key with foreign key forms

1. Parent child relationship between the tables that connect them
2. Many to many relationship between the tables that connect them
3. Network model between the tables connect them
4. none of them

Answer: 1

Q)Match SQL language with SQL commands

1)DDL    i)Revok, Grant
2)DML   ii)rename a table
3)TCL    iii)insert, update
4)DCL    iv)rollback , commit

1. 1-iii,2-i,3-ii,4-iv
2. 1-iii,2-ii,3-iv,4-i
3. 1-ii,2-iii,3-iv,4-i
4. 1-i,2-iii,3-ii,4-iv

Answer: 3

Q)Types of SQL Trigger is/are in SQL database

1. DDL
2. DML
3. LOGON
4. ALL

Answer: 4
DML triggers fire with insert, delete and update operations
DDL triggers are executed with operations like creating a table
Logon triggers fire when a login connects SQL Server instance.

Q)Which is not DDL (data definition language) operation

1. Renaming a table
2. SQL create table
3. Add a column to an existing table
4. Update data into a table in SQL database

Answer: 4
Read detail about SQL sub language

Q)Which statement is correct? A table can have

1. many primary key and many unique key
2. one primary key and one unique key
3. one primary key and many unique key
4. many primary key and one unique key

Answer: 3

Q)SQL is used to access and manipulate data in SQL database

1. MSAccess
2. Oracle
3. MySQL
4. All

Answer: 4