Online Access Free 1z1-034 Exam Questions

While designing a database, you created the EMPLOYEES table as an index-organized table (IOT).
You must create a bitmap index on the EMPLOYEES .JOB_ID column.
Which must you do to enable the creation of the bitmap index?

• A.The PCTTHRESHOLD option must have been specified.
• B.A primary key must have been created.
• C.A mapping table must have been created.
• D.An overflow tablespace must have been specified.

You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
Identify the statement that correctly describes the implications of this command.

• A.when there are already three backup, one of the existing backups must be removed manually before takingthe fourth backup.
• B.the number of backups that are retained is equal to three and it includes full, incremental, and cumulativebackups.
• C.when there are already three backups, for the fourth backup RMAN removes the oldest backup.
• D.When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

• A.The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provide that there is enough space
• B.An upper limit on how far you can flash back the database, depending on the information in the redo logs
• C.An upper limit on how far you can flash back the database, depending on the information in the undo tablespace
• D.The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?

• A.The installation proceeds with the default value without warnings and errors.
• B.The installation terminates with an error.
• C.The installation proceeds with the default value but a message would be generated in the alert log file.
• D.The installation proceeds with the default value but it would not be an OFA-compliant database.

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

• A.The backup as copy can only be taken to tape
• B.Backup can be performed only when the instance is shutdown
• C.The backup as copy can only be taken to disk
• D.Backup will constitute all used and unused blocks in the database