Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 402 |
In clustering index, the number of index entries is same as the number of:
| Attributes in data file | |
| Records in data file | |
| Blocks in data file | |
| Distinct index field values |
Question 402 Explanation:
An Index is a key built from one or more columns in the database that speeds up fetching rows from the table or view.
Cluster index is a type of index which sorts the data rows in the table on their key values. In the Database, there is only one clustered index per table.
A clustered index defines the order in which data is stored in the table which can be sorted in only one way. So, there can be an only a single clustered index for every table.
In an RDBMS, usually, the primary key allows you to create a clustered index based on that specific column.
Cluster index is a type of index which sorts the data rows in the table on their key values. In the Database, there is only one clustered index per table.
A clustered index defines the order in which data is stored in the table which can be sorted in only one way. So, there can be an only a single clustered index for every table.
In an RDBMS, usually, the primary key allows you to create a clustered index based on that specific column.
Correct Answer: D
Question 402 Explanation:
An Index is a key built from one or more columns in the database that speeds up fetching rows from the table or view.
Cluster index is a type of index which sorts the data rows in the table on their key values. In the Database, there is only one clustered index per table.
A clustered index defines the order in which data is stored in the table which can be sorted in only one way. So, there can be an only a single clustered index for every table.
In an RDBMS, usually, the primary key allows you to create a clustered index based on that specific column.
Cluster index is a type of index which sorts the data rows in the table on their key values. In the Database, there is only one clustered index per table.
A clustered index defines the order in which data is stored in the table which can be sorted in only one way. So, there can be an only a single clustered index for every table.
In an RDBMS, usually, the primary key allows you to create a clustered index based on that specific column.