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 statements are False?

RIGHT OUTER JOIN is equivalent to LEFT OUTER JOIN if order of tables are reversed
FULL OUTER JOIN is same as CROSS JOIN
SELF JOIN is a special type of OUTER JOIN
Both B and C

2. To include integrity constraint in an existing relation use :

Modify table
Drop table
Alter table
Create table

3. The relationship between the two tables are created using __________

Candidate Key
Primary Key
Foreign Key
Check Constraint

4. Which of the following benefit does Exception handling with the TRY and CATCH blocks provide?

Exceptions provide a mechanism to signal errors directly rather than using some side effects
Exceptions can be seen by the programmer and checked during the compilation process
Exceptions provide a clean way to check for errors without cluttering code
All of the above

5. Data manipulation language (DML) includes statements that modify the _____ of a database.

Structure
Data
User
Size

6. Which of the following is correct DROP INDEX Command?

DROP INDEX table_name;
DROP INDEX index_name;
DROP INDEX index_name or table_name;
DELETE INDEX index_name;

7. SELECT on a MERGE table is like _____________

UNION ALL
UNION
UNION DISTINCT
JOIN

8. Which of the following systems is responsible for ensuring isolation?

Recovery system
Atomic system
Concurrency control system
Compiler system

9. A relational database consists of a collection of

Table
Record
Fields
Attributes

10. How many types of exception are there in sql?

2
3
4
5

Results