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. How many join types in join condition:

2
3
4
5

2. Relation R1 has 10 tuples and 5 attributes. Relation R2 has 0 tuples and 7 attributes. When a CROSS JOIN is achieved between R1 and R2, how many tuples would the resultant set have?

28
10
0
35

3. Which join is to be used between two tables A and B when the resultant table needs rows from A and B that matches the condition and rows from A that does not match the condition?

Outer Join
Cross Join
Inner Join
None of the above

4. Which requirements can be implemented using a CHECK constraint?

Customer must have a name
Two customers cannot have same email id
Both A and B
None of the above

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

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

Concurrency control scheme
Multiprogramming scheme
Serialization scheme
Schedule scheme

7. Find the error in this query.

CREATE VIEW student AS
    SELECT ID, name, branch name
    FROM Scholar;

View …as
Scholar
Select
None of the above

8. Which of the following statement(s) is/are FALSE about primary key?

There can be more than one primary key for a table
Columns with string data types cannot be made Primary Key because they are large
Both A and B
None of the above

9. Which Exception is also known as Oracle named exception handler?

Predefined Exception
Internal Exception
User defined Exception
None of the above

10. Is UNION or UNION ALL operator valid for LONG data type column?

True True
True False
False True
False False

Results