Your database contains a table named Customer that has columns named CustomerID and Name.
You want to write a query that retrieves data from the Customer table sorted by Name listing 20
rows at a time.
You need to view rows 41 through 60.
Which Transact-SQL query should you create?

You are developing a database that will contain price information.
You need to store the prices that include a fixed precision and a scale of six digits.
Which data type should you use?

You develop a database application. You create four tables. Each table stores different categories of
products.
You create a Primary Key field on each table.
You need to ensure that the following requirements are met:
The fields must use the minimum amount of space.
The fields must be an incrementing series of values.
The values must be unique among the four tables.
What should you do?

Your application contains a stored procedure for each country. Each stored procedure accepts an
employee identification number through the @EmplD parameter.
You need to build a single process for each employee that will execute the appropriate stored
procedure based on the country of residence.
Which approach should you use?

DRAG DROP
You write the following SELECT statement to get the last order date for a particular customer.

You need to create the user-defined function to return the last order date for the specified
customer.
Which five Transact-SQL statements should you use? (To answer, move the appropriate SQL
statements from the list of statements to the answer area and arrange them in the correct order.)

You are developing a database application by using Microsoft SQL Server 2012.
An application that uses a database begins to run slowly.
You discover that the root cause is a query against a frequently updated table that has a clustered
index. The query returns four columns: three columns in its WHERE clause contained in a nonclustered index and one additional column.
You need to optimize the statement.
What should you do?

You administer a Microsoft SQL Server 2012 database.
The database contains a table named Employee. Part of the Employee table is shown in the exhibit.
(Click the Exhibit button.)

Unless stated above, no columns in the Employee table reference other tables.
Confidential information about the employees is stored in a separate table named EmployeeData.
One record exists within EmployeeData for each record in the Employee table.
You need to assign the appropriate constraints and table properties to ensure data integrity and
visibility.
On which column in the Employee table should you create a Foreign Key constraint that references a
different table in the database?

You administer a Microsoft SQL Server 2012 database.
The database contains a table named Employee. Part of the Employee table is shown in the exhibit.
(Click the Exhibit button.)

Unless stated above, no columns in the Employee table reference other tables.
Confidential information about the employees is stored in a separate table named EmployeeData.
One record exists within EmployeeData for each record in the Employee table.
You need to assign the appropriate constraints and table properties to ensure data integrity and
visibility.
On which column in the Employee table should you create a Primary Key constraint for this table?

You create a view based on the following statement:

You grant the Select permission to User1.
You need to change the view so that it displays only the records that were processed in the month
prior to the current month. You need to ensure that after the changes, the view functions correctly
for User1.
Which Transact-SQL statement should you use?