CORRECT TEXT You have a view that was created by using the following code: You need to create an inline table-valued function named Sales.fn_OrdersByTerritory that returns sales information from a specified SalesTerritoryID. Sales.fn_OrdersByTerritory must meet the following requirements: Use one-part…
You are maintaining a Microsoft SQL Server database that stores order information for an online store website. The database contains a table that is defined by the following Transact-SQL statement: You need to ensure that purchase order numbers are used…
You are developing a database in SQL Server 2012 to store information about current employee project assignments. You are creating a view that uses data from the project assignment table. You need to ensure that the view does not become…
You have a database application that uses Microsoft SQL Server 2012. You have a query named Query1 that returns four columns from a frequently updated table that has a clustered index. Three of the columns are referenced in the WHERE…
You are developing a database that will contain price information. You need to store the prices that include a fixed precision and a scale of six digits. Which data type should you use? A. Smallmoney B. Numeric C. Money D.…
DRAG DROP You develop an SQL Server database. The database contains a table that is defined by the following T-SQL statements: The table contains duplicate records based on the combination of values in the surName, givenName, and dateOfBirth fields. You…
You are a database developer for an application hosted on a Microsoft SQL Server 2012 server. The database contains two tables that have the following definitions: Global customers place orders from several countries. You need to view the country from…
CORRECT TEXT You need to create a query that calculates the total sales of each OrderID from a table named Sales.Details. The table contains two columns named OrderID and ExtendedAmount. The solution must meet the following requirements: Use one-part names…
CORRECT TEXT You have a database named Sales that contains the tables as shown in the exhibit. (Click the Exhibit button.) You need to create a query for a report. The query must meet the following requirements: Return the last…
CORRECT TEXT You have a database named Sales that contains the tables as shown in the exhibit. (Click the Exhibit button.) You need to create a query that returns a list of products from Sales.ProductCatalog. The solution must meet the…