题目

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 ( 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.

答案
查看答案
相关试题

选择性

工作人员在暂时离开办公台时,需要锁定计算机屏幕。

A、对

B、错

产品树中的根结点应是产品的()。

A、效果图

B、示意图

C、装配简图

D、装配图

计算机打开U盘自动运行策略,杀毒软件就能自动查杀U盘病毒。

A、对

B、错

After a baseline check was completed it was noted that the network was working far below the level of the last baseline. Which of the following should the technician do NEXT to determine where the network problems are occurring?()

A、Upgrade the firmware on all routers and switches

B、Reboot the entire network one device at a time

C、Conduct a network traffic analysis

D、Rerun the baseline to ensure the results were correct

最新解答的试题
付款人在进行付款时无()

A.形式审查义务

B.实质审查义务

C.附带审查义务

D.票据外有关事项的审查义务
根据《公司法》的规定,有限责任公司下列人员中,可以提议召开股东会临时会议的是()。
A.总经理B.人数过半数的股东C.监事会主席D.人数为半数的董事
关于股份有限公司中的监事会,下列说法错误的是()

A.监事会负责提议聘请或更换外部审计机构B.监事会主席和副主席由全体监事过半数选举产生C.监事会中的职工代表的比例不得低于三分之一D.监事会应至少每6个月召开一次会议
三北精神的科学内涵
阿里巴巴提供了“企业名称认证”“企业身份认证”不同种类的认证,可以根据自身的