多項(xiàng)選擇題

A user receives the following error while executing a query：
ORA01555：snapshot too old
Which two options can be the solutions to avoid such errors in future？（）

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

你可能感興趣的試題

多項(xiàng)選擇題

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;

多項(xiàng)選擇題

Which two are valid locking levels that are used by transactions in an Oracle database？（）

A.row level
B.block level
C.object level
D.schema level
E.database level

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

A user receives the following error while executing a query： ORA­01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）

你可能感興趣的試題

Which two are valid locking levels that are used by transactions in an Oracle database？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

A user receives the following error while executing a query：
ORA01555：snapshot too old
Which two options can be the solutions to avoid such errors in future？（）