You work as the database administrator at an investment company named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that contains a large database named CK_Sales. The Testing.com personnel in the Accounts department require the ability to view customer order information. You need to create a query that will allow Accounts department personnel the ability to view CustomerID values for all customers as well as: the orders that are placed by individual customers, and customers that has not yet placed any orders.
There is a foreign constraint on the CustomerID column of the CK_Sales.[Order Head] table that references the CustomerID column in the CK_Sales.Customer table. You want to create a single query that returns the CustomerID and OrderID.
What query should you use?

You work as the database administrator at an investment company named Domain.com. Domain.com has its headquarters in New York and branch offices in Boston, Atlanta, Miami, and New Orleans. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that is located at headquarters.
Certkiller -DB01 contains a large database named CK_Investments. The CK_Investments database stores investment data for each office. You need to implement a stored procedure that will return the average length of an investment at each office.
What Transact SQL query should you use?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all clients run Windows XP Professional.
The Domain.com network hosts a database that is used to store news stories. You need to run a query that returns the number of new stories in each category and subcategory that have been added in the last 7 days. Your stored procedure must also return the name of the subcategory and the category to which it belongs.
What query should you use?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003 and all client computers run Windows XP Professional. The Domain.com network contains three SQL Server 2005 database servers named Certkiller -DB01, Certkiller -DB02, and Certkiller -DB03. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. Log shipping is configured on Certkiller -DB01 and Certkiller -DB02 with Certkiller -DB01 being the primary server. Domain.com users run queries and reports against the CK_Sales database on Certkiller -DB02. You want to store all status information for Certkiller -DB01 and Certkiller -DB02 on Certkiller -DB03.
What should you do?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003 and all client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. You install two new SQL Server 2005 database server named Certkiller -DB02 and Certkiller -DB03 on the Domain.com network. You want to configure log shipping between the three database servers with Certkiller -DB01 being the primary server. You want users to be able to use Certkiller -DB02 and Certkiller -DB03 to run queries and reports against the CK_Sales database. You backup the CK_Sales database and all transaction logs on Certkiller -DB01.
What should you do next?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains two SQL Server 2005 computers named Certkiller -DB01 and Certkiller -DB02
You have been informed by the CIO that the transaction log shipping occurs from Certkiller -DB01 to Certkiller -DB02 by using default SQL Server Agent schedule settings. A Domain.com user named Kara Lang is a junior technician appointed in the Research and Development department. You instruct Kara Lang to reconfigure the transaction log shipping to provide minimum latency on Certkiller -DB02.
What should Kara Lang do?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003. The Domain.com network contains a single database server named Certkiller -DB01, and a file server named Certkiller -SR22. Certkiller -DB01 runs SQL Server 2005 Workgroup Edition and hosts a database named CK_Sales that stores sales data for the company. The CK_Sales database is configured to use the full recovery model. You want to implement a backup strategy for the CK_Sales database that includes log shipping. You successfully install SQL Server 2005 Workgroup Edition on a new database server named Certkiller -DB02.
What should you do next?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003. The Domain.com network contains a single database server named Certkiller -DB01, and a file server named Certkiller -SR22. Certkiller -DB01 runs SQL Server 2005 Workgroup Edition and hosts a database named CK_Sales that stores sales data for the company.
You want to implement a recovery model and backup strategy for the CK_Sales database. You decide to add a second database server named Certkiller -DB02 to the Domain.com network. You install SQL Server 2005 Workgroup Edition on Certkiller -DB02.
What should you do next?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server2003. The Domain.com network contains three SQL Server 2005 database servers named Certkiller -DB01, Certkiller -DB02, and Certkiller -DB03. Database mirroring is configured between Certkiller -DB01 and Certkiller -DB02, with Certkiller -DB03 as the witness server. Certkiller -DB01 is the principal database server and hosts a database named CK_Sales that stores sales data from Domain.com’s e-Commerce Web site.
The size of the CK_Sales database has increased over the last three month as Domain.com’s customer base has increased. You are concerned about the performance of the CK_Sales database. You want to maximize database performance while retaining the mirrored configuration.
What should you do?