70-761 practice questions, page 5 of 8, with answer review and explanations.
Question 21
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 Representative. If the employee does not have a manager defined, you must not change the title. Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact- SQL segments to the answer area and arrange them in the correct order. Select and Place:
Question 22
You have the following Transact-SQL query: What type of functions are used in the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Question 23
You have a database that includes the following tables: You need to create a list of all customer IDs and the date of the last order that each customer placed. If the customer has not placed any orders, you must return the date January 1, 1900. The column names must be CustomerID and LastOrderDate. Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact- SQL segments to the answer area and arrange them in the correct order. Select and Place:
Question 24
You run the following Transact-SQL statement: You need to ensure that you can insert data into the table. What are the characteristics of the data? To answer, select the appropriate options in the answer area. Hot Area:
Question 25
SIMULATION - You create a table named Sales.Orders by running the following Transact-SQL statement: You need to write a query that meets the following requirements: ✑ removes orders from the table that were placed before January 1, 2012 ✑ uses the date format of YYYYMMDD ✑ ensures that the order has been shipped before deleting the record Construct the query using the following guidelines: ✑ use one-part column names and two-part table names ✑ do not use functions ✑ do not surround object names with square brackets ✑ do not use variables do not use aliases for column names and table names Part of the correct Transact-SQL has been provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it. Use the Check Syntax button to verify your work. Any syntax or spelling errors will be reported by line and character position.