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. In contemporary databases, the top level of the hierarchy consists of ______ each of which can contain _____

Catalogs, schemas
Schemas, catalogs
Alter typeEnvironment, schemas
Schemas, Environment

2. The default extension for an Oracle SQL*Plus file is:

.txt
.html
.css
.sql

3. When a referential-integrity constraint is violated, the normal procedure is to

Continue with flow
Accept the action
Reject the action
Store it for evaluation

4. OLD and NEW references are available for table-level triggers

TRUE
FALSE
Can be true or false
Can not say

5. A _______ index is an index on two or more columns of a table.

Implicit
Unique
single-column
Composite

6. Which of the following statements are False regarding subqueries?

Only two subqueries can be placed at one level
A subquery can appear on either side of a comparison operator
Both A and B
None of the above

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

8. Which of the following specifies when the trigger will be executed?

BEFORE
AFTER
INSTEAD OF
All of the above

9. Which of the following statement is FALSE about transaction?

Once the data is committed it can be rolled back
All operations within the transaction must all succeed or fail
Transaction includes at least one statement
Transaction changes the database from one consistent state to another

10. Which of the following statements does not change the state of the database?

Where
Select
Insert
Drop

Results