What is the difference between a clustered and a non-clustered index? MCQ with Answer and Explanation

Question

Share Report Error

What is the difference between a clustered and a non-clustered index?

A. Clustered index determines physical order; non-clustered is a logical order

B. Non-clustered determines physical order; clustered is logical

C. There is no difference

D. They both determine physical order

Answer: Option A

Solution (By JKSSB Mock Tests)

A clustered index sorts the data rows and stores them in that order; a non-clustered index is a separate structure with pointers to data rows.

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 is the purpose of the SQL DISTINCT keyword?

A. To filter rows based on a condition

B. To sort the result set

C. To return only unique rows in the result set

D. To group the results

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
DISTINCT removes duplicate rows from the query result.

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

Question #2

A Primary Key in RDBMS must be:

A. Always a foreign key

B. Unique and not null

C. Can have null values

D. Duplicate values allowed

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A primary key uniquely identifies each record and cannot contain null values.

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

Question #3

RDBMS is based on which model?

A. Hierarchical model

B. Object-oriented model

C. Relational model

D. Network model

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Relational Database Management System (RDBMS) is based on the relational model proposed by E.F. Codd.

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

Explore All Database Management System (DBMS) MCQs