Free Oracle 1z0-067 Exam Dumps Questions & Answers

A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?

• A.cold backup after taking the tablespace offline
• B.multisection parallel backup by using RMAN
• C.multisection image copy backup by using RMAN
• D.cold backup after placing the tablespace in backup mode
• E.image copy backup by using RMAN

RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1
FROM ACTIVE DATABASE
NOFILENAMECHECK
PASSWORD FILE
SPFILE;
Which two statements are true about the execution of the DUPLICATE command?

• A.The duplicate database is created by using the backups created during the execution of the DUPLICATE command.
• B.The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.
• C.The duplicate database has the same directory structure as the source database.
• D.The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.
• E.All archive redo log files are automatically copied to the duplicate database.

Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PREFIX =
'/disk2/oracle/pdb2';
Which two statements are true?

• A.The tablespace specifications of pdb2 are the same as pdb1.
• B.Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
• C.The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
• D.pdb2 is created with its own private undo and temp tablespaces.
• E.All database objects belonging to common users in PD3I are cloned in PD32.

What two are the prerequisites for enabling Flashback Database?

• A.The database must be opened in RESTRICTED mode
• B.The database instance must have the keep buffer pool defined
• C.The database must be in ARCHIVELOG mode
• D.The database instance must be started in the NOMOUNT state
• E.The database must be in MOUNT EXCLUSIVE mode

While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup?

• A.Configure the channel to increase capacity with the rate parameter.
• B.Configure large_pool, if not done already. Alternatively, you can increase the size of
• C.Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
• D.LARGE_POOL.
• E.Configure a backup policy by using incremental backups.
• F.Configure the channel to increase maxopenfiles.
• G.Configure backup optimization.