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. Which of the following statement is TRUE about FULL OUTER JOIN created on two tables Table1 and Table2?

Retrieves all the unmatched rows of Table1
Retrieves all the unmatched rows of Table2
Retrieves both matched and unmatched rows of Table1 and Table2
Retrieves only matched rows of table1 and Table2

2. 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

3. Which statements can be checked for handling errors.

DDL
TCL
DML
TTL

4. Is UNION or UNION ALL operator valid for LONG data type column?

True True
True False
False True
False False

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

Tuple
Record
Relationship
Field

6. Views can be created for?

One table
Many table
another view
All of the above

7. Relation R1 has 10 tuples and 5 attributes. Relation R2 has 0 tuples and 7 attributes. When a CROSS JOIN is achieved between R1 and R2, how many tuples would the resultant set have?

28
10
0
35

8. What is syntax for delete the view?

DELETE VIEW view_name;
DROP VIEW view_name/table_name;
DROP VIEW view_name;
DROP VIEW table_name;

9. What is the maximum value that can be stored in NUMERIC(4,2)?

9999.99
99.9999
99.99
9.99

10. Exception handling is possible in SQL Server using _____________

FINAL
FINALLY
THROW
THROWS

Results