Which of the following DBCC commands shows optimizer statistics for objects such as tables? A. STATS B. SHOW_STATISTICS C. OBJECT_STATS D. OPTIMIZER

If you are restoring and recovering a database, which of the following keywords must you specify if you intend to roll forward a transaction log backup after restoring a database? A. NOFINISH B. NORECOVERY C. TRANSACTIONLOG RECOVER D. NEXTLOG

Which of the following Microsoft SQL Server 2012 components is responsible for executing scheduled administrative tasks? A. SQL Server Instance B. SQL Server Jobs File C. SQL Server Agent D. SQL Server SSIS

Which of the following is NOT a hardware requirement for SQL Server 2012? A. 6GB of hard drive space B. 1GB of memory C. 1GHZ CPU speed D. a graphics card with 2GB video memory

Which of the following SQL Server 2012 tools coordinates transactions across SQL Servers in a clustered environment? A. SQL Server Profiler B. SQL Server Query Optimizer C. SQL Server Management Studio D. Microsoft Distributed Transaction Coordinator

Which of the following permissions must a user have in order to query all of the built-in Dynamic Management views? A. VIEW ALL B. SELECT ALL VEWS C. VIEW SERVER INFO D. VIEW SERVER STATE

Which of the following is NOT a potential Cluster resource when configuring clustering in SQL Server 2012? A. SQL Server Database Engine Service B. SQL Server Agent Service C. SQL Server Table Service D. All of the above

Which of the following recovery models must be in use for point-in-time recovery to be possible for an SQL Server 2012 database? A. Differential B. Full C. Simple D. ArchiveLog

Which of the following is the default file extension for an SQL Server 2012 backup file? A. .rman B. .bac C. .bak D. .db

Which of the following statements will create an index called “SalesDate” on the DATEOFSALE column on the SALES table residing in the WAREHOUSE database? A. CREATE INDEX SalesDate ON SALES (DATEOFSALE); B. MAKE INDEX SalesDate ON SALES (DATEOFSALE); C. CREATE…