Category «70-461»

Exam 70-461: Querying Microsoft SQL Server 2012 (update March 17th, 2016)

Which Transact-SQL statement should you use?

You develop a Microsoft SQL Server 2012 server database that supports an application. Theapplication contains a table that has the following definition:CREATE TABLE Inventory(ItemID int NOT NULL PRIMARY KEY,ItemsInStore int NOT NULL,ItemsInWarehouse int NOT NULL)You need to create a computed column that returns the sum total of the ItemsInStore andItemsInWarehouse values for each row.Which Transact-SQL …

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

You develop a database for a travel application. You need to design tables and other databaseobjects.You create the Airline_Schedules table.You need to store the departure and arrival dates and times of flights along with time zoneinformation.What should you do? A. Use the CAST function. B. Use the DATE data type. C. Use the FORMAT function. …

Which code segment should you use?

CORRECT TEXTYou have a view that was created by using the following code: You need to create an inline table-valued function named Sales.fn_OrdersByTerritory, which mustmeet the following requirements:Accept the @T integer parameter.Use one-part names to reference columns.Filter the query results by SalesTerritoryID.Return the columns in the same order as the order used in OrdersByTerritoryView.Which code …

Which code segment should you use?

CORRECT TEXTYou have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You deploy a new server that has SQL Server 2012 installed. You need to create a table namedSales.OrderDetails on the new server. Sales.OrderDetails must meet the following requirements:Write the results to a disk.Contain a new column named LineItemTotal …

Which code segment should you use?

CORRECT TEXTYou have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You need to create a view named uv_CustomerFullName to meet the following requirements:The code must NOT include object delimiters.The view must be created in the Sales schema.Columns must only be referenced by using one-part names.The view must return …

Which code segment should you use?

CORRECT TEXTYou have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You need to create a query that calculates the total sales of each OrderId from the Sales.Detailstable. The solution must meet the following requirements:Use one-part names to reference columns.Sort the order of the results from OrderId.NOT depend on …

Which Transact-SQL query should you use?

You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders.The tables are related by a column named CustomerID.You need to create a query that meets the following requirements: Returns the CustomerName for all customers and the OrderDate for any orders that they haveplaced.Results must include customers who have not placed …

Which Transact-SQL statement should you include at the beginning of the stored procedure?

You create a stored procedure that will update multiple tables within a transaction.You need to ensure that if the stored procedure raises a run-time error, the entire transaction isterminated and rolled back.Which Transact-SQL statement should you include at the beginning of the stored procedure? A. SET XACT_ABORT ON B. SET ARITHABORT ON C. TRY D. …