Login / Signup

Question

In a 'clustered' index on a database table, what distinguishes it from a non-clustered index?

A It can only be created on numeric columns

B It always requires more storage space than a non-clustered index on the same table

C A table can have any number of clustered indexes simultaneously

D It cannot be used to speed up range queries

E The actual data rows of the table are physically stored on disk in the same order as the index key

Practice Next

More IT DBMS Questions

In two-phase locking, a transaction releases its locks:
What is the purpose of 'indexing' in a database?
A company needs to schedule a maximum number of meetings in a single conference room. Each meeting `i` has a start time `s_i` and an finish time `f_i`. Onc...
In SQL, which clause is used to filter groups of rows after aggregate functions (such as SUM, COUNT, or AVG) have been applied?
Consider the following Java-like pseudo-code for inserting a node into a Binary Search Tree (BST): ```java class Node { int data; ...
Phantom Reads occur when:
What is a primary key in a relational database?
Which of the following illustrates an advantage of DBMS over traditional file systems?
The command to test reachability of a host in Linux is:
What is the primary purpose of creating an index on a database table column?

Hey! Ask a query

ask-question

🎓

Think You're Ready for RBI Grade B?

RBI Grade B 2026 Phase 1 Memory Based Paper

200 Questions with Detailed Solutions
Section-wise Coverage (GA, English, Quant & Reasoning)

Download Now 100% Free PDF