单项选择题

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?（）

A. AWR baselines are always created as repeating baselines.
B. AWR baselines can be created on the basis of two time values.
C. AWR baselines are always created with infinite expiration duration.
D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

<上一题目录下一题>

热门试题

单项选择题Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?（）

A. ASMB
B. PMON
C. RBAL
D.SMON

单项选择题You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）

A. One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
B.One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
C. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
D. None of the tables are recovered from the Recycle Bin, and the statement returns an error.

单项选择题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?（）

A. 1, 2, 3
B. 3, 2, 1
C. 2, 3, 1
D. 1, 3, 2

单项选择题Evaluate the following function code: 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.