DBMS MCQs with Answers and Explanations

Question #21

Share Report

The command to modify existing records in a table is:

A. UPDATE

B. ALTER

C. CHANGE

D. MODIFY

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
UPDATE is the DML command used to modify data in existing rows.

This question belongs to: Computer Database Management System (DBMS)

Question #22

Share Report

Which normal form eliminates transitive dependencies?

A. 3NF

B. BCNF

C. 2NF

D. 1NF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Third Normal Form (3NF) removes transitive dependencies on non-prime attributes.

This question belongs to: Computer Database Management System (DBMS)

Question #23

Share Report

What is metadata?

A. Temporary data

B. Data about data

C. Backup data

D. User data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Metadata is data that provides information about other data, such as structure and constraints.

This question belongs to: Computer Database Management System (DBMS)

Question #24

Share Report

In SQL, the WHERE clause is used in:

A. SELECT, UPDATE, DELETE statements

B. Only INSERT statements

C. Only CREATE statements

D. Only SELECT statements

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
WHERE clause filters records in SELECT, UPDATE, and DELETE operations.

This question belongs to: Computer Database Management System (DBMS)

Question #25

Share Report

A view in DBMS is:

A. A virtual table based on the result of a query

B. A backup of the database

C. An index on the table

D. A physical copy of the table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A view is a virtual table derived from one or more base tables.

This question belongs to: Computer Database Management System (DBMS)

Question #26

Share Report

Which of the following ensures data integrity in RDBMS?

A. No validation rules

B. Random data entry

C. Constraints like primary key, foreign key

D. User input without checks

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Integrity constraints such as keys enforce rules for valid data.

This question belongs to: Computer Database Management System (DBMS)

Question #27

Share Report

What is the main purpose of indexing in a database?

A. To delete data

B. To backup data

C. To speed up data retrieval

D. To encrypt data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Indexes improve the speed of data retrieval operations on a database table.

This question belongs to: Computer Database Management System (DBMS)

Question #28

Share Report

DCL commands in SQL include:

A. CREATE and DROP

B. INSERT and UPDATE

C. GRANT and REVOKE

D. SELECT and JOIN

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Data Control Language (DCL) commands manage access permissions.

This question belongs to: Computer Database Management System (DBMS)

Question #29

Share Report

Which model represents data in the form of tables?

A. Network model

B. Entity-Relationship model only

C. Relational model

D. Hierarchical model

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The relational model uses tables (relations) to represent data and relationships.

This question belongs to: Computer Database Management System (DBMS)

Question #30

Share Report

Information is:

A. Programming code

B. Hardware component

C. Processed and meaningful form of data

D. Raw facts and figures

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Information is data that has been organized and processed to provide context and meaning.

This question belongs to: Computer Database Management System (DBMS)

Question #31

Share Report

The JOIN operation in SQL is used to:

A. Combine rows from two or more tables

B. Create a new database

C. Sort data

D. Delete rows

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
JOIN combines data from multiple tables based on related columns.

This question belongs to: Computer Database Management System (DBMS)

Question #32

Share Report

Which of the following is a collection of related data that is stored in a structured format?

A. DBMS

B. Database

C. Data warehouse

D. Information

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A database is an organized collection of related data, typically stored electronically and accessed through a DBMS.

This question belongs to: Computer Database Management System (DBMS)

Question #33

Share Report

Which of the following is an example of a DBMS?

A. MySQL

B. Google Docs

C. Windows 10

D. Microsoft Excel

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MySQL is a popular relational database management system (RDBMS). Excel is a spreadsheet, not a DBMS.

This question belongs to: Computer Database Management System (DBMS)

Question #34

Share Report

In the context of databases, what is a 'tuple'?

A. A table itself

B. A row of a table

C. A key constraint

D. A column of a table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In relational databases, a tuple is a single row or record of a table.

This question belongs to: Computer Database Management System (DBMS)

Question #35

Share Report

What is the term for a column in a database table?

A. Attribute

B. Relation

C. Entity

D. Tuple

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
An attribute is a column or field in a table, representing a property of the entity.

This question belongs to: Computer Database Management System (DBMS)

Question #36

Share Report

Which language is used to define the structure of a database, such as creating tables and constraints?

A. TCL

B. DML

C. DDL

D. DCL

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Data Definition Language (DDL) is used to define and modify the database schema, including CREATE, ALTER, and DROP statements.

This question belongs to: Computer Database Management System (DBMS)

Question #37

Share Report

Which SQL statement is used to retrieve data from a database?

A. DELETE

B. UPDATE

C. INSERT

D. SELECT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SELECT is the SQL command used to query and retrieve data from one or more tables.

This question belongs to: Computer Database Management System (DBMS)

Question #38

Share Report

What does ACID stand for in the context of database transactions?

A. Atomicity, Consistency, Isolation, Durability

B. Atomicity, Consistency, Integrity, Data

C. Atomicity, Concurrency, Isolation, Durability

D. Atomicity, Consistency, Integrity, Durability

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
ACID stands for Atomicity, Consistency, Isolation, and Durability, which are the key properties that guarantee reliable processing of database transactions.

This question belongs to: Computer Database Management System (DBMS)

Question #39

Share Report

Which property of ACID ensures that a transaction is treated as a single unit that either fully succeeds or fully fails?

A. Consistency

B. Atomicity

C. Durability

D. Isolation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Atomicity ensures that all operations within a transaction are completed successfully; otherwise, the transaction is aborted and all changes are rolled back.

This question belongs to: Computer Database Management System (DBMS)

Question #40

Share Report

What is a primary key in a database table?

A. A key that uniquely identifies each row in a table

B. A key that can contain duplicate values

C. A key that references a column in another table

D. A key that is always numeric

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A primary key is a column or set of columns that uniquely identifies each row in a table, ensuring entity integrity.

This question belongs to: Computer Database Management System (DBMS)

Database Management System (DBMS) MCQs

Practice Questions

More Computer Topics