A. Building the SQL profile
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans
您可能感兴趣的试卷
你可能感兴趣的试题
Examine the parameter setting in your database:
Which statement is correct about the database?()
A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
A. Set MEMORY_TARGET to zero
B. Set the STATISTICS_LEVEL parameter to BASIC
C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
A. A user cannot set privileges on the persistent lightweight jobs
B. Persistent lightweight jobs generate a large amount of metadata
C. It is possible to create fully self-contained persistent lightweight jobs
D. The use of a template is mandatory to create persistent lightweight jobs
E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
A. Only one window can be open at any given time
B. Consumer groups are associated with windows
C. Windows work with job classes to control resource allocation
D. The database service name must be provided during windows creation
E. Windows can automatically start job or change resource allocation among jobs for various time periods.
A. Backup retention policy
B. Default backup device type
C. Default destinations for backups
D. Multiple backup device types for single backup
E. Default section size for backups
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch?()
A.An entry is created in the alert log file and the database instance continues to function normally
B.The log switch hangs occur for transactions until free space is available in the flash recovery area
C.The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area Oracle
D.The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
A. Oracle Net Manager
B. Listener Control utility
C. Database Configuration Assistant
D. Oracle Net Configuration Assistant
A. Both source and target database must be the same character set
B. Both source and target database must have the same endian format
C. The COMPATIBLE parameter must be the same in the source and target databases.
D. The minimum compatibility level for both the source and target database must be 10.0.0.
E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.
A. The transparent encryption of backups uses the encryption wallet
B. The database uses the same encryption key for every encrypted backup
C. The password encryption of backups only uses the password while creating and restoring backup
D. If transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups.
A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
B. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
C. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
D. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
最新试题
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
Examine the following RMAN script:Which statement describes the purpose of the script?()
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()
Which two statements are true about the Automatic Diagnostic Repository (ADR)?()
Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occur in the event of a log switch?()
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()
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?()