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.

Introduction to SQL

Bestseller by Coursera

You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation.

16 Hours
Paid

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 correct processing technique for the given statements.
Identify profit trends for different units of organization over years

OLTP
OLAP
OLAM
None of the above

2. What is xyz in the following SQL statement? SELECT xyz FROM table1 UNION xyz FROM table2;

row name
column name
table name
database name

3. The number of entities to which another entity can be associated via a relationship set is expressed as :

Entity
Cardinality
Schema
Attributes

4. TRUNCATE statement in SQL is a

DDL
DML
DCL
TCL

5. What is true about order by with Union operator?

Order By can be issued in each result set.
It can be issued for the overall result set.
Both A & B.
None of the above

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

7. Domain constraints, functional dependency and referential integrity are special forms of _________

Foreign key
Primary key
Assertion
Referential constraint

8. Which of the following statement(s) is TRUE regarding subqueries?

Inner queries in WHERE clause can contain ORDER BY
Outer query and inner query can get data from different tables
Outer query and inner query must get data from the same table
Inner queries cannot contain GROUP BY clause

9. Indexes used to improve the performance.

YES
NO
Maybe
Can't say

10. Which functional dependency types is/are not present in the following dependencies?
Empno -> EName, Salary, Deptno, DName
DeptNo -> DName
EmpNo -> DName

Full functional dependency
Partial functional dependency
Transitive functional dependency
Both B and C

Results