Online Access Free 1z1-067 Practice Test

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

• A.ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
• B.Database files stored in any file system and accessed using the Oracle Direct NFS feature
• C.Database files stored in ZFS and accessed using conventional NFS mounts.
• D.ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• E.Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F.ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• G.ASM disk groups with ASM disks consisting of Exadata Grid Disks.

In which situation can you use Flashback Database?

• A.when retrieving a dropped tablespace
• B.when returning to a point in time before the most recent open resetlogs operation
• C.when returning to a point in time before the restoration or re-creation of a control file
• D.when undoing a shrink data file operation

Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in NOMOUNT state.
Identify the required steps in the correct order.

• A.2, 1, 5, 6, 7, 4, 3
• B.1, 2, 3, 5, 6, 4
• C.1, 2, 5, 3, 6, 4
• D.2, 1, 5, 7, 3, 4

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.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.
• B.All the user defined tablespaces must be in read-only mode on the source database.
• C.The path of data files on the target database must be the same as that on the source database.
• D.The export dump file must be created before starting the import on the target database.
• E.The impdp operation must be performed by the same user that performed the expdp operation.
• F.The source and target databases must be running on the same platform with the same endianness.

When is the UNDO_RETENTION parameter value ignored by a transaction?

• A.when the undo tablespace is of a fixed size and retention guarantee is not enabled
• B.when there are multiple undotablespaces available in a database
• C.when the data file of the undo tablespace is autoextensible
• D.when Flashback Database is enabled