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 statement(s) is/are True about UNION?

Data Types in all queries in a UNION must match position wise
Column Names in all queries in a UNION must match position wise
UNION can be used with UPDATE statement
None of the above

2. Does index take space in the disk?

Yes
No
It stores memory as and when required
Indexes take no space

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

4. Which table is used to run a UNION-type query on MyISAM tables?

TRADITIONAL
MERGE
SERVELET
UNITE

5. Can we insert and delete rows into a View?

Yes
No
Rows of data can be inserted but can not deleted
Rows of data can be deleted but cacn not inserted

6. A ___________ is a prepared SQL code that you can save, so the code can be reused over and over again.

triggers
stored procedure
cursor
functions

7. Which view that contains more than one table in the top-level FROM clause of the SELECT statement:

Join view
Datable join view
Updatable join view
All of the mentioned

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

9. Choose the most suitable data type in case multiple data types are possible for the column.Column Name: Date_Of_Birth ; Description: Date of Birth of the employee ; Example: 1990/01/01

Timestamp
VARCHAR2(11)
Blob
Date

10. What is a subquery?

A subquery is a select-from-where expression that is nested within another query
A subquery is any query that is nested within another query
A subquery is a relation that is externally specified which can be used to handle data in queries
A subquery is a condition that excludes all the invalid tuples from the database

Results