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. Constraints are the preferred method for enforcing data

data topple
data integrity
data inheritance
None of the above

2. Here the tuples are selected from the view.Which one denotes the view.

SELECT course_id
FROM physics_fall_2009
WHERE building= ’Watson’;

Course_id
Building
Watson
physics_fall_2009

3. The relationship between the two tables are created using __________

Candidate Key
Primary Key
Foreign Key
Check Constraint

4. Choose the most appropriate choice with respect to conceptual design.

Conceptual design is a documentation technique. Once the relation schemes are defined one can draw E-R diagrams from the relation schemes for documentation
Conceptual design needs data volumn and processing frequencies to determine the size of the database
Output of any conceptual design is an E-R diagram
Conceptual design involves modeling the data requirements independent of the DBMS, operating system and the hardware.

5. Which of the following statements are False?

RIGHT OUTER JOIN is equivalent to LEFT OUTER JOIN if order of tables are reversed
FULL OUTER JOIN is same as CROSS JOIN
SELF JOIN is a special type of OUTER JOIN
Both B and C

6. Choose the most suitable data type in case multiple data types are possible for the column. Column Name: Gender ; Description: A single character; gender code, M or F Example: M

CHAR(11)
VARCHAR2(50)
CHAR(1)
VARCHAR2(1)

7. Which of the following statement(s) is TRUE regarding subqueries?

Inner queries in WHERE clause can contain ORDER BY
Outer query and inner query can get data from different tables
Outer query and inner query must get data from the same table
Inner queries cannot contain GROUP BY clause

8. Which of the following can be addressed by enforcing a referential integrity constraint?

All phone numbers must include the area code
Certain fields are required (such as the email address, or phone number) before the record is accepted
Information on the customer must be known before anything can be sold to that customer
When entering an order quantity, the user must input a number and not some text

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

10. Which of the following statements does not change the state of the database?

Where
Select
Insert
Drop

Results