Multiple Choice
Based on the code above,delete any row in the OrderLine table in which the item number is MT03.
A) DELETE FROM OrderLine WHERE ItemNum='MT03' ;
B) DELETE FROM OrderLine WHERE ItemNum=MT03;
C) DELETE FROM OrderLine WHERE ItemNum='MT03'
D) DELETE FROM OrderLine WHERE ItemNum='MT3' ;
Correct Answer:
Verified
Correct Answer:
Verified
Q10: In a SELECT statement, the WHERE clause
Q20: There is no difference between the COUNT
Q21: You can use the SQL CREATE TABLE
Q29: In Access SQL,the _ is used as
Q30: The IN operator provides a concise way
Q31: Based on the code above,list the number,name,street,and
Q32: Describe how to construct a detailed query
Q35: SQL uses commands to create tables,update tables,and
Q38: Fields will appear in the query results
Q39: To use a wildcard,include the _ operator