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. Point out the correct statement.

When a database is dropped, the master database should be backed up
You can drop a database currently being used
Dropping a database snapshot does not delete the database snapshot from an instance of SQL Server
None of the mentioned

2. Which of the following statement is TRUE about UNION?

Each query in a UNION can be sorted independently in different sort orders
All the queries in a UNION must be against the same table
UNION clause is used to subtract rows of second query from the first query
UNION and UNION ALL give same result if the participating queries are mutually exclusive

3. A SELECT statement can be used to perform these three functions:
- Choose rows from a table.
- Choose columns from a table.
- Bring together data that is stored in different tables by creating a link between them.
Which set of keywords describes these capabilities?

difference, projection, join
selection, projection, join
Selection, intersection, join
Intersection, projection, join

4. Which of the operation are not specifies in triggers?

Alter
UPDATE
INSERT 
DELETE

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

RENAME
REVOKE
GRANT
UPDATE

6. _______________ have a structure separate from the data rows?

B-Tree
Non Clustered
Covered
Clustered

7. For a user-defined exception, SQLCODE returns 1, and SQLERRM returns ___________.

1
User-defined Exception
0
Predefined Exception

8. Which of the following statement(s) is/are FALSE about primary key?

There can be more than one primary key for a table
Columns with string data types cannot be made Primary Key because they are large
Both A and B
None of the above

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

10. Data types in SQL Server are organized into how many categories?

6
7
8
9

Results