What is wrong with the T-SQL batch statement below.
@find varchar(30);
SET @find = ‘Man’;
SELECT LastName FROM Person WHERE LastName = @find;

Which of the following conversions is NOT allowed either implicitly or explicitly using CONVERT
OR CAST?

As part of a new enterprise project, you’re designing a new table to store financial transactions.
This table could eventually store millions of rows and so storage space is very important. One of
the columns in the table will store either a 1 or 0 value. Which data type would be most appropriate?

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 and Drop Question
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.)

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 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?

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?

You administer a Microsoft SQL Server 2012 database. Users report that an application that
accesses the database displays an error, but the error does not provide meaningful information.
No entries are found in the SQL Server log or Windows event logs related to the error. You need
to identify the root cause of the issue by retrieving the error message. What should you do?

You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports
a highly active OLTP application. Users report abnormally long wait times when they submit data

into the application. You need to identify which queries are taking longer than 1 second to run over
an extended period of time. What should you do?