Database Management System (DBMS) MCQs

Practice DBMS MCQs covering database, data, information, DBMS, RDBMS and SQL basics with answers and explanations.

278 Total

Question #31 Report Error

The JOIN operation in SQL is used to:

A. Delete rows

B. Create a new database

C. Combine rows from two or more tables

D. Sort data

View Answer & Solution Discuss

Correct Answer: Option C

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

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

Question #32 Report Error

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

A. Data warehouse

B. Information

C. Database

D. DBMS

View Answer & Solution Discuss

Correct Answer: Option C

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 Report Error

Which of the following is an example of a DBMS?

A. Google Docs

B. MySQL

C. Windows 10

D. Microsoft Excel

View Answer & Solution Discuss

Correct Answer: Option B

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 Report Error

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

A. A table itself

B. A row of a table

C. A column of a table

D. A key constraint

View Answer & Solution Discuss

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 Report Error

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

A. Entity

B. Attribute

C. Tuple

D. Relation

View Answer & Solution Discuss

Correct Answer: Option B

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 Report Error

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

A. DDL

B. TCL

C. DCL

D. DML

View Answer & Solution Discuss

Correct Answer: Option A

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 Report Error

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

A. UPDATE

B. SELECT

C. INSERT

D. DELETE

View Answer & Solution Discuss

Correct Answer: Option B

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 Report Error

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

A. Atomicity, Consistency, Integrity, Data

B. Atomicity, Consistency, Isolation, Durability

C. Atomicity, Consistency, Integrity, Durability

D. Atomicity, Concurrency, Isolation, Durability

View Answer & Solution Discuss

Correct Answer: Option B

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 Report Error

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

A. Atomicity

B. Durability

C. Consistency

D. Isolation

View Answer & Solution Discuss

Correct Answer: Option A

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)