Online Access Free 1z1-067 Practice Test

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

• A.PDB data files are automatically removed from disk.
• B.A PDB must have been opened at least once after creation.
• C.A PDB must be in closed state before it can be unplugged.
• D.An unplugged PDB can be plugged into the same or another container database (CDB).
• E.A PDB must be in MOUNT state before it can be unplugged.

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
$> impdp <user_name> full=Y network_link=hrdb_test transportable=always transport_datafiles=
'/u01/app/oracle/oradata/hrdb/sales01.dbf',
'/u01/app/oracle/oradata/hrdb/cust01.dbf',
'/u01/app/oracle/oradata/hrdb/emp01.dbf',
version=12 logfile=import.log
Which three are prerequisites for successful execution of the command?

• A.All the user defined tablespaces must be in read-only mode on the source database.
• B.The impdp operation must be performed by the same user that performed the expdp operation.
• C.The source and target databases must be running on the same platform with the same endianness.
• D.The path of data files on the target database must be the same as that on the source database.
• E.The export dump file must be created before starting the import on the target database.
• F.The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem?

• A.Increase the size of the redo log buffer.
• B.Enable temporary undo for the database.
• C.Enable Automatic Memory Management (AMM).
• D.Increase the size of the temporary tablespace.
• E.Enable undo retention guarantee.

The SYS user creates this job:

Which two statements are true about this job? (Choose two.)

• A.It is automatically dropped after the last run
• B.It executes with the privileges of OPS
• C.The globalization environment that exist at job creation is used run time
• D.It executes with the privileges of SYS

You restore and recover your database to a new host by using an existing RMAN open database backup.
Which step must you perform next?

• A.Use the RMAN set newname and switch commands to switch to new files.
• B.Set a new database identifier (DBID) for the newly restored database.
• C.Open the database with the resetlogs option.
• D.Execute catproc.sqi to recompile invalid PL/SQL modules.