You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com has its headquarters in London and a branch office in Paris. You are based at headquarters. Your duties include administrating a SQL Server 2005 database server named Certkiller -DB01
You have been informed by the CIO that the Research and Development department wants a report that evaluates the customer activity in the previous quarter between the office in London and the branch office in Paris. Domain.com wants the information to be sorted by surname and first name. A Domain.com user named Amy Walsh is a junior technician in the IT department. You inform her to restore a recent backup of the Paris database onto your server. Amy Walsh writes the queries to build the report, ordering the information by the LastName and FirstName columns. Amy Walsh reviews the information and detects that the client lists from the Paris database is sorted different to the one in the headquarters. You receive a notification from the Research and Development department that they require the revised data within 15 minutes for a presentation. Amy Walsh needs to implement the fastest possible solution that will guarantee that the information from both databases is sorted identically.
What should Amy Walsh do?

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database server named Certkiller -DB01.
Your institute is well known for the sale of their textbooks. You work for a company that sells books. You are creating a report for a SQL Server 2005 database. This report will indicate the all the sales representatives and their total sales for the present month. A Domain.com user named Dean Austin is a junior technician in the Sales department. You inform him that the report should only include those sales representatives who met their sales quota for the present month. The monthly sales quota for Domain.com is $2,000. Domain.com makes use of date parameters that are passed in variables named @StartDate and @EndDate. You instruct Dean Austin to create a report that will meet those requirements.
Which SQL query should Dean Austin use?

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com makes use of multiple servers in a distributed environment. The Domain.com network contains two SQL Server 2005 database server named Certkiller -DB01 and Certkiller -DB02. Both Certkiller -DB01 and Certkiller -DB02 makes use of SQL Server Authentication and make use of different logins. A Domain.com employee named Kara Lang works in the Research and Development department. You instruct her to write a distributed query that joins the data on Certkiller -DB01 with the data on Certkiller -DB02.
What should she do?

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?