A ____________ index determines the physical order of rows in a table.
- Clustered
- Composite
- Non-clustered
- Unique
A clustered index determines the physical order of rows in a table based on the indexed column(s). It rearranges the rows on disk to match the order specified by the index, which can enhance the performance of certain types of queries, particularly those involving range scans or ordered retrieval.
Loading...
Related Quiz
- Scenario: You are tasked with executing a set of database test scripts for a critical application. During execution, you encounter unexpected errors in the scripts, making it challenging to identify the root cause. What steps should you take to address this issue?
- Which keyword is used to specify the action to be taken when an error occurs in a SQL query?
- When testing a database schema, what is the role of normalization?
- One of the challenges in continuous integration for database testing is managing and versioning database ____________.
- Which type of testing ensures that users can access only the resources and features they are authorized to use?