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. Determine data type for the given column? Column Name: Price ; Description: Cost of an item in rupees and paise ; Example: 200.21

VARCHAR2(50)
NUMBER
NUMBER(5,2)
NUMBER(6)

2. A SELECT statement can be used to perform these three functions:
- Choose rows from a table.
- Choose columns from a table.
- Bring together data that is stored in different tables by creating a link between them.
Which set of keywords describes these capabilities?

difference, projection, join
selection, projection, join
Selection, intersection, join
Intersection, projection, join

3. The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DB

DDL
DML
DDL And DCL
DCL And DML

4. Every weak entity set can be converted to a strong entity set by :

Using generalization
Simply adding appropriate attribute
Using aggregation
Repeating the entity set several times

5. Which join is equivalent to Cartesian Product?

INNER JOIN
OUTER JOIN
CROSS JOIN
NATURAL JOIN

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

7. A relational database consists of a collection of

Table
Record
Fields
Attributes

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 one of the basic approaches for joining tables?

Subqueries
Union Join
Natural join
All of the above

10. Foreign key is the one in which the ________ of one relation is referenced in another relation.

Foreign key
Primary key
References
Check constraint

Results