Intermediate SQL Server

Test your Intermediate-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

In T-SQL, what is the effect of using the WITH (NOLOCK) query hint on a SELECT statement?

A. It allows the query to read uncommitted data, potentially resulting in dirty reads and data errors.

B. It prevents the query from being blocked by other users but ensures that only committed data is read.

C. It forces the query to use an index scan instead of a seek to avoid locking the index pages.

D. It automatically elevates the transaction isolation level to serializable for the duration of the query.

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question