What is the purpose of a database index? MCQ with Answer and Explanation

Question

Share Report Error

What is the purpose of a database index?

A. To define relationships

B. To enforce uniqueness

C. To store large objects

D. To speed up data retrieval operations

Answer: Option D

Solution (By JKSSB Mock Tests)

Indexes are primarily used to improve the speed of data retrieval, particularly for search queries.

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

Share Report

An attribute whose value is computed dynamically from another attribute (such as calculating Age from Date_of_Birth) is called a what?

A. Stored Attribute

B. Base Attribute

C. Derived Attribute

D. Multi-valued Attribute

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Derived Attribute is an attribute whose values are not stored physically in the database but are calculated at runtime from other stored attributes.

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

Question #2

Share Report

In an Entity-Relationship (ER) diagram, attributes are represented using which shape?

A. Rectangle

B. Square

C. Ellipse/Oval

D. Diamond

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ellipses or ovals are used to represent attributes (properties) of entities in ER diagrams.

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

Question #3

Share Report

What is the difference between a database and a data warehouse?

A. Databases store current data; data warehouses store historical data

B. They are the same

C. Both A and B

D. Databases are for OLTP, data warehouses for OLAP

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Databases are optimized for transaction processing (OLTP), while data warehouses are designed for analytical reporting (OLAP) using historical data.

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

Explore All Database Management System (DBMS) MCQs