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 an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect ?

operationally, If Y is deleted, so is X
operationally, if X is deleted, Y remains the same
operationally, if X is deleted, so is Y
X existence is dependent on Y

2. Which of the following is the right syntax for the assertion?

CREATE ASSERTION [ assertion_name ] CHECK ( [ condition ] );
CREATE ASSERTION CHECK ( [ condition ] );
CREATE ASSERTION [ assertion_name ];
All of the mentioned

3. The scheme that controls the interaction between executing transactions is called as _____

Concurrency control scheme
Multiprogramming scheme
Serialization scheme
Schedule scheme

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

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

Not null
Positive
Unique
Check predicate

6. Which of the following is correct DROP INDEX Command?

DROP INDEX table_name;
DROP INDEX index_name;
DROP INDEX index_name or table_name;
DELETE INDEX index_name;

7. Indexes used to improve the performance.

YES
NO
Maybe
Can't say

8. Which prefixes are available to Oracle triggers?

: new only
: old only
Both A and B
None of the above

9. Which of the following is false?

We can update a view if it has multiple database relations in the from clause
One view can be used in the expression defining another view
Both A and B
None of the above

10. What is true statement while Updating a View?

The SELECT clause may not contain the keyword DISTINCT.
The SELECT clause may not contain summary functions.
The SELECT clause may not contain set functions.
All of the above

Results