Exam Code: 1Z0-067 (), Exam Name: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP, Certification Provider: Oracle Certifitcation, Free Today! Guaranteed Training- Pass 1Z0-067 Exam.

Check 1Z0-067 free dumps before getting the full version:

NEW QUESTION 1
You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.
Which statement is true about the database that is created? (Choose the best answer.)

  • A. It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.
  • B. It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).
  • C. It is created as a PDB that must be plugged into an existing CDB.
  • D. It is created as a CDB with the CDB$ROOT and PDB$SEED database

Answer: D

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

  • A. 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.
  • B. In a PDB plan, subplans may be used with up to eight consumer groups.
  • C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groupsacross all PDBs in the CDB.
  • D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
  • E. 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: AE

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

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

Answer: AC

Explanation: References: https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13586

NEW QUESTION 4
Which two statements are true about roles in multitenant container databases (CDBs)?

  • A. Local roles can be granted to local and common users.
  • B. A common role can be granted only to a common user.
  • C. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.
  • D. A common role can be granted only system privileges.
  • E. The root container can have both local and common roles.
  • F. A local role can be assigned to a common role in a PD

Answer: DF

NEW QUESTION 5
Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions? Choose the best answer.

  • A. when recovering data that was lost after a DDL operation modified the structure of a table
  • B. when recovering dropped tables that are present in the recyclebin
  • C. when recovering a table that has been logically corrupted
  • D. when recovering a table to a point in time
  • E. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo.

Answer: A

NEW QUESTION 6
You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:
RMAN> DUPLICATE TARGET DATABASE TO cdbdup PLUGGABLE DATABASE sales
FROM ACTIVE DATABASE PASSWORD FILE
SPFILE NOFILENAMECHECK;
Which two statements are true? (Choose two.)

  • A. RMAN must be connected to a recovery catalog for the execution of the command.
  • B. A backup of the SALES PDB must exist before the execution of the command.
  • C. The root and seed databases are included in the duplication.
  • D. Only the SALES PDB is duplicated as the non-CDB CDBDUP.
  • E. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Answer: CE

NEW QUESTION 7
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:
SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users
QUOTA I00M ON users TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

  • A. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.
  • B. The command succeeds only if all the PDBs have the users and temp tablespaces.
  • C. The command gives an error because the container=all clause is missing.
  • D. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does not exist in that PDB.

Answer: B

Explanation: When creating a common user, any tablespace, tablespace group or profile specified in the CREATE command must exist in every PDB. If none of these are specified, the default TABLESPACE, TEMPORARY TABLESPACE, and PROFILE for the PDB will be used.

NEW QUESTION 8
During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set for large pool.
What must you do to allow the memory pools to change size automatically as required? (Choose the best answer.)

  • A. Enable AMM and set the SGA_TARGET initialization parameter to a nonzero value.
  • B. Enable AMM and set the PRE_PAGE_SGA initialization to TRUE.
  • C. Enable Automatic Memory Management (AMM) and set the PGA_TARGET initialization parameter to a nonzero value.
  • D. Enable AMM and set the PGA_TARGET initialization parameter to a nonzero valu

Answer: B

NEW QUESTION 9
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?

  • A. The current online redo log file is missing.
  • B. A data file belonging to a noncritical tablespace is missing.
  • C. All the control files are missing.
  • D. The database backup is older than the control file backup.
  • E. All the data files are missin

Answer: AC

Explanation: http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel

NEW QUESTION 10
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

  • A. All data files belonging to pdb2_1 are backed up and all archive log files are deleted.
  • B. All data files belonging to pdb2_1 are backed up along with the archive log files.
  • C. Only the data files belonging to pdb2_ are backed up.
  • D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

Answer: C

NEW QUESTION 11
For which two requirements would you use the Database Resource Manager?

  • A. limiting the CPU used per database call
  • B. specifying the maximum number of concurrent sessions allowed for a user
  • C. specifying the amount of private space a session can allocate in the shared pool of the SGA
  • D. limiting the degree of parallelism of operations performed by a user or group of users
  • E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions

Answer: DE

Explanation: Limit the degree of parallelism of any operation performed by members of a group of users. Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.

NEW QUESTION 12
Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN RUN block execution?

  • A. The script is executed and both DC1 and CH1 channels are used for script execution.
  • B. The execution of the script fails because multiple channels cannot exist simultaneously.
  • C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
  • D. The new channel, CH1, is ignored because a channel has been configured alread

Answer: C

NEW QUESTION 13
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user. The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user.
A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open.
In the CATD3i2c database, you execute the commands:
: r-ar.
RKAN> CONNECT CATALOG rci2c/passI2c@catdbi2c
RKAN> IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; What is the outcome of the import?

  • A. It fails because the target database and recovery catalog database are of different versions.
  • B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.
  • C. It succeeds but the database is not automatically registered in the rc:2c catalog.
  • D. It fails because RMAN is not connected to the target database with r3:T=:42324:.

Answer: B

NEW QUESTION 14
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 event parameter was not set.
  • B. The sql_trace parameter is set to false.
  • C. Enterprise Manager was not used.
  • D. The statistics_level parameter is set to basic.
  • E. The t:kid_statistics parameter is set to fals

Answer: D

Explanation: To enable the dbms_server_alert package functionality, set the statistical_level initialization parameter to TYPICAL or ALL.
http://www.dba-oracle.com/t_dbms_server_alert.htm

NEW QUESTION 15
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 backup optimization.
  • B. Configure the channel to increase maxopenfiles.
  • C. Configure a backup policy by using incremental backups.
  • D. Configure the channel to increase capacity with the rate parameter.
  • E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
  • F. Configure large_pool, if not done alread
  • G. Alternatively, you can increase the size of
  • H. LARGE_POOL.

Answer: BE

Explanation: Allocation of Tape Buffers If you back up to or restore from an SBT device, then by default the database allocates four buffers for each channel for the tape writers. The size of the tape I/O buffers is platform-dependent. You can change this value with the PARMS and BLKSIZE parameters of the
ALLOCATE CHANNEL or CONFIGURE CHANNEL command. You can improve backup performance by adjusting the level of multiplexing, which is number of input files simultaneously read and then
written into the same RMAN backup piece. The level of multiplexing is the minimum of the MAXOPENFILES setting on the channel and the number of input files placed in each backup set. The following table makes recommendations for adjusting the level of multiplexing.

NEW QUESTION 16
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

  • A. assigned to a class with rights to browse all directories and catalogs
  • B. assigned to a class with rights to back up or restore Oracle database
  • C. OSB encryption for data in transport and on tape
  • D. RMAN preauthorization on the host
  • E. matching the OS user identity of the Oracle instance associated with the database username
  • F. scheduling of the RMAN backup to occur automatically at user-defined intervals

Answer: BDE

NEW QUESTION 17
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?

  • A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
  • B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
  • C. by using Active Session History (ASH) data and performing hang analysis
  • D. by running ADDM in diagnostic mode

Answer: B

NEW QUESTION 18
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?

  • A. expdp will fail because no path has been defined for the dumpfile.
  • B. expdp will succeed but impdp will fail because the users do not exist.
  • C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
  • D. 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

Explanation: ORA-39165: Schema not found error will be resulted

100% Valid and Newest Version 1Z0-067 Questions & Answers shared by Certifytools, Get Full Dumps HERE: https://www.certifytools.com/1Z0-067-exam.html (New 231 Q&As)