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. The ______ construct returns true if a given tuple is present in the subquery.

not exists
present
not present
exists

2. The most easily tested constraints of a new data entered is into a database is called?

referential constraints
domain constraints
assertion
None of these

3. A _______ index is an index on two or more columns of a table.

Implicit
Unique
single-column
Composite

4. What is xyz in the following SQL statement? SELECT xyz FROM table1 UNION xyz FROM table2;

row name
column name
table name
database name

5. Which of the following conditions has to be satisfied for INNER JOIN to work?

Columns used for joining must have same name
Columns used for joining can have same or different name
Columns used for joining must have different names
Columns used for joining must have different names

6. The attributes made up of more than one single attributes are called

Composite attribute
Derived attribute
Single value attribute
Multi value attribute

7. Which of the following is a global variable for error handling?

"@@ERRORS"
"@ERRORS"
"@@ERR"
"@@ERRORS"

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

9999.99
99.9999
99.99
9.99

9. A view can contain all rows of a table?

TRUE
FALSE
Not all rows but all columns
Can't say

10. Which are the join types in join condition:

Cross join
Natural join
Join with USING clause
All of the mentioned

Results