[Free] 2018(Jan) EnsurePass Testking Oracle 1z0-067 Dumps with VCE and PDF 111-120

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-067
100% Free Download! 100% Pass Guaranteed!

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

Question No: 111

Identify two scenarios in which the RMAN crosscheck command canbe used.

  1. when checking for backups that are not required as per the retention policy

  2. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes

  3. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible

  4. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository

  5. when listing backups that are required for recovery operations

Answer: C,E

Question No: 112

Which three requirements must be met before a tablespace can be transported across different platforms?

  1. The tablespace to be transported must be in read-only mode.

  2. The minimum compatibility level for both the source and target databases must be 10.0.0.

  3. The compatible parameter value must be the same in the source and target databases.

  4. Both the source and target databases must use the same character set.

  5. The platforms of both the source and target databases must have the same endian format.

Answer: A,B,D

Explanation: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm

Question No: 113

Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.

Examine the steps to recover the database:

  1. Restore the control filesby using the RMAN restore controlfile command.

  2. Mount the database.

  3. Restore the data files by using the RMAN restore database command. 4.Open the database with the resetlogs option.

  1. Recover the data files by using the RMAN recover using backup controlfile command.

  2. Start the database instance in nomount state.

  3. Connect to the target database by using a recovery catalog. 8.Open the database.

9.Restore the data file. 10.Recover the data file.

Identify the required steps in the correct order.

A. 7,6, 1, 2, 3, 5, 4

B. 7, 2, 1, 3, 5, 8

C. 7, 6, 1, 2, 9, 10, 8

D. 7, 6, 1, 2, 9, 10, 4

Answer: D

Question No: 114

Examine the RMAN command:


Which prerequisitemust be met before accomplishing the backup?

  1. The password for the encryption must be set up.

  2. Oracle wallet for the encryption must be set up.

  3. All the tablespaces in the database must be encrypted.

  4. Oracle Database Vault must be enabled.

Answer: B

Reference:configuration encryption will use by Transparent encryption, For transparent encryption, you will need to create a wallet, and it must be open.

Transparent encryption will then occur automatically after you have issued the CONFIGURE ENCRYPTION FOR DATABASE ON or CONFIGURE ENCRYPTION FOR

TABLESPACE ON command. http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm#CEGEJABH


A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command:



Which statement is true about the execution of the command?

A.The backup succeeds only if all the tablespaces are locally managed.

B.The backup succeeds only if the RMAN default device for backup is set to disk. C.The backup fails because you cannot specify section size for a compressed backup.

D.The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.

Answer: D

Question No: 115

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


Which three are prerequisites to fulfill this requirement?

  1. Minimal supplemental logging must be enabled.

  2. The database must be running in archivelog mode.

  3. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.

  4. The flashback any table privilegemust be granted to the user.

  5. The select any transaction privilege must be granted to the user.

  6. The recycle bin parameter must be set to on.

Answer: C,D,E

Question No: 116

Which three statements are true about Consolidated Database Replay?

  1. The workload capture and replay systems must have the same operating system (OS).

  2. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).

  3. A subset of the captured workload can be replayed.

  4. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

  5. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Answer: B,C,E

Question No: 117

Examine the command used to perform an incrementallevel-0 backup: RMANgt;BACKUPINCREMENTALLEVEL0DATABASE;

To enable block change tracking, after the incremental level 0 backup, you issue the command:



To perform an incremental level-1 cumulative backup, you issue the command: RMANgt;BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE;

Which two statements are true in the preceding situation?

  1. The block change tracking data is used only from the next incremental backup.

  2. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.

  3. The incremental level 1 backup does not use change tracking data for accomplishing the backup.

  4. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.

  5. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Answer: C,E

Question No: 118

Examine these Data Pump commands to export and import objects from and to the same database.

The dba has not yet created users hr1 and oe1.

$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table

$ impdpsysten/manager

schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat

remap_schena=hr:hrl, oe:oe1

What will happen when running these commands?

  1. expdp will fail because no path has been defined for the dumpfile.

  2. expdp will succeed but impdp will fail because the users do not exist.

  3. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

  4. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

Answer: B

Question No: 119

Which two statements are true regarding Oracle Data Pump?

  1. EXPDP and IMPDP are the clientcomponents of Oracle Data Pump.

  2. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

  3. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

  4. Oracle Data Pump imports can bedone from the export files generated in the Original Export Utility.

  5. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Answer: A,B


Question No: 120

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

  1. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

  2. In a PDB plan, subplans may be used with up to eight consumer groups.

  3. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

  4. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

  5. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer: A,E

Explanation: A: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.

In a non-CDB database, workloads within a database are managed with resource plans. In a PDB, workloads are also managed with resource plans,also called PDB resource plans.

The functionality is similar except for the following differences: Non-CDB Database

Multi-level resource plans Up to 32 consumer groups Subplans

PDB Database

Single-level resource plans only Up to 8 consumer groups

(Not B) No subplans

100% Ensurepass Free Download!
Download Free Demo:1z0-067 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-067 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.