Senior SQL Server

Test your Senior-level Relational Databases Sql Server skills in Database Data Management. This timed assessment evaluates your expertise in Information Technology.

Duration: 5 minutes

•40 questions

Time Remaining: 05:00

Progress: 0%

40 questions remaining

Question 1 of 40Assessment

Which scenario would most likely lead to high logical fragmentation in a non-clustered index in SQL Server?

A. Frequent read-only scans performed by reporting applications during business hours.

B. Occasional updates to non-indexed columns in the base table that do not change index values.

C. Heavy insert activity into a table where the index key is a non-sequential GUID or random value.

D. Regular execution of the DBCC CHECKDB command which reorders the physical pages of the index.

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question