70-761

You have a table named Products that contains information about the products that your company sells. The table contains many columns that do not always contain values. You need to implement an ANSI standard method to convert the NULL values in the query output to the phrase "Not Applicable". What...

HOTSPOT You query a database that includes two tables: Project and Task. The Project table includes the following columns: You need to identify the owner of each task by using the following rules: - Return each task's owner if the task has an owner. - If a task has no...

You have a database that tracks orders and deliveries for customers in North America. System versioning is enabled for all tables. The database contains the Sales.Customers, Application. Cities, and Sales. CustomerCategories tables. Details for the Sales.Customers table are shown in the following table: Details for the Application.Cities table are shown...

HOTSPOT You are developing a database to track customer orders. The database contains the following tables: Sales.Customers, Sales.Orders, and Sales.OrderLines. The following table describes the columns in Sales.Customers. The following table describes the columns in Sales.Orders. The following table describes the columns in Sales.OrderLines. You need to create a database...

CORRECT TEXT You have a table named Cities that has the following two columns: City ID and CityName. The CityID column uses the int data type, and CityName uses nvarchar(max). You have a table named RawSurvey. Each row includes an identifier for a question and the number of persons that...

You query a database that includes two tables: Project and Task. The Project table includes the following columns: You plan to run the following query to update tasks that are not yet started: You need to return the total count of tasks that are impacted by this UPDATE operation, but...

DRAG DROP You have a database that tracks orders and deliveries for customers in North America. System versioning is enabled for all tables. The database contains the Sales.Customers, Application. Cities, and Sales. CustomerCategories tables. Details for the Sales.Customers table are shown in the following table: Details for the Application.Cities table...

DRAG DROP You are developing a database to track customer orders. The database contains the following tables: Sales.Customers, Sales.Orders, and Sales.OrderLines. The following table describes the columns in Sales.Customers. The following table describes the columns in Sales.Orders. The following table describes the columns in Sales.OrderLines. You need to create a...

You create a table named Customer by running the following Transact-SQL statement: You must insert the following data into the Customer table: You need to ensure that both records are inserted or neither record is inserted. Solution: You run the following Transact-SQL statement: Does the solution meet the goal?A ....

DRAG DROP You have a database that tracks orders and deliveries for customers in North America. System versioning is enabled for all tables. The database contains the Sales.Customers, Application. Cities, and Sales. CustomerCategories tables. Details for the Sales.Customers table are shown in the following table: Details for the Application.Cities table...