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

2. A ___________ is a prepared SQL code that you can save, so the code can be reused over and over again.

triggers
stored procedure
cursor
functions

3. Which of the following statements are TRUE about DISTINCT keyword?

DISTINCT removes duplicates based on all the columns in the SELECT clause
Usage of DISTINCT should be avoided as far as possible due to performance issues
Both A and B
None of the above

4. What is the sql error code for SELF_IS_NULL?

"-6504"
"-30625"
"-1422"
"-6502"

5. Choose the correct processing technique for the given statements.
Identify correlation between salary structure and policies sold made by Insurance agents in an organization.

OLTP
OLAP
OLAM
None of the above

6. Which of the following statement(s) is/are True about UNION?

Data Types in all queries in a UNION must match position wise
Column Names in all queries in a UNION must match position wise
UNION can be used with UPDATE statement
None of the above

7. What options did ALTER DATABASE statement add?

DATABASE SNAPSHOT syntax
ATTACH_REBUILD_LOG clause
DB_CHAINING option
READ_COMMITTED_SNAPSHOT

8. Create table student(name varchar ,id integer) What type of statement is this ?

DML
DDL
DCL
TCL

9. All tuples in the relation are assigned null as the value for the new attribute, in the

Alter Command
Select Command
Delete Command
Create Command

10. What is true about order by with Union operator?

Order By can be issued in each result set.
It can be issued for the overall result set.
Both A & B.
None of the above

Results