A．硝苯地平 B．卡托普利 C．硝普钠 D．呋塞米 E．地高辛

HAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEYou issue these statements:CREATE table new_emp (employe_id NUMBER, name VARCGAR2(30)); INSERT INTO new_emp SELECT employee_id, last_name from employees; Savepoint s1;UPDATE new_emp set name = UPPER(name);Savepoint s2;Delete from new_emp;Rollback to s2;Delete from new_emp where employee_id=180;UPDATE new_emp set name = ‘James‘;Rollback to s2;UPDATE new_emp sey name = ‘James‘ Where employee_id=180;Rollback;At the end of this transaction, what is true？（）

A. You have no rows in the table.

B. You have an employee with the name of James.

C. You cannot roll back to the same savepoint more than once.

D. Your last update fails to update any rows because employee ID 180 was already deleted.

HAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEYou issue these statements:CREATE table new_emp (employee_id NUMBER, name VARCHAR2(30));INSERT INTO new_emp SELECT employee_id , last_name from employees;Savepoint s1;UPDATE new_emp set name = UPPER(name);Savepoint s2;Delete from new_emp;Rollback to s2;Delete from new_emp where employee_id =180;UPDATE new_emp set name = ‘James‘;Rollback to s2;UPDATE new_emp set name = ‘James‘ WHERE employee_id =180;Rollback;At the end of this transaction, what is true？（）

A.You have no rows in the table.

B.You have an employee with the name of James.

C.You cannot roll back to the same savepoint more than once.

D.Your last update fails to update any rows because employee ID 180 was already deleted.

CHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEYou issue these statements:CREATE table new_emp (employe_id NUMBER, name VARCGAR2(30));INSERT INTO new_emp SELECT employee_id, last_name from employees; Savepoint s1;UPDATE new_emp set name = UPPER(name);Savepoint s2;Delete from new_emp;Rollback to s2;Delete from new_emp where employee_id=180;UPDATE new_emp set name = ‘James‘;Rollback to s2;UPDATE new_emp sey name = ‘James‘ Where employee_id=180; Rollback;At the end of this transaction, what is true？ （）

A. You have no rows in the table.

B. You have an employee with the name of James.

C. You cannot roll back to the same savepoint more than once.

D. Your last update fails to update any rows because employee ID 180 was already deleted.

HAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEYou issue these statements:CREATE table new_emp (employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , last_name from employees;Savepoint s1;UPDATE new_emp set name = UPPER(name);Savepoint s2;Delete from new_emp;Rollback to s2;Delete from new_emp where employee_id =180;UPDATE new_emp set name = ‘James‘;Rollback to s2;UPDATE new_emp set name = ‘James‘ WHERE employee_id =180;Rollback;At the end of this transaction, what is true？（）

A.You have no rows in the table.

B.You have an employee with the name of James.

C.You cannot roll back to the same savepoint more than once.

D.Your last update fails to update any rows because employee ID 180 was already deleted.

A．

B．

C．

D．

A．

B．

C．

D．

A．

B．

C．

D．

A．

B．

C．

D．

A．

B．

C．

D．

03 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements？（）

A.

B.

C.

D.

E.