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 4 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

Q31.

The default extension for an Oracle SQL*Plus file is:

.txt

.pls

.ora

.sql

Discuss

Answer: (d)..sql

Q32.

Triggers ________ enabled or disabled.

Can be

Cannot be

Ought to be

Always

Discuss

Answer: (a).Can be

Q33.

To include integrity constraint in a existing relation use :

Create table

Modify table

Alter table

Any of the above

Discuss

Answer: (c).Alter table

Q34.

Which of the following is not a integrity constraint ?

Not null

Positive

Unique

Check ‘predicate’

Discuss

Answer: (b).Positive

Q35.

Which of the following is the right syntax for assertion?

Create assertion 'assertion-name' check 'predicate';

Create assertion check 'predicate' 'assertion-name';

Create assertions 'predicates';

All of the mentioned

Discuss

Answer: (a).Create assertion 'assertion-name' check 'predicate';

Q36.

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 custome

When entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)

Discuss

Answer: (c).Information on the customer must be known before anything can be sold to that custome

Q37.

Drop Table cannot be used to drop a table referenced by a _________ constraint.

Local Key

Primary Key

Composite Key

Foreign Key

Discuss

Answer: (d).Foreign Key

Q38.

____________ is preferred method for enforcing data integrity.

Constraints

Stored Procedure

Triggers

Cursors

Discuss

Answer: (a).Constraints

Q39.

SQL stands for ________ .

Structured Query Language

Sequential Query Language

Structured Question Language

Sequential Question Language

Discuss

Answer: (a).Structured Query Language

Q40.

The SQL command to create a table is:

MAKE TABLE.

ALTER TABLE.

DEFINE TABLE.

CREATE TABLE.

Discuss

Answer: (d).CREATE TABLE.

Page 4 of 38

Welcome to the SQL MCQs Page

SQL MCQs | Page 4 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

Software Engineering

MS Office

DBMS

Software Architecture and Design

Computer Hardware

HTML

MATLAB

Wireless and Mobile Communications

Reverse Engineering