单项选择题
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.
相关考题
-
单项选择题
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. -
单项选择题
You have the following requirements in relation to the detection of block corruption for your database instance： Check for logical self-consistency of data blocks when modified in memory. Checksums are calculated before and after the block change. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically？（）
A. Set the DB_SECUREFILE parameter to PERMITTED
B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY
C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL
D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL -
单项选择题
Examine the following command： ALTER DISKGROUP data MOUNT FORCE； In which scenario can you use the above command to mount the disk group？（）
A. when ASM disk goes offline
B. when one or more ASM files are dropped
C. when some disks in a disk group are offline
D. when some disks in a failure group for a disk group are rebalancing
