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
您可能感兴趣的试卷
你可能感兴趣的试题
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.
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.
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.
最新试题
Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undo segment?()
Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?()
View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:Choose the correct sequence.()
Which three statements are true about persistent configuration?()
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
View the exhibit and examine the TRANS table's storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?()