70-761

SIMULATION You have a database that contains the following tables. You need to create a query that returns each complaint, the names of the employees handling the complaint, and the notes on each interaction. The Complaint field must be displayed first, followed by the employee’s name and the notes. Complaints...

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question...

You have a database that contains the following tables: Customer CustomerAudit 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 recorded...

HOTSPOT 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. View AnswerAnswer: Explanation: Box 1: Scalar The return value of a function can either be a...

SIMULATION You have a database that contains the following tables. You need to create a query that lists all complaints from the Complaints table, and the name of the person handling the complaints if a person is assigned. The ComplaintID must be displayed first, followed by the person name. Construct...

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question...

HOTSPOT You need to develop a Transact-SQL statement that meets the following requirements: - The statement must return a custom error when there are problems updating a table. - The error number must be value50555. - The error severity level must be14. - A Microsoft SQL Server alert must be...

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

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

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question...