多项选择题

User SCOTT executes the following command on the EMP ta……

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

A.LOCK TABLE emp IN SHARE MODE；
B.LOCK TABLE emp IN EXCLUSIVE MODE；
C.UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
D.INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
E.SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

<上一题目录下一题>

热门试题

单项选择题You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）

A.System monitor （SMON）
B.Process monitor （PMON）
C.Memory manager process （MMAN）
D.Manageability Monitor process （MMON）

多项选择题Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）

A.A CHECK constraint is created on the OID column.
B.A NOT NULL constraint is created on the OID column.
C.The ORDERS table is the only object created in the USERS tablespace.
D.The ORDERS table and a unique index are created in the USERS tablespace.
E.The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

多项选择题Youareworkingonadatabasethatmustbefunctioning24hoursaday，7daysaweek.ThedatabaseisconfiguredinARCHIVELOGmode.Whichtwooptionsdoyouhaveforperforminguser-managedbackups（）

A.You can perform consistent backups only.
B.You can perform a complete database backup without shutting down the database instance.
C.You can back up data files only when all data files have the same SCN recorded in the control file.
D.You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands

多项选择题Whichstatementsarecorrectabouttemporarytables（）

A.Indexes and views can be created on temporary tables.
B.Both the data and the structure of temporary tables can be exported.
C.Temporary tables are always created in a user’s temporary tablespace.
D.The data inserted into a temporary table in a session is available to other sessions.
E.Data manipulation language （DML） locks are never acquired on the data of temporary tables

单项选择题You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）

A.The XML script
B.The PL/SQL script
C.The DBMS_SCHEDULER package
D.Enterprise Manager to schedule the backup