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 is one of the basic approaches for joining tables?

Subqueries
Union Join
Natural join
All of the above

2. Choose the correct processing technique for the given statements.
Identify correlation between salary structure and policies sold made by Insurance agents in an organization.

OLTP
OLAP
OLAM
None of the above

3. Relation R1 has 10 tuples and 5 attributes. Relation R2 has 0 tuples and 7 attributes. When a CROSS JOIN is achieved between R1 and R2, how many tuples would the resultant set have?

28
10
0
35

4. Consider two statements about outer and inner queries in context of SQL sub-queries?
i. The inner queries can get data from only one table
ii. The inner queries can get data from more than one table Which of the above statements are true?

Only i
Only ii
Both i and ii
None of the above

5. What is syntax for delete the view?

DELETE VIEW view_name;
DROP VIEW view_name/table_name;
DROP VIEW view_name;
DROP VIEW table_name;

6. The following SQL is which type of join?

SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T

Equi-join
Natural join
Outer join
Cartesian join

7. This set of Database Questions & Answers focuses on “SQL Data Types and Schemas” Dates must be specified in the format

mm/dd/yy
yyyy/mm/dd
dd/mm/yy
yy/dd/mm

8. Which of the following is not an integrity constraint?

Not null
Positive
Unique
Check predicate

9. Which join is to be used between two tables A and B when the resultant table needs rows from A and B that matches the condition and rows from A that does not match the condition?

Outer Join
Cross Join
Inner Join
None of the above

10. The ______ construct returns true if a given tuple is present in the subquery.

not exists
present
not present
exists

Results