510-022 試験問題を無料オンラインアクセス

When performance suffers due to spinlock contention on a named cache the SA can
_____________

• A.use MRU replacement
• B.partition the cache
• C.create a large I/O pool
• D.expand metadata caches

Which dbcc command can you use to check that each table in a database has a minimum of one column?

• A.dbcc checktable
• B.dbcc checkcatalog
• C.dbcc dbinfo
• D.dbcc checkverify

Which of the following can be used to drop a corrupt or suspect database?

• A.reorg rebuild
• B.drop database
• C.dbcc dbrepair
• D.sp_dbcc_deletedb

Which of the following attributes are NOT set using sp_dbcc_updateconfig?

• A.Size of the extent IO buffer pool to use
• B.Size of the named cache to use
• C.Size of the of the workspaces to use
• D.Maximum number of worker processes to use

Which of the following statements about indexes are true? (Choose two)

• A.sp_fixindex is used to drop corrupted indexes on user tables
• B.duplicate keys can cause overflow pages in clustered DOL tables
• C.sp_fixindex is used to repair corrupted indexes on system tables
• D.duplicate keys can cause overflow pages in clustered APL tables
• E.sp_fixindex is used to repair corrupted indexes on user tables
• F.sp_fixindex is used to drop corrupted indexes on system tables