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.

Introduction to SQL

Bestseller by Coursera

You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation.

16 Hours
Paid

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. What is the sql error code for SELF_IS_NULL?

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

2. Which of the following statements are TRUE?

A Unique constraint allows multiple rows to have NULL value
Integrity constraint can be added to a table even if table data is in violation
A PRIMARY KEY allows a single row to contain NULL
Both A and B

3. What options did ALTER DATABASE statement add?

DATABASE SNAPSHOT syntax
ATTACH_REBUILD_LOG clause
DB_CHAINING option
READ_COMMITTED_SNAPSHOT

4. Which statement would add a column CGPA to a table Student which is already created

ALTER TABLE Student ADD COLUMN (CGPA NUMBER(3,1));
ALTER TABLE Student CGPA NUMBER(3,1);
ALTER TABLE Student ADD (CGPA NUMBER(3,1));
Both A and C

5. To remove a relation from an SQL database, we use the ______ command.

Delete
Purge
Drop table
Remove

6. Which of the following statements does not change the state of the database?

Where
Select
Insert
Drop

7. How can you find rows that do not match some specified condition?

EXISTS
Double use of NOT EXISTS
NOT EXISTS
None of the mentioned is correct.

8. TRUNCATE statement in SQL is a

DDL
DML
DCL
TCL

9. _______ views help to keep the database up-to-date.

View materialization
View isolation
View updating
View maintenance

10. Current date is returned by the method

system.date
current.date
machine.date
today.date

Results