PrepAway - Latest Free Exam Questions & Answers

Tag: should i use tablock

Which arguments should you use?

You are your company’s SQL administrator. A SQL Server 2008 instance named SQL1 contains severaldatabases, including a database named Products.
Several users are experiencing problems with the Product_details table of the Products database. The Product_details table is very large.
You decide to check the integrity of the table using a DBCC CHECKTABLE statement. The statement youexecute must meet the following goals:
? The run time for the statement must be minimized.
? Other users should only be able to read the table’s data during the statement’s execution.
Which arguments should you use? (Choose all that apply.)