Online Access Free 1z0-067 Practice Test

Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.
Which three are prerequisites to fulfill this requirement?

• A.The recycle bin parameter must be set to on.
• B.Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
• C.The database must be running in archivelog mode.
• D.The flashback any table privilege must be granted to the user.
• E.The select any transaction privilege must be granted to the user.
• F.Minimal supplemental logging must be enabled.

Which three statements are true about Oracle Secure Backup (OSB)?

• A.It can be used to take image copy backups to tape.
• B.It can be used to perform file system backups at the file, directory, file system, or raw partition level.
• C.It can encrypt client data written to tape.
• D.It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
• E.It can be used to manage tape backup and restore operations for multiple databases.

You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used?

• A.RMAN Media Management Library
• B.Enterprise Manager Database Express
• C.Enterprise Manager Cloud Control
• D.RMAN recovery catalog
• E.Oracle Secure Backup

Consider the following scenario for your database:
-Backup optimization is enabled in RMAN.
-The recovery window is set to seven days in RMAN.
-The most recent backup to disk for the tools tablespace was taken on March 1, 2015.
-The tools tablespace is read-only since March 2, 2015.
On March 15, 2015, you issue the RMAN command to back up the database via the Media Manager Interface.
Which statement is true about the backup of the tools tablespace?

• A.RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
• B.The RMAN backup fails because the tools tablespace is read-only.
• C.RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.
• D.RMAN skips the backup of the tools tablespace because backup optimization is enabled.

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?

• A.The sql_trace parameter is set to false.
• B.The statistics_level parameter is set to basic.
• C.Enterprise Manager was not used.
• D.The event parameter was not set.
• E.The t:kid_statistics parameter is set to false.