What is a composite index? MCQ with Answer and Explanation

What is a composite index?

A. An index on a single column

B. An index that is a primary key

C. An index on multiple columns

D. An index on a view

Answer: Option C

A composite index is created on two or more columns, often used to speed up queries that filter on those columns.

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

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

Question #1 Report Error

Which of the following is a DML statement?

A. UPDATE

B. DROP

C. CREATE

D. ALTER

Correct Answer: Option A

Explanation:
UPDATE is a Data Manipulation Language (DML) command used to modify existing records in a table. CREATE, ALTER, DROP are DDL.

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

Question #2 Report Error

Which of the following database models organizes data in a tree-like upside-down structure with parent-child relationships?

A. Network Model

B. Hierarchical Model

C. Relational Model

D. Object-Oriented Model

Correct Answer: Option B

Explanation:
The Hierarchical Model stores data in a tree-like configuration where each child node has exactly one parent node.

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

Question #3 Report Error

Which of the following is a way to avoid redundancy in a database?

A. Indexing

B. Normalization

C. Denormalization

D. Replication

Correct Answer: Option B

Explanation:
Normalization reduces redundancy by organizing data into tables with minimal duplication.

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