An example of a command you would use when making changes to a PRODUCT table is ____.
A) CHANGE PRODUCT
SET P_INDATE = '18-JAN-2004'
WHERE P_CODE = '13-Q2/P2';
B) ROLLBACK PRODUCT
SET P_INDATE = '18-JAN-2004'
WHERE P_CODE = '13-Q2/P2';
C) EDIT PRODUCT
SET P_INDATE = '18-JAN-2004'
WHERE P_CODE = '13-Q2/P2';
D) UPDATE PRODUCT
SET P_INDATE = '18-JAN-2004'
WHERE P_CODE = '13-Q2/P2';

Question

Quizplus · Accepted Answer

The correct command to make changes to a table is UPDATE. In this case, we want to update the PRODUCT table and set the value of P_INDATE to '18-JAN-2004' for the row where P_CODE is '13-Q2/P2'. Therefore, the correct command is UPDATE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2'. None of the other options are valid commands.

An Example of a Command You Would Use When Making