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 statements are TRUE regarding subqueries?

A subquery can retrieve zero or more rows
A subquery can appear on either side of a comparison operator
There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
Both A and B

2. In Oracle SQL no insert, update, or delete modifications on views are allowed that use one of the following constructs in the view definition:

Joins
Aggregate function such as sum, min, max etc.
group by clause or distinct clause
All of the above

3. 5NF is designed to cope with :

Transitive dependency
Join dependency
Multi valued dependency
None of these

4. The default exception will be handled using?

Default Keyword
WHEN THEN Keyword
WHEN Keyword
WHEN others THEN Keyword

5. The variables in the triggers are declared using

-
@
#
$

6. A functional dependency is a relationship between or among

Entities
Rows
Attributes
Tables

7. Indexes can also be unique?

Yes
No
Maybe
Can't say

8. Which of the following statement is TRUE about UNION?

Each query in a UNION can be sorted independently in different sort orders
All the queries in a UNION must be against the same table
UNION clause is used to subtract rows of second query from the first query
UNION and UNION ALL give same result if the participating queries are mutually exclusive

9. To specify a normal join, using the keyword inner is?

Mandatory
Optional
Independent
Free

10. A table that displays data redundancies yields ____________ anomalies.

Update
Insertion
Deletion
All of the Mentioned

Results