70-761

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 two tables named UserLogin and Employee respectively. You need to create a Transact-SQL script that meets the following requirements: - The script must update the value of the IsDeleted column for the UserLogin table to 1 if the value of the Id column for the User...

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

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

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

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 have a database that tracks orders and deliveries for customers in North America. The database contains the following tables: Application. Cities Sales. CustomerCategories 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...

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:

You need to create an indexed view that requires logic statements to manipulate the data that the view displays. Which two database objects should you use? Each correct answer presents a complete solution.A . a user-defined table-valued functionB . a CRL functionC . a stored procedureD . a user-defined scalar...

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