Quiz 70-461

Quiz 70-461, Querying Microsoft SQL Server 2012

Which data type should you use?

Which Transact-SQL query or queries should you use?

which column in the Employee table should you a create a unique constraint?

which column in the Employee table should you use an identity specification to include a seed of 1,000 and an increment of 1?

Which Transact-SQL query should you use?

Which Transact-SQL statement should you use?

You need to achieve this goal by using the minimum amount of administrative effort

You need to ensure that the minimum amount of disk space is used to store the data in the Product table

You need to improve the performance of the query

Which Transact-SQL query should you use?