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

Share Report

A table is in Third Normal Form (3NF) if it is in 2NF and has absolutely no non-prime attributes that exhibit what type of dependency?

A. Partial Dependency

B. Join Dependency

C. Trivial Dependency

D. Transitive Dependency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Third Normal Form (3NF) requires a relation to be in 2NF with no transitive dependencies, meaning non-prime attributes cannot be determined by other non-prime attributes.

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

Question #2

Share Report

Which SQL operator allows you to check if a column value matches any item contained within a comma-separated list of explicit values?

A. IN

B. EXISTS

C. LIKE

D. BETWEEN

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The IN operator allows you to specify multiple literal values or a subquery inside a WHERE clause, testing if an attribute matches any element in the list.

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