Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 121:

  You are administering a multitenant container database (CDB) that contains multiple pluggable databases

  (PDBs). You are connected to cdb$root as the sys user. You execute the commands:

  SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;

  SQL> CREATE ROLE C##CONNECT;

  SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;

  SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;

  Which statement is true about the c##connect role?

  A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

  B. It is granted to the c##admin user only in the CDB.

  C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

  D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

  Correct Answer: D

  "CONTAINER Clause The CONTAINER clause applies when you are connected to a CDB. However, it is not necessary to specify the CONTAINER clause because its default values are the only allowed values. To create a common role, you must be connected to the root. You can optionally specify CONTAINER = ALL, which is the default when you are connected to the root. To create a local role, you must be connected to a PDB. You can optionally specify CONTAINER = CURRENT, which is the default when you are connected to a PDB." References:https://docs.oracle.com/database/121/SQLRF/statements_6014.htm#SQLRF01311

• Question 122:

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

  A. The PDB must be open in read only mode.

  B. The PDB must be dosed.

  C. The unplugged PDB becomes a non-CDB.

  D. The unplugged PDB can be plugged into the same multitenant container database (CDB)

  E. The unplugged PDB can be plugged into another CDB.

  F. The PDB data files are automatically removed from disk.

  Correct Answer: BDE

  B, not A: The PDB must be closed before unplugging it.

  D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.

  E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB's datafiles can remain in place.

• Question 123:

  Which two statements are true about Flashback Version Query?

  A. The result of a query can be used as part of a DML statement.

  B. It can be used to create views.

  C. It can be used only if Flashback Data Archive is enabled for a table.

  D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.

  E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

  Correct Answer: DE

  Reference: https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01004

• Question 124:

  Which three statements are true about Consolidated Database Replay?

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

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

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

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

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

  Correct Answer: BCE

  These capture files are platform independent and can be transported to another system. You can use Consolidated Database Replay to combine the captured workloads from the three applications and replay them concurrently on PDBs. References: https://docs.oracle.com/database/121/RATUG/GUID-36DE5567-5A64-493B-A1546581C678FC8A.htm#RATUG105 https://docs.oracle.com/database/121/RATUG/GUID-42958859-005D-4B93-9DD379807968EA9E.htm#RATUG4199 https://docs.oracle.com/database/121/RATUG/GUID-C4DC0795-74B2-456D-AA0A-B4F7F45C81F8.htm https://docs.oracle.com/database/121/RATUG/GUID-B1AEA82F-60E5-43CE-BB12-C6D72232886A.htm

• Question 125:

  Which parameter must be set to which value to implement automatic PGA memory management?

  A. Set memory_target to zero.

  B. Set STATISTICS_LEVEL to BASIC.

  C. Set pga_aggregate_target to a nonzero value.

  D. Set pga_aggregate_target and sga_target to the same value.

  E. Set sgajtarget to zero.

  Correct Answer: C

  When automatic memory management is not enabled, the default method for the instance PGA is automatic PGA memory management References: http://docs.oracle.com/cd/B28359_01/server.111/b28318/memory.htm

• Question 126:

  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 already.

  Correct Answer: C

  Reference: https://docs.oracle.com/cd/B12037_01/server.101/b10770/rcmsynta4.htm

• Question 127:

  You create two Resource Manager plans, one for night time workloads, the other for day time.

  How would you make the plans switch automatically?

  A. Use job classes.

  B. Use scheduler windows.

  C. Use the mapping rule for the consumer groups.

  D. Set the switch_time plan directive for both plans.

  E. Use scheduler schedules.

  Correct Answer: B

  The resource manager is only activated when a default resource plan is assigned. Only one resource plan can be active at any given time. Resource plan switches can be automated using scheduler windows or performed manually by setting the resource_manager_plan parameter using the alter system command as shown below. References: http://www.dba-oracle.com/job_scheduling/resource_manager_plan.htm

• Question 128:

  You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

  Which method or feature should you use?

  A. Compare Period ADDM report

  B. AWR Compare Period report

  C. Active Session History (ASH) report

  D. taking a new snapshot and comparing it with a preserved snapshot

  Correct Answer: B

  Comparing Current System Performance to a Baseline Period You may have noticed a performance change on a production system and would like to know why, or you may have implemented a change to a production system and want to know the effect of the change, such as increased concurrency waits. The Compare Period ADDM compares the performance of the database server in two time periods, and returns a report describing the performance changes and the root origin of the changes. The Advisor can analyze any Oracle RDBMS version 10.2.0.4 or later monitored by Cloud Control. The following procedure explains how to initiate a report from the Compare Period ADDM.

• Question 129:

  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 Exadata Grid Disks.

  B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

  C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

  D. Database files stored in ZFS and accessed using conventional NFS mounts.

  E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

  F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

  G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

  Correct Answer: AEG

  HCC requires the use of Oracle Storage ?Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance

  (ZFSSA).

  Note:

  *

  Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above

  *

  Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.

• Question 130:

  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 files by 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.

  5.

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

  6.

  Start the database instance in nomount state.

  7.

  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

  Correct Answer: D

  "If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVER command, even if no datafiles have been restored, and open the database with the RESETLOGS option." References: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmadvre.htm#i1006245