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

2. The default extension for an Oracle SQL*Plus file is:

.txt
.html
.css
.sql

3. Can we use index on columns that contain a high number of NULL values?

YES
NO
Only Implicit Indexes can be used
Only Composite Indexes can be used.

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

LIMIT
ORDER BY
GROUP BY
SORT

5. The set of permitted values of an attribute is called

Tuple
Domain
Column
Table

6. Which of the following statement removes sales and suppliers database?

DROP DATABASE Sales, NewSales
DROP DATABASE Sales, suppliers
DROP DATABASE Sales and suppliers
DROP DATABASE Sales-suppliers

7. The Entity Customer has three candidate keys: a) CustId b) Email and c) ContactNo. Suggest the best primary key for this entity.

CustId
Email
ContactNo
CustId and ContactNo

8. _______ views help to keep the database up-to-date.

View materialization
View isolation
View updating
View maintenance

9. Which of the following statements are true?

INNER JOIN only retrieves those rows from Cartesian Product that satisfy the JOIN condition
FULL OUTER JOIN is same as CROSS JOIN
SELF JOIN is a special type of OUTER JOIN
Both A and C

10. Data manipulation language (DML) includes statements that modify the _____ of a database.

Structure
Data
User
Size

Results