单项选择题

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.

单项选择题

Which statement is true regarding this setting?（）

A.It drops the connection after the specified number of login attempts fail for any user.
B.It is enforced only if the password profile is enabled for the user.
C.It locks the user account after the specified number of attempts.
D.It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.