Considering the exhibit given below:
SQL> INSERT INTO T1 VALUES (10,’JOHN’);
1 row created
SQL> INSERT INTO T1 VALUES (12,’SAM’);
1 row created
SQL> INSERT INTO T1 VALUES (15,’ADAM’);
1 row created
SQL> SAVEPOINT A;
Savepoint created
SQL> UPDATE T1
2 SET NAME=’SCOTT’
3 WHERE CUST_NBR=12;
1 row updated
SQL> SAVEPOINT B;
Savepoint created
SQL> DELETE FROM T1 WHERE NAME LIKE ‘%A%’;
1 row deleted
SQL> GRANT SELECT ON T1 TO BLAKE;
Grant succeeded
SQL> ROLLBACK;
Rollback complete
What will be the output of SELECT * FROM T1;?
A.
CUST_NBR NAME
—————- ———10 JOHN
B.
CUST_NBR NAME
—————- ———10 JOHN
12 SCOTT
15 ADAM
C.
CUST_NBR NAME
—————- ———10 JOHN
15 ADAM
D.
CUST_NBR NAME
—————- ———10 JOHN
12 SCOTT