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 prefixes are available to Oracle triggers?

: new only
: old only
Both A and B
None of the above

2. A ______ index is created based on only one table column.

Implicit
Unique
single-column
Composite

3. Which of the following is one of the basic approaches for joining tables?

Subqueries
Union Join
Natural join
All of the above

4. How non clustered index point to the data?

It never points to anything
It points to a data row
It is used for pointing data rows containing key values
All of the above

5. Which of the following creates a virtual relation for storing the query?

Function
View
Procedure
All of the above

6. Insert into Business values (10211, "Jhon", "Chemist", 66000); What type of statement is this ?

Query
DML
Relational
DDL

7. Which of the following statement removes database including its related components?

DROP DATABASE
DELETE DATABASE
REMOVE DATABASE
None of the mentioned

8. Which of the following is false?

We can update a view if it has multiple database relations in the from clause
One view can be used in the expression defining another view
Both A and B
None of the above

9. An association of several entities in an Entity-Relation model is called :

Tuple
Record
Relationship
Field

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

Results