Exam 70-761 topic 1 question 103 discussion

Actual exam question from Microsoft's 70-761

Question #: 103
Topic #: 1

SIMULATION -
You create a table named Sales.Orders by running the following Transact-SQL statement:

You need to write a query that removes orders from the table that have a Status of Canceled.
Construct the query using the following guidelines:
use one-part column names and two-part table names

✑ use single quotes around literal values
✑ 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.

Show Suggested Answer

Suggested Answer: Please see explanation
1. DELETE from sales.orders where status='Canceled'
Note: On line 1 change calceled to Canceled
Example: Using the WHERE clause to delete a set of rows
The following example deletes all rows from the ProductCostHistory table in the AdventureWorks2012 database in which the value in the StandardCost column is more than 1000.00.
DELETE FROM Production.ProductCostHistory
WHERE StandardCost > 1000.00;
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/delete-transact-sql

by Anette at May 29, 2020, 4:57 p.m.