Quiz 70-461

Quiz 70-461, Querying Microsoft SQL Server 2012

You need to create a query for a report

You need to create a query that returns a list of products from Sales.ProductCatalog

Which Transact-SQL query should you create?

Which data type should you use?

You need to ensure that the following requirements are met: The fields must use the minimum amount of space

Which five Transact-SQL statements should you use?

Which approach should you use?

You need to optimize the statement

which column in the Employee table should you create a Foreign Key constraint that references a different table in the database?

which column in the Employee table should you create a Primary Key constraint for this table?