多项选择题
A.increase the size of redo log files
B.increase the size of the undo tablespace
C.increase the size of the Database Buffer Cache
D.increase the size of the default temporary tablespace
E.enable the retention guarantee for the undo tablespace
多项选择题 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？（）
多项选择题 WhichtwoarevalidlockinglevelsthatareusedbytransactionsinanOracledatabase？（）
单项选择题 The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）