1.
Which of the following is a disaster recovery solution offered in SQL Server 2012 and involves maintaining a standby copy of a primary database?
2.
Which of the following is a prerequisite for an SQL Server 2012 installation?
3.
Which of the following SQL Server 2012 features generates numeric values at a defined interval and order?
4.
Which of the following DBCC commands can you use to check the physical and logical integrity of an SQL Server 2012 database?
5.
If you are required to move an SQL 2012 database from one server to another, which of the following will do this at the database level?
6.
Which of the following is a valid upgrade path for SQL Server 2012?
7.
Which of the following is NOT a valid recovery model for an SQL 2012 database?
8.
Which of the following is NOT a database role that you can assign users in SQL Server 2012?
9.
Before moving an SQL Server 2012 database file to a new location, which of the following must first be accomplished?
10.
Which of the following statements will create an index called "SalesDate" on the DATEOFSALE column on the SALES table residing in the WAREHOUSE database?