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. The relationship between the two tables are created using __________

Candidate Key
Primary Key
Foreign Key
Check Constraint

2. Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:

TRUNCATE command
Create command
Drop table command
Alter table command

3. Which of the following operators cannot be used in a sub-query?

AND
<
>
<>

4. In SQL, which of the following is not a data definition language commands?

RENAME
REVOKE
GRANT
UPDATE

5. Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.

Having, where
Group by, having
Group by, where
Where, having

6. Which of the following creates temporary relation for the query on which it is defined

With
From
Where
Select

7. Which option in view is to ensure that all UPDATE and INSERTs satisfy the condition(s) in the view definition?

Uncheck
With Check
Check
With

8. Which keyword used with UNION does not retain duplicate rows?

ALL
NARROW
STRICT
DISTINCT

9. An ________ is a set of entities of the same type that share the same properties, or attributes.

Entity set
Attribute set
Relation set
Entity model

10. What is the syntax for Single-Column Indexes?

CREATE INDEX index_name ON table_name (column_name);
CREATE SINGLE-COLUMN INDEX index_name ON table_name (column_name);
CREATE INDEX SINGLE-COLUMN index_name ON table_name (column_name);
ALTER SINGLE-COLUMN INDEX index_name ON table_name (column_name);

Results