You work as a Database Administrator for Realtech Inc. A database has a table named Product.
The auto commit mode of the database is turned off. You want to perform an update on the
Product table. Which of the following queries will permanently save the changed value of
ProductID in the table?
1. UPDATE Product
SET COST=49.90
WHERE ProductID=’121′
2. UPDATE Product
SET COST=49.90
WHERE ProductID=’121′
COMMIT
A.
Only Query 1 will save the changes permanently.
B.
Both the queries will successfully change the value, but only Query 1 will permanently store the
value in the database.
C.
Both the queries will successfully change the value of ProductID=’121′.
D.
Both the queries will successfully change the value, but only Query 2 will permanently store the
value in the database.