Quiz 70-461

Quiz 70-461, Querying Microsoft SQL Server 2012

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?

Which Transact-SQL statement should you use?

Which Transact-SQL statement should you use?

You need to improve the performance of the view by persisting data to disk

You need to store the departure and arrival dates and times of flights along with time zone information

You need to supply the stored procedure with multiple event names and their dates as parameters