Multiple choice technology databases

Mark all the indexes which are their in SQL server

  1. Bit Map

  2. clustered

  3. Non clustered

  4. filter

  5. covering

  6. Composite
Reveal answer Fill a bubble to check yourself
B,C,D,E,F Correct answer
Explanation

SQL Server has multiple index types: Clustered indexes (one per table, stores data physically sorted), Non-clustered indexes (multiple per table, store separate pointer structures), Filtered indexes (non-clustered indexes with a WHERE clause), Covering indexes (non-clustered indexes that include all columns needed for a query), and Composite indexes (indexes on multiple columns). Bit Map indexes exist in Oracle but not SQL Server.

AI explanation

SQL Server supports clustered indexes (which physically order the table data), non-clustered indexes (separate structures pointing back to the data), filtered indexes (indexing only a subset of rows via a WHERE predicate), covering indexes (which include all columns needed by a query to avoid a lookup), and composite indexes (built on multiple columns). Bitmap indexes are an Oracle/data-warehouse feature, not a SQL Server index type, which is why it's correctly excluded.

Keep practicing — related questions