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. If we know the records returned by our query are unique then which operator will be preferred out of UNION or UNION ALL?

UNION
UNION ALL
Both A and B
None of the above

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

3. The most easily tested constraints of a new data entered is into a database is called?

referential constraints
domain constraints
assertion
None of these

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

Phone_number
Name
Date_of_birth
All of the mentioned

5. Consider the schema R(S,T,U,V) and the dependencies S→T, T→U, U→V, V→S. Let R= {R1,R2} such that R1∩R2=Φ. Then the decomposition is :

not in 2NF
in 2NF but not in 3NF
in 3NF but not in 2NF
in both 2NF and 3NF

6. Choose the most suitable data type in case multiple data types are possible for the column. Column Name: PIN_Code ; Description: Six digit numeric PIN code for any address in India ; Example: 560100

Integer
VARCHAR2(11)
CHAR(11)
Number(6)

7. Which of the following statement(s) is/are true about OLAP?

OLAP involves long running slow transactions that read lot of data
OLAP requires complex joins to aggregate data from multiple tables
OLAP requires data to be in De-Normalized form for optimal processing
Both A and C

8. A ______ index is created based on only one table column.

Implicit
Unique
single-column
Composite

9. A_____ is a query that retrieves rows from more than one table or view

Start
End
Join
All of the above

10. Which statement would add a column CGPA to a table Student which is already created

ALTER TABLE Student ADD COLUMN (CGPA NUMBER(3,1));
ALTER TABLE Student CGPA NUMBER(3,1);
ALTER TABLE Student ADD (CGPA NUMBER(3,1));
Both A and C

Results