SQL Quiz


Play this quiz that will help you to excel in SQL certification exams, placements etc. This SQL quiz consist of 10 questions that you need to solve in 10 minutes. We’ve specially designed this quiz so that you can quickly acquaint to the pattern of questions you can be asked in placement drives, certification exams etc. This SQL test enables you to assess your knowledge of SQL.

Take the Free Practice Test



SQL MCQs

Practice DBMS (SQL) MCQ Questions, which will help you to understand Database related concepts and also helps you to prepare for placements, technical rounds, interviews, competitive exams etc.

SQL Quiz

Try Free SQL Quiz, to start a quiz you need to login first, after login you will get start quiz button and then by clicking on that you can start quiz. You will get 10 Minutes to answer all questions.

SQL Quiz

1. The set of permitted values of an attribute is called

Tuple
Domain
Column
Table

2. Which of the following specifies when the trigger will be executed?

BEFORE
AFTER
INSTEAD OF
All of the above

3. Can we insert and delete rows into a View?

Yes
No
Rows of data can be inserted but can not deleted
Rows of data can be deleted but cacn not inserted

4. OLD and NEW references are available for table-level triggers

TRUE
FALSE
Can be true or false
Can not say

5. Command that is used to add attributes to an existing relation, is said to be

Alter
Modify
Tailor
Eliminate

6. Point out the correct statement.

Triggers are database object
Three types of triggers are present in SQL Server
A DDL trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server
None of the mentioned

7. Which of the following statements are False regarding subqueries?

Only two subqueries can be placed at one level
A subquery can appear on either side of a comparison operator
Both A and B
None of the above

8. A Database Management System is

Collection of interrelated data
Collection of programs to access data
Collection of programs
None of the mentioned is correct.

9. When a referential-integrity constraint is violated, the normal procedure is to

Continue with flow
Accept the action
Reject the action
Store it for evaluation

10. Choose the correct processing technique for the given statements.
Update project details of an employee

OLTP
OLAP
OLAM
None of the above

Results