Which of the following is a true statement about indexes? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a true statement about indexes?

A. Indexes cannot be created on views

B. Indexes are only used for primary keys

C. Indexes always improve performance

D. Indexes improve the speed of SELECT queries but can slow down INSERT, UPDATE, and DELETE operations

Answer: Option D

Solution (By JKSSB Mock Tests)

Indexes speed up data retrieval but require additional maintenance during data modifications, which can slow down DML operations.

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

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

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

A. Atomicity, Concurrency, Isolation, Durability

B. Atomicity, Consistency, Isolation, Durability

C. Atomicity, Consistency, Integrity, Data

D. Atomicity, Consistency, Integrity, Durability

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

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 #2

What is the purpose of the SQL 'JOIN' clause?

A. To delete records from a table

B. To combine rows from two or more tables based on a related column

C. To combine columns from multiple tables into a single table

D. To create a new table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
JOIN is used to combine rows from different tables based on a common column, allowing querying across related tables.

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

Question #3

Which normal form enforces that no non-prime attribute depends on a subset of a candidate key?

A. 3NF

B. BCNF

C. 2NF

D. 1NF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
2NF eliminates partial dependencies, i.e., non-prime attributes dependent on part of any candidate key.

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

Explore All Database Management System (DBMS) MCQs