Multiple Choice
Based on the code shown, which query deletes any row in the OrderLine table in which the item number is MT03???OrderLine (OrderNum, ItemNum, NumOrdered, QuotedPrice) ?Item (ItemNum, Description, OnHand, Category, Storehouse, Price )
A) DELETE FROM OrderLine WHERE ItemNum='MT03' ;
B) DELETE FROM OrderLine WHERE ItemNum=MT03 ;
C) REMOVE FROM OrderLine WHERE ItemNum='MT03' ;
D) REMOVE FROM OrderLine WHERE ItemNum=MT03 ;
Correct Answer:

Verified
Correct Answer:
Verified
Q59: When rows are grouped, one line of
Q60: Use the _ clause to sort data.
Q61: SQL has built-in functions, which are also
Q62: Which query will return the number of
Q63: By using the word _ in a
Q65: Based on the code shown, which query
Q66: Based on the code shown, which query
Q67: Computed fields are existing fields in the
Q68: How are compound conditions formed?
Q69: When used after the word SELECT, which