rollback
ExaminethestructureoftheEMPLOYEEStable:
EMPLOYEE_IDNUMBERPrimaryKey
FIRST_NAMEVARCHAR2(25)
LAST_NAMEVARCHAR2(25)
HIRE_DATEDATE
Youissuethesestatements:
CREATEtablenew_emp(employee_idNUMBER,nameVARCHAR2(30));
INSERTINTOnew_empSELECTemployee_id,last_namefromemployees;
Savepoints1;
UPDATEnew_empsetname=UPPER(name);
Savepoints2;
Deletefromnew_emp;
Rollbacktos2;
Deletefromnew_empwhereemployee_ id=180;
UPDATEnew_empsetname='James';
Rollbacktos2;
UPDATEnew_empsetname='James'WHEREemployee_ id=180;
Rollback;
Attheendofthistransaction,whatistrue?
A.Youhavenorowsinthetable.
B.YouhaveanemployeewiththenameofJames.
C.Youcannotrollbacktothesamesavepointmorethanonce.
D.YourlastupdatefailstoupdateanyrowsbecauseemployeeID180wasalreadydeleted.
Answer:A
这个回滚到什么地方不是回到s1