Oracle Oracle Database 1Z0-068 Questions & Answers

• Question 31:

  Examine this command executed on the first node of a four-node cluster: $ /0Patch/opatch apply 18031528 What does this command do?

  A. It applies a patch to one ORACLE_HOME only on the first cluster node.

  B. It applies a patch to all database ORACLE_HOMEs with the same release only on the first cluster node.

  C. It applies a patch to one ORACLE_HOME on all cluster nodes.

  D. It applies a patch to all database ORACLE_HOMEs with the same release on all cluster nodes.

  E. It applies a patch to all database ORACLE_HOMEs with the same release on the first cluster node.

  Correct Answer: B

  Section: (none)

• Question 32:

  You must deploy several Oracle 12c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:

  1.

  Apply a Grid Infrastructure interim patch.

  2.

  Apply a Grid Infrastructure Patch Set Update (PSU).

  3.

  Apply a database on-line patch.

  4.

  Apply a Grid Infrastructure patchset.

  5.

  Apply a database patchset.

  6.

  Upgrade Grid Infrastructure from one release to another.

  7.

  Upgrade databases from one release to another. Your plan is to perform these tasks:

  1.

  Install and configure Oracle Grid Infrastructure on a local file system.

  2.

  Install Oracle Database software on an ACFS file system.

  3.

  Create several RAC One Node databases. Which of the 7 requirements are met by your plan?

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

  B. 1, 2, 3, 4 and 6.

  C. 1, 2, 3, 4, 5 and 6.

  D. 1, 2, 3 and 4.

  E. 2, 3, 4 and 6.

  F. 2, 3, 4, 5 and 6.

  Correct Answer: F

  Section: (none)

• Question 33:

  Examine this command and output:

  

  You want to relocate this database online to node 016n2.

  Which two statements must be true for a successful online migration? (Choose two.)

  A. The database must be stored on shared storage.

  B. The database must have at least two UNDO tablespaces.

  C. The database must have at least two redo threads defined by the DBA.

  D. Database clients must disconnect before the online relocation timeout expires.

  E. Database clients must use Transaction Guard to prevent them from losing their connection.

  F. The database must be open.

  Correct Answer: EF

  Section: (none)

• Question 34:

  Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.)

  A. They are used when an application uses the DBMS_LOCK package for UL lock types.

  B. They are used to coordinate the next value for a sequence created with the CACHE and ORDBR clauses.

  C. They are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER clauses.

  D. They are used to coordinate access across multiple library caches for the same stored procedure.

  E. They are used to coordinate access across multiple library caches for anonymous PL/SQL execution.

  Correct Answer: BD

  Section: (none)

• Question 35:

  Which two statements are tuning recommendations for RAC database? (Choose two.)

  A. Set PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query.

  B. Use sequences with CACHE and ORDER, if possible.

  C. Use Locally Managed Tablespaces with large uniform extent sizes.

  D. Use Locally Managed Tablespaces with autoallocate.

  E. Set PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing.

  F. Use sequences with CACHE and NOORDER, if possible.

  Correct Answer: AC

  Section: (none)

• Question 36:

  You administer a RAC database that currently runs on a four-node cluster but which has three instances. Which two statements are always true about redo logs for this RAC database? (Choose two.)

  A. A thread of redo must be created before starting a fourth instance if a thread is not already available.

  B. A thread of redo must contain at least two log groups before it can be enabled.

  C. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.

  D. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.

  E. A thread of redo is automatically dropped when as instance is removed from a RAC database by using . SRVCTL

  Correct Answer: DE

  Section: (none)

• Question 37:

  Examine these commands:

  srvctl add service -db RACDB -service CRM -preferred RACDB_1 -available RACDB_2 tafpolicy preconnect

  srvcl start service -db RACDB -service CRM

  Instances RACDB_1 and RACDB_2 run on host0l and host02, respectively.

  This is the only TNS entry in the client side tnsnames.ora:

  CRM =

  (DESCRIPTION =(FAILOVER=ON) (LOAD_BALANCE=ON)

  (ADDRESS= (PROTOCOL=TCP) (HOST=host0l-VIP.example.com)(PORT=1521)) (ADDRESS= (PROTOCOL=TCP) (HOST=host02-VIP.example.com)(PORT=1521)) (CONNECT_DATA = (SERVICE_NAME = CRM)

  (FAILOVER_MODE = (BACKUP=CRM_PRECONNECT)

  (TYPE=SESSION)(METHOD=PRECONNECT))))

  Which statement is true regarding the TAF settings?

  A. Clients using this configuration fail over and restart any active queries automatically.

  B. Clients using this configuration fail over and restart any active transactions automatically.

  C. This configuration will work only for a policy-managed RAC database.

  D. The configuration is incomplete because the TNS entry for the preconnected backup session is missing.

  Correct Answer: D

  Section: (none)

• Question 38:

  You administer a three-instance, policy-managed, multitenant RAC database CDB1 with three PDBs:

  , PDB_2, and PDB_3.

  PDB_1

  You want to drop PDB_3.

  Which two statements are true? (Choose two.)

  A. PDB_3 must be closed on all CDB1 instances.

  B. Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3.

  C. CDB1 must be open in restricted mode on all cluster nodes.

  D. PDB_3 must be open READ ONLY in all CDB1 instances.

  E. Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3.

  Correct Answer: BE

  Section: (none)

• Question 39:

  Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

  A. A server pool directive override can be used to modify the database parameter CPU_COUNT for all databases within one server pool.

  B. It requires a resource manager plan to be active on databases managed by QoS.

  C. It supports RAC One Node databases if they are assigned to server pools with a maximum size of one server.

  D. One QoS policy can span multiple clusters if they contain server pools, assigned to be managed by QoS.

  E. The command-line utility qosct1 can be used to change the password of the internal user QOSADMIN.

  Correct Answer: ABC

  Section: (none)

• Question 40:

  Which three statements are true about the Global Resource Directory (GRD) in Oracle 12c RAC database and in Clustered ASM? (Choose three.)

  A. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.

  B. Clustered ASM has GRD resources distributed among all ASM instances

  C. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.

  D. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.

  E. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.

  F. Shadow GRD resources may exist in more than one database instance for a resource.

  G. Only one GRD shadow resource may exist for an Enqueue Resource.

  Correct Answer: ACE

  Section: (none)