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. The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DB

DDL
DML
DDL And DCL
DCL And DML

2. How many types of exception are there in sql?

2
3
4
5

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

4. How many types of triggers are present in SQL Server?

2
3
4
5

5. Choose a data type to store weight of a person in kilograms with accuracy of 1 gram. As per wikipedia, Jon Brower Minnoch was the heaviest human ever recorded with a weight of 635kg.

NUMBER(3,3)
NUMBER(3,2)
NUMBER(6,2)
NUMBER(6,3)

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

7. Every weak entity set can be converted to a strong entity set by :

Using generalization
Simply adding appropriate attribute
Using aggregation
Repeating the entity set several times

8. What is the full form DML?

data manipulation language
data manipulate language
data many language
data manipulation load

9. SQL Server allows for Transact-SQL stored procedures, triggers, and batches to refer to tables that don't exist at compile time. This ability is called?

Indeferred Name Resolution
Deferred Name Permissions
Deferred Name Resolution
Indeferred Name Permissions

10. Which of the following can be a multivalued attribute?

Phone_number
Name
Date_of_birth
All of the mentioned

Results