70-761

DRAG DROP You have a table named HR.Employees as shown in the exhibit. (Click the exhibit button.) You need to write a query that will change the value of the job title column to Customer Representative for any employee who lives in Seattle and has a job title of Sales...

You have a database that contains the following tables: Customer Customer Audit Where the value of the CustomerID column equals 3, you need to update the value of the CreditLimit column to 1000 for the customer. You must ensure that the change to the record in the Customer table is...

You have a database that tracks orders and deliveries for customers in North America. The database contains the following tables: Application. Cities Sales. CustomerCatagories The company's development team is designing a customer directory application. The application must list customers by the area code of their phone number. The area code...

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...

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...

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...

HOTSPOT You have the following subqueries: Subquery1, Subquery2, and Subquery3. You need to replace the three subqueries with named result sets or temporary tables. The following requirements must be met: Which replacement techniques should you use? To answer, select the appropriate options in the answer area. View AnswerAnswer:

You have a table named AuditTrail that tracks modifications to data in other tables. The AuditTrail table is updated by many processes. Data input into AuditTrail may contain improperly formatted date time values. You implement a process that retrieves data from the various columns in AuditTrail, but sometimes the process...

You create a table named Products by running the following Transact-SQL statement: You have the following stored procedure: You need to modify the stored procedure to meet the following new requirements: - Insert product records as a single unit of work. - Return error number 51000 when a product fails...

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...