你可能感興趣的試題

Evaluate the following function code：
CREATE FUNCTION get_dept_avg（dept_id NUMBER） RETURN NUMBER RESULT_CACHE RELIES_ON （EMPLOYEES） IS avgsal NUMBER（6）； BEGIN
SELECT AVG（SALARY）INTO avgsal FROM EMPLOYEES
WHERE DEPARTMENT_ID = dept_id； RETURN avgsal； END get_dept_avg；
Which statement is true regarding the above function？（）

A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
B. If the function execution results in an unhandled exception，the exception result is also stored in the cache.
C. Each time the function is invoked in a different session，the current result in the result cache gets overwritten.
D. If the function is invoked with a different parameter value，the existing result in the result cache gets overwritten by the latest value.

單項(xiàng)選擇題

You want to use RMAN to create compressed backups.
Which statement is true about the compression algorithms that RMAN can use？（）

A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C. The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D. Only the BZIP2 compression algorithm can be used to make compressed backups to disk.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

Following is the list of locations in random order where oranfstab can be placed. 1./etc/mtab 2.$ORACLE_HOME/dbs/oranfstab 3./etc/oranfstab What is the sequence in which Direct NFS will search the locations？（）

你可能感興趣的試題

You want to use RMAN to create compressed backups. Which statement is true about the compression algorithms that RMAN can use？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

Following is the list of locations in random order where oranfstab can be placed.
1./etc/mtab
2.$ORACLE_HOME/dbs/oranfstab
3./etc/oranfstab
What is the sequence in which Direct NFS will search the locations？（）

You want to use RMAN to create compressed backups.
Which statement is true about the compression algorithms that RMAN can use？（）