What is a composite index? MCQ with Answer and Explanation

Question
What is a composite index?
A. An index that is a primary key
B. An index on a view
C. An index on a single column
D. An index on multiple columns
Answer: Option D
Solution (By JKSSB Mock Tests)
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)
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 operator is used to check if a value is within a range?
A. IN
B. EXISTS
C. BETWEEN
D. LIKE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
BETWEEN checks if a value falls within a specified range (inclusive of boundaries).
This question belongs to: Computer Database Management System (DBMS)
Question #2
What type of key uniquely identifies each record in a table and cannot contain NULL values?
A. Primary Key
B. Candidate Key
C. Secondary Key
D. Foreign Key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Primary Key is a unique identifier for each tuple in a relation. It enforces entity integrity and strictly cannot accept NULL values.
This question belongs to: Computer Database Management System (DBMS)
Question #3
What is a domain in the context of the relational model?
A. A table name
B. A set of allowed values for an attribute
C. A primary key
D. A foreign key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A domain defines the set of permissible values that an attribute can take, ensuring data consistency.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Abbreviations 369 Computer Networking 325 Programming Languages 0 Microsoft Office 1199 Database Management System (DBMS) 278
Explore Subjects
Geography GK 6121 Current Affairs 575 Economy GK 2220 English 15164 Science 4430
Practice Mix
Simple interest on Rs. 1224000 for 3 years at 32% per annum is
Spot the error: 'These kind of mistakes are common.'
What is 'Edge Computing'?
If a:b = 4:10 and b:c = 10:12, then a:b:c = ?
The administrative position of 'Waqil' in the early Mughal hierarchy under Akbar was essentially equivalent to which role?