You maintain a SQL Server 2008 instance that contains a database named Finance.
You suspect that three large tables in the Finance database are corrupt. You plan to execute
the DBCC CHECKTABLE statement concurrently on the three tables to minimize downtime.
You need to set the database option to prevent users from accessing the database during
the execution of the statement.
Which database option should you turn on?

You administer a Microsoft SQL Server 2008 R2 database instance.
You plan to automate maintenance tasks.
What task types are included in a SQL Maintenance Plan? (Choose all that apply.)

You administer a SQL Server 2008 instance that contains a database named InsightDB.
The InsightDB database is used by an application that is continuously connected.
The application uses the INSERT command extensively. The application uses triggers to
populate multiple tables.
You need to ensure that the reports generated by the application using the InsightDB
database return current information with minimal negative effects on the application inserts.
What should you do?

You manage two SQL Server 2008 instances on separate servers named Server1 and
Server2. The servers are located in different cities.
You plan to implement database mirroring between the two instances.
You need to set up the mirroring session to support the high volume of write transactions to
the database.
You do not want small errors to impact the principal server.
What should you do?

You maintain a SQL Server 2008 instance.
You use the Resource Governor to manage processor resources on the server for a newly
deployed application named App1. App1 is assigned to a custom workload group named
MyApp.
You need to monitor processor resources.
What should you do?

You administer a Microsoft SQL Server 2008 R2 instance that contains two databases
named Northwind2008R2 and AdventureWorks. The Northwind2008R2 database uses the
SQL_Latin1_General_CP1_CI_AS collation and the AdventureWorks database uses the
SQL_Latin1_General_CP1_CS_AS collation.
You need to write a query that returns all customers having the same name in each
database. You also need to ensure that the query is not case-sensitive.
Which Transact-SQL query should you use?

You administer a Microsoft SQL Server 2008 R2 instance.
You need to attach a database named Northwind to the server.
Which Transact-SQL command should you use?

You administer a SQL Server 2008 instance that has TCP/IP enabled.
You need to verify the port that the SQL Server instance listens on.
What should you do?

You have a server that contains a default SQL Server 2005 instance. You need to install a
SQL Server 2008 instance for a new application on the same server. The new application
requires SQL Server 2008 functionality.
You need to ensure that both database instances are available for their respective certified
third-party applications. The existing application environments remain unchanged.
What should you do?

You administer three SQL Server 2008 instances on separate servers named Server1,
Server2, and Server3.
The AdventureWorks database is configured for mirroring between the instances. In the
mirroring session, Server1 and Server2 act as partners and Server3 as the witness.
You have the following requirements:
-All three servers run a maintenance process that requires occasional restart of the
computer. -The SQL Server service on each server is shut down only during the actual
restart of the computer.
-After completion of the maintenance process, re-enable automatic failover and synchronize
the mirroring session in minimum possible time.
You need to ensure that automatic failover is disabled during the maintenance process.
What should you do first?