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 can be a multivalued attribute?

Phone_number
Name
Date_of_birth
All of the mentioned

2. Point out the correct statement.

When a database is dropped, the master database should be backed up
You can drop a database currently being used
Dropping a database snapshot does not delete the database snapshot from an instance of SQL Server
None of the mentioned

3. What is the full form DML?

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

4. R(A,B,C,D) is a relation, Which of the following does not have a lossless join dependency preserving BCNF decomposition

A->B, B->CD
A->B, B->C,C->D
AB->C, C->AD
A->BCD

5. ERROR_SEVERITY() returns the ________level of the error.

State number
Full text
Severity
None of the above

6. Which of the following statement(s) is/are FALSE about primary key?

There can be more than one primary key for a table
Columns with string data types cannot be made Primary Key because they are large
Both A and B
None of the above

7. SELECT on a MERGE table is like _____________

UNION ALL
UNION
UNION DISTINCT
JOIN

8. Which of the following statements are TRUE?

Scale denotes number of digits allowed after decimal point
SQL performs rounding if user attempts to store a value that has higher scale than the data type
Both A and B
None of the above

9. In which type of recursion the application updates table T1. This fires trigger TR1, updating table T1. Because table T1 was updated, trigger TR1 fires again, and so on?

Indirect recursion
Direct recursion
Both A and B
None of the above

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

Results