Welcome to the SQL MCQs Page

Dive deep into the fascinating world of SQL with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of SQL, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of SQL, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

Check out the MCQs below to embark on an enriching journey through SQL. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of SQL. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

SQL MCQs | Page 3 of 38

Explore more Topics under DBMS

01

DBMS Basics

02

Data Models

03

The Entity Relationship Approach

04

Relational Databases

05

Data Storage and Querying

06

Relational Algebra

07

Normalization

08

Storage and File Structures

09

Indexing and Hashing

10

Transactions

11

Concurrency Control

12

Recovery System

13

Distributed Databases

14

Data Warehousing and Data Mining

15

RDBMS

16

Advanced SQL

17

SQL Queries,Constraints and Triggers

Q21.

Which of the join operations do not preserve non matched tuples.

Left outer join

Right outer join

Inner join

None of the above

Discuss

Answer: (c).Inner join

Q22.

What type of join is needed when you wish to include rows that do not have matching values?

Equi-join

Natural join

Outer join

All of the mentioned

Discuss

Answer: (c).Outer join

Q23.

How many join types in join condition:

Discuss

Answer: (d).5

Q24.

Which join refers to join records from the right table that have no matching key in the left table are include in the result set:

Left outer join

Right outer join

Full outer join

Half outer join

Discuss

Answer: (b).Right outer join

Q25.

In SQL the statement select * from R, S is equivalent to

Select * from R natural join S

Select * from R cross join S

Select * from R union join S

Select * from R inner join S

Discuss

Answer: (b).Select * from R cross join S

Q26.

Which join condition contains an equality operator:

Equijoins

Cartesian

Natural

Left

Discuss

Answer: (a).Equijoins

Q27.

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

Procedures

Triggers

Functions

None of the mentioned

Discuss

Answer: (b).Triggers

Q28.

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

for insert, on

On, for insert

For, insert

Both a and c

Discuss

Answer: (b).On, for insert

Q29.

What are the after triggers ?

Triggers generated after a particular operation

These triggers run after an insert, update or delete on a table

These triggers run after an insert, views, update or delete on a table

Both b and c

Discuss

Answer: (b).These triggers run after an insert, update or delete on a table

Q30.

The variables in the triggers are declared using

Discuss

Answer: (b).@

Page 3 of 38

Welcome to the SQL MCQs Page

SQL MCQs | Page 3 of 38

Explore more Topics under DBMS

DBMS Basics

Data Models

The Entity Relationship Approach

Relational Databases

Data Storage and Querying

Relational Algebra

Normalization

Storage and File Structures

Indexing and Hashing

Transactions

Concurrency Control

Recovery System

Distributed Databases

Data Warehousing and Data Mining

RDBMS

Advanced SQL

SQL Queries,Constraints and Triggers

Suggested Topics

Digital Communication

Software Engineering

Human Computer Interaction

Operating System

Formal Languages and Automata Theory

Computer Hardware

Digital Image Processing (DIP)

Embedded Systems

Java Programming