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

2. Choose the most suitable data type in case multiple data types are possible for the column. Column Name: Gender ; Description: A single character; gender code, M or F Example: M

CHAR(11)
VARCHAR2(50)
CHAR(1)
VARCHAR2(1)

3. Command that is used to add attributes to an existing relation, is said to be

Alter
Modify
Tailor
Eliminate

4. Which of the following statements are TRUE?

A Unique constraint allows multiple rows to have NULL value
Integrity constraint can be added to a table even if table data is in violation
A PRIMARY KEY allows a single row to contain NULL
Both A and B

5. Evaluate this SQL statement: In the statement, which capabilities of a SELECT statement are performed?

SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME
FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;

Selection, projection, join
Difference, projection, join
Selection, intersection, join
Intersection, projection, join

6. Which of the following is not a type of SQL statement?

DML
DDL
DCL
DCI

7. Which of the following is an advantage of database management approach?

Data is dependent on programs
Data redundancy increases
Data can be accessed by multiple programs
Multiple users cannot access data concurrently

8. Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained:

TRUNCATE command
Create command
Drop table command
Alter table command

9. Indexes can also be unique?

Yes
No
Maybe
Can't say

10. SQL has how many main commands for DDL:

1
2
3
4

Results