What is the main purpose of indexing in a database? MCQ with Answer and Explanation

Question

Share Report Error

What is the main purpose of indexing in a database?

A. To encrypt data

B. To speed up data retrieval

C. To backup data

D. To delete data

Answer: Option B

Solution (By JKSSB Mock Tests)

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

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

Which SQL command is used to add new rows of data into an existing table?

A. INSERT

B. APPEND

C. UPDATE

D. ADD

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The INSERT command is a Data Manipulation Language (DML) statement used to add new records/rows to a table.

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

Question #2

What is a synonym in database terms?

A. An alias for a table or view

B. A foreign key

C. A type of index

D. A data type

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A synonym is an alternative name for a database object, allowing simpler references.

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

Question #3

What is a 'foreign key' constraint specifically designed to prevent?

A. Actions that would destroy links or introduce invalid references between tables.

B. Slow search execution times.

C. Unauthorized login attempts to the database.

D. The use of duplicate data values within the primary key column.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Foreign Key constraint enforces referential integrity, preventing updates or deletions that would leave orphaned child records pointing to non-existent parent rows.

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

Explore All Database Management System (DBMS) MCQs