What can you achieve by implementing reverse key index?
A. Remove repeated key values from the index to fit more index entries in a given amount of disk space
B. Prevent contention on the highest leaf block when using sequences to generate keys
C. Reverse the bytes of each column indexed including the row ID
D. Store a bitmap for each key value instead of a list of row IDs in the leaf node
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects. Which statement is true in this scenario?
A. This produces an error and the statistics collected are locked until the next time that the maintenance
window is opened
B. The job is terminated and the statistics collected are restored to a time before the job started
C. The job is terminated and the statistics for the remaining objects are collected the next time that the
maintenance window is opened
D. The statistics collection continues until all objects are processed
In which situation would you use static database registration for a listener?
A. When DBAs need to connect remotely to start up the database instance
B. When users need to connect the database instance using the host naming method
C. When the database instance that is to be registered with the listener is configured in shared server
D. When multiple databases are to be registered with the listener
You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.)
A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
Which statement about the execution of this script is true?
A. It must be executed from the Oracle Database 11g environment.
B. It must be executed only after the SYSAUX tablespace has been created.
C. It must be executed from the environment of the database that is being upgraded.
D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)
A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload.
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)
A. Generate reports on data failure such as data file failures.
B. You can package and upload diagnostic data to Oracle Support.
C. You can track the Service Request (SR) and implement repairs.
D. You can manually run health checks to gather diagnostic data for a problem.
Which statement is true regarding the VALIDATE DATABASE command?
A. It checks the database for intrablock corruptions only.
B. It checks for block corruption in the valid backups of the database.
C. It checks the database for both intrablock and interblock corruptions.
D. It checks for only those corrupted blocks that are associated with data files.
Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
A. Undo retention guarantee must be enabled.
B. Database must be running in archivelog mode.
C. Automatic undo management must be enabled.
D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic
Segment Space Management (ASSM).
You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.
You issued the following RMAN commands to create a duplicate database:
RMAN> CONNECT target sys/[email protected]
RMAN> DUPLICATE TARGET DATABASE
FROM ACTIVE DATABASE
SET SGA_MAX_SIZE = ‘300M’
SET SGA_TARGET = ‘250M’
SET LOG_FILE_NAME_CONVERT ‘/oracle/oradata/prod/redo/’,
Which three are the prerequisites for the successful execution of the above command? (Choose three.)
A. The source database should be open.
B. The target database should be in ARCHIVELOG mode if it is open.
C. RMAN should be connected to both the instances as SYSDBA.
D. The target database backups should be copied to the source database backup directories.
E. The password file must exist for the source database and have the same SYS user password as
If you want to pass Oracle 1Z0-050 successfully, do not missing to read latest lead2pass Oracle 1Z0-050 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.