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. A relation is in 2NF if:

All the values of non-key attributes are dependent fully on the candidate key.
Any non-key attribute that are dependent on only part of the candidate key should be moved to another relation where the partial key is the actual full key.
It must be already in the 1NF.
All of the above.

2. Which of the following is the right syntax for the assertion?

CREATE ASSERTION [ assertion_name ] CHECK ( [ condition ] );
CREATE ASSERTION CHECK ( [ condition ] );
CREATE ASSERTION [ assertion_name ];
All of the mentioned

3. Choose the most suitable data type in case multiple data types are possible for the column.Column Name: Date_Of_Birth ; Description: Date of Birth of the employee ; Example: 1990/01/01

Timestamp
VARCHAR2(11)
Blob
Date

4. Which statement is TRUE regarding ALTER statement?

ALTER TABLE cannot be used to remove a column
ALTER table can be used to change size of data type, not the data type itself
ALTER table can be used to add a column but it must be NOT NULL
None of the above

5. Which of the following statement(s) is/are FALSE about OLAP?

OLAP involves long running slow transactions that read lot of data
OLAP involves frequent insert, update and delete operations
OLAP requires data to be in De-Normalized form for optimal processing
Both B and C

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

Query
DML
Relational
DDL

7. Can we insert and delete rows into a View?

Yes
No
Rows of data can be inserted but can not deleted
Rows of data can be deleted but cacn not inserted

8. You want to track date and time of the last write access per row?

Add TIMESTAMP column to the table
Add a DATETIME column to the table and assign getdate() as the default value
Add a DATETIME column to the table and write a trigger that sets its value
Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server's built-in functions

9. Referential triggered action clause in Standard Query Language is attached to constraint called

primary key constraint
stamped key constraint
interval notation constraint
foreign key constraint

10. Which of the following is a single valued attribute?

Register_number
Address
SUBJECT_TAKEN
Reference

Results