[多选]
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：
SQL> SELECT job FROM emp
2 WHERE job=’CLERK’ FOR UPDATE OF empno;
SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）

A . LOCK TABLE emp IN SHARE MODE;
B . LOCK TABLE emp IN EXCLUSIVE MODE;
C . DELETE FROM emp WHERE job=’MANAGER’;
D . INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;
E . SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

“后茶馆式”教学中的“做”是增加学生的经验。这种学生的学习经历不仅增加了学生自身的默会知识，而且可以进一步产生（）的对话。 Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（） flash back the corrupted blocks。 use the DBMS_REPAIR package。 use the RMAN TSPITR command。 use the RMAN BLOCKRECOVER command。 use the RESTORE DATABASE and RECOVER DATABASE commands。 investigate the time at which the corruption occurred and perform a pointintime recovery。对于新产品开发来说，项目的成果是（）。产品的外观。产品的质量。产品的经济效果和技术性能指标。产品的制造工艺。 A storage specialist is presenting DS5300 and mentions that the maximum available cache is 64GB. The customer asks if that cache is backed up to hard drives in the event of a power outage.From the following list, which competitor is most likely also talking to this customer?（） EMC 。 HDS 。 SUN 。 NetA。适用于水深不大于6～8m，流速小于3～5m/s的水利工程的围堰是（）土石围堰。草土围堰。木笼围堰。混凝土围堰。

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：
SQL> SELECT job FROM emp
2 WHERE job=’CLERK’ FOR UPDATE OF empno;
SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-042题库

相关题目: