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. Where subqueries can not be used?

Field names in the SELECT statement
The WHERE clause only in the SELECT statement
The WHERE clause in SELECT as well as all DML statements
The FROM clause in the SELECT statement

2. Point out the correct statement.

When a database is dropped, the master database should be backed up
You can drop a database currently being used
Dropping a database snapshot does not delete the database snapshot from an instance of SQL Server
None of the mentioned

3. A relation is in 2NF if:

All the values of non-key attributes are dependent fully on the candidate key.
Any non-key attribute that are dependent on only part of the candidate key should be moved to another relation where the partial key is the actual full key.
It must be already in the 1NF.
All of the above.

4. Which keyword used with UNION retains duplicate rows?

ALL
NARROW
STRICT
DISTINCT

5. Which of the following is the feature of stored procedure?

It enhances efficiency
It enhances reusability
It enhances security
All of the above

6. The process of maintaining views up to date is called?

View materialization
View isolation
View updating
View maintenance

7. Which of the following is not an integrity constraint?

Not null
Positive
Unique
Check predicate

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. Which of the following statement removes sales and suppliers database?

DROP DATABASE Sales, NewSales
DROP DATABASE Sales, suppliers
DROP DATABASE Sales and suppliers
DROP DATABASE Sales-suppliers

10. An association of several entities in an Entity-Relation model is called :

Tuple
Record
Relationship
Field

Results