You are the database administrator for your company. You manage all the SQL Server 2008 databases in your company. The Prod_details database is the main database accessed by the company’s users. The head office receives data from other branches of the company. After the data is verified by employees of the audit department, the database is updated with this information. Some employees in the audit department complain they cannot update data in certain tables. You suspect that other database users are holding locks on these tables. You must identify the oldest transaction in the database and the SQL Server logins associated with the transaction. Which statements or functions should you use to obtain the desired results? (Choose two. Each answer represents a part of the solution.)

You are your company’s SQL administrator. A SQL Server 2008 instance named SQL1 contains several databases, 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 you execute 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.)

You are a database administrator for a toy manufacturing company named NetFx. The company stores all its product-related data in a database named Netfx_data that resides on a SQL Server 2008 server named Server1. A table named Invoice_details exists in the database and contains the details of all the new invoices generated by the company in the last month. The table was created by using the following CREATE TABLE statement:
CREATE TABLE Invoice_details (
Invoice_id int NOT NULL,
Customer_id int NOT NULL,
Invoice_date datetime DEFAULT GETDATE () NULL,
Amount_total int NULL,
Serial_num int IDENTITY (1,1) NOT NULL)

A clustered index exists on the Serial_num column, and a composite nonclustered index exists on the Invoice_id and the Customer_id columns.
An application will be used to execute queries to retrieve all the invoices for a particular customer. The following query is used by the application to retrieve data:
SELECT Customer_id, Invoice_id, Invoice_date
FROM Invoice_details
WHERE Customer_id = 1234
ORDER BY Invoice_date DESC;

You must ensure optimal performance of the query.
Which action should you perform to achieve this?

You are the database administrator of your company. Your server named Server1 contains an instance of SQL Server 2008 named SQL1. Server1 contains two hard disks named Disk1 and Disk2. A database named Corpdb contains sensitive information and is stored on Disk1. The transaction log for Corpdb is stored on Disk2. Your company policy states that data loss must never exceed one hour’s worth of data. You configure a full backup to be performed on SQL1 every Sunday at 1:00 A.M.

You configure a differential backup to be performed daily on SQL1 at 4:00 A.M. You also configure the transaction log to be backed up every hour. The database becomes corrupt on Wednesday at 3:20 P.M. You want to restore the database to the point of failure.
What should you do first?

You are the SQL administrator for your company. You have two SQL Server 2008 computers named SQL_corp and SQL_public. Multiple databases reside on these two servers.
A new user named John has been hired in your department. John must be able manage permissions for the SQL_corp server. He should also be able to manage permissions on the Sales database on the SQL_public computer. You should not grant John any permissions he does not need.
To which role should you add John’s account?