Question 36
You administer a Microsoft SQL Server database. The database has a table named Customers owned by UserA and another table named Orders owned by UserB. You also have a stored procedure named GetCustomerOrderInfo owned by UserB. GetCustomerOrderInfo selects data from both tables.
You create a new user named UserC.
You need to ensure that UserC can call the GetCustomerOrderInfo stored procedure. You also need to assign only the minimum required permissions to UserC.
Which two permission or permissions should you assign to UserC? Each correct answer presents part of the solution.
Question 37
You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail.
You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented.
You need to reduce fragmentation. You need to achieve this goal without taking the index offline.
Which Transact-SQL batch should you use?
Question 38
You maintain several databases on a 64-bit Microsoft SQL 2005 instance.
You need to migrate the databases to SQL 2012 on the same server. You also need to ensure functionality in SQL 2012 can be used in the database after migration.
What should you do? (Each correct answer presents part of the solution.)
Question 39
Which of the following is the default port for an SQL Server database to communicate over?
Question 40
Which of the following is the default instance name in an SQL Server 2012 installation?