题目内容

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You 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. 错误

税务机关应当广泛宣传()、行政法规,普及(),无偿地为纳税人提供()服务。

在测量工作中的观测条件有:()

A. 仪器
B. 观测者
C. 外界条件
D. 观测误差
E. 粗差

答案查题题库