多项选择题
When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics.
Which two statements describe the implications of this？（）
A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan，and not performance regression，are detected.
相关考题
-
多项选择题
You execute the following Recovery Manager （RMAN） commands in he following order： BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST； Which two tasks are performed by these commands？（）
A. Repair the corrupted blocks. If any. In the backup created
B. Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
C. Back up the database after checking whether array of the files have corrupted blocks
D. Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
E. Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION -
单项选择题
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?（）
A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
C. The database instance starts, but Automatic Memory Management is disabled
D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter -
单项选择题
Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?（）
A.ASMB
B.PMON
C.RBAL
D.SMON
