Multiple Choice
Contents of the PROMOTION table
-Which of the following SQL statements will insert a new row into the PROMOTION table?
A) INSERT INTO promotion (gift,minretail,maxretail)
VALUES (FREE BOOK,75.01,89.99) ;
B) INSERT INTO promotion (gift,minretail,maxretail)
VALUES ('FREE BOOK',75.01,89.99) ;
C) INSERT INTO promotion VALUES (FREE BOOK,75.01,89.99) ;
D) both a and c
Correct Answer:
Verified
Correct Answer:
Verified
Q54: The data values being added to a
Q55: _ commands are used to modify data.
Q56: Contents of the PUBLISHER table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q57: Which keyword permanently saves changed data in
Q58: The MODIFY command can be used to
Q60: Which of the following is not a
Q61: When does a COMMIT command explicitly occur?<br>A)
Q62: Rows can be deleted from a table
Q63: When the INSERT command is being used
Q64: When does a COMMIT command implicitly occur?<br>A)