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


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. Updates that violate __________ are disallowed .

Integrity constraints
Transaction control
DDL constraints

2. What is a correlated sub-query?

An independent query that uses the correlation name of another independent query.
A sub-query that uses the correlation name of an outer query
A sub-query that substitutes the names of the outer query
A sub-query that does not depend on its outer query's correlation names

3. To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?


4. E-R modeling technique is a :

Top-down approach
Bottom-up approach
Left-right approach
None of the above

5. What is true statement while Updating a View?

The SELECT clause may not contain the keyword DISTINCT.
The SELECT clause may not contain summary functions.
The SELECT clause may not contain set functions.
All of the above

6. Which of the following is condition where indexes be avoided?

Indexes should not be used on small tables
Tables that have frequent, large batch updates or insert operations
Columns that are frequently manipulated should not be indexed.
All of the above

7. Choose the most appropriate choice with respect to conceptual design.

Conceptual design is a documentation technique. Once the relation schemes are defined one can draw E-R diagrams from the relation schemes for documentation
Conceptual design needs data volumn and processing frequencies to determine the size of the database
Output of any conceptual design is an E-R diagram
Conceptual design involves modeling the data requirements independent of the DBMS, operating system and the hardware.

8. Which clause is used to sort a UNION result as a whole?


9. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect ?

operationally, If Y is deleted, so is X
operationally, if X is deleted, Y remains the same
operationally, if X is deleted, so is Y
X existence is dependent on Y

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