單項選擇題

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）

A.SQL statements that are part of the AWR baseline only
B.SQL statements based on the AWR top SQL identification
C.SQL statements that are part of the available SQL Tuning Set (STS) only
D.SQL statements that are available in the cursor cache and executed by a user other than SYS

你可能感興趣的試題

多項選擇題

What are the advantages of variable extent size support for large ASM files?（）

A.It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
B.It improves performance in the extended cluster configuration by reading from a local copy of an extent.
C.Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
D.This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

單項選擇題

Which statement is true regarding virtual private catalogs? （）

A.A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
B.The virtual private catalog owner cannot create and modify the stored scripts.
C.The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D.To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.