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. Which of the following is not a integrity constraint ?

Not null
Positive
Unique
Check predicate

2. Data integrity constraints are used to:

Control who is allowed access to the data
Ensure that duplicate records are not entered into the table
Improve the quality of data entered for a specific property (i.e., table column)
Prevent users from changing the values stored in the table

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

4. Views can be created for?

One table
Many table
another view
All of the above

5. All tuples in the relation are assigned null as the value for the new attribute, in the

Modify command
Tailor command
Eliminate command
Alter command

6. SQL has how many main commands for DDL:

1
2
3
4

7. Can we pass parameter in stored procedure?

We can pass both input and output parameters
We can not pass both input and output parameters
we can paas input parameter only
we can pass output parameter only

8. Which of the following triggers fire in response to the LOGON event that's raised when a user's session is being established?

Recursive Triggers
Multiple Triggers
Logon Trigger
Both A and C

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

10. What is the maximum value that can be stored in NUMERIC(4,2)?

9999.99
99.9999
99.99
9.99

Results