Free Oracle 1z0-034 Exam Dumps Questions & Answers

Note the output of the following query:
SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive;
FLASHBACK_ARCHIVE_NAMESTATUS
FLA1
You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTERTABLEexchange_rateFLASHBACK ARCHIVE;
What is the outcome of this command?

• A.  The Flashback Data Archive is created in the SYSAUX tablespace.
• B.  The table uses the default Flashback Data Archive.
• C.  The command generates an error because no Flashback Data Archive name is specified and there is no default Flashback Data Archive.
• D.  The Flashback Data Archive is created in the same tablespace where the tables are stored.

You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.
Identify two prerequisites to perform the backups. (Choose two.)

• A.  The tablespaces are required to be in backup mode before taking the backup.
• B.  The database must be opened in restricted mode.
• C.  The tablespaces are required to be in read-only mode before taking the backup
• D.  The database must be configured to run in ARCHIVELOG mode.

You want to create a consumer group, GROUP1, and you execute the following command
in the command-line interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP
=>'group1', COMMENT => 'New Group'); This command errors out displaying the following message: ERROR at line 1: ORA-29371: pending area is not active ORA-06512: at "SYS.DBMS_RMIN", line 115 ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1 What action would you take to overcome this error?

• A.  increase the size of the large pool to accommodate the Pending Area
• B.  activate the Pending Area before creating the consumer group
• C.  increase the size of the shared pool to accommodate the Pending Area
• D.  increase the size of the database buffer cache to accommodate the Pending Area
• E.  create the Pending Area before creating the consumer group

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

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.  An overflow tablespace must have been specified.
• D.  A mapping table must have been created.