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

Q121.

Which command(s) is(are) used to redefine a column of the table in SQL ?

ALTER TABLE

DEFINE TABLE

MODIFY TABLE

All of the above

Discuss

Answer: (a).ALTER TABLE

Q122.

Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

DEFINE TABLE

MODIFY TABLE

ALTER TABLE

All of the above

Discuss

Answer: (c).ALTER TABLE

Q123.

In SQL, the ALTER TABLESPACE command is used

to add/rename data files

to change storage characteristics

to take a tablespace online/offline

All of the above

Discuss

Answer: (d).All of the above

Q124.

In SQL, which command(s) is(are) used to create a synonym for a schema object?

CREATE SCHEMA

CREATE SYNONYM

CREATE SAME

All of the above

Discuss

Answer: (b).CREATE SYNONYM

Q125.

In SQL, which of the following is not a data Manipulation Language Commands?

DELETE

SELECT

UPDATE

CREATE

Discuss

Answer: (d).CREATE

Q126.

In SQL, the CREATE VIEW command is used

to recompile view

to define a view of one or more tables or views

to recompile a table

to create a trigger

Discuss

Answer: (b).to define a view of one or more tables or views

Q127.

In SQL, which command is used to create a database user?

ADD USER TO DATABASE

MK USER

CREATE USER

All of the above

Discuss

Answer: (c).CREATE USER

Q128.

In SQL, which command(s) is(are) used to redefine an index's future storage allocation

ALTER INDEX

REDEFINE INDEX

MODIFY INDEX

DO INDEX

Discuss

Answer: (a).ALTER INDEX

Q129.

In SQL, which command is used to select data in rows and column from one or more tables?

CHOOSE

SELECT

LIST

BROWSE

Discuss

Answer: (b).SELECT

Q130.

The _____ command is used to allocates an extent for the table in SQL

MODIFY ALLOCATES

MODIFY TABLE

ALTER TABLE

REDEFINE TABLE

Discuss

Answer: (a).MODIFY ALLOCATES

Page 13 of 38

Welcome to the SQL MCQs Page

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

HTML

PHP

UNIX

DBMS

Microprocessor

Digital Communication

IT Fundamentals

C# programming

Digital Logic Design