Oracle Oracle Database 1Z0-068 Questions & Answers

• Question 101:

  You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2.

  Examine these commands executed on host01: $ srvctl add service 璬b CDB1 璸db PDB_1 璼erverpool prod_pool 璫ardinality singleton $ srvctl start service 璬b CDB1 璼ervice CRM $ srvctl stop service 璬b CDB1 璼ervice CRM

  Which three statements are true?

  A. CRM is only available for new logins on the CDB1 instance on host01.

  B. CRM is available for new logins on one CDB1 instance.

  C. The srvctl start service command automatically opens PDB_1 if not already opened.

  D. The srvctl stop service command does not close PDB_1 on any instance of CDB1.

  E. The CRM service is not available for new logins on any instance of CDB1.

  Correct Answer: CDE

  Section: (none)

• Question 102:

  Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC?

  A. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes.

  B. Grid infrastructure must be installed on all cluster nodes where the Database software will be installed.

  C. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database Software will be installed.

  D. Grid infrastructure must be installed on all cluster nodes.

  E. The Clusterware stack must be up on all cluster nodes.

  Correct Answer: AD

  Section: (none)

  A: You must enable SSH User Equivalency on Cluster Nodes.

  References: https://docs.oracle.com/database/121/CWLIN/manpreins.htm#CWLIN407

• Question 103:

  Which two statements are true about ASM alias names?

  A. ASM files created using an alias name are not OMF files even if OMF is enabled.

  B. Alias file names cannot be used together with templates when creating tablespaces.

  C. ASM files created using an alias name are OMF files even if OMF is not enabled.

  D. Alias names can be stored only in user-defined directories.

  E. ASM files created using an alias name also have a fully qualified name and can be accessed by either name.

  Correct Answer: AB

  Section: (none)

  A: Alias names are not created as OMF.

  B: An alias ASM filename with template is used only for ASM file creation operations. It has the following format: +dgroup(template_name)/alias

  Incorrect Answers:

  D: You can create an alias in any system-generated or user-created Oracle ASM directory.

  References: https://docs.oracle.com/database/121/OSTMG/GUID-7AE5B8CA-B563-4864-A934- 4C170A9590F5.htm#OSTMG10065

• Question 104:

  The DGRP1 diskgroup has these attributes: Normal redundancy

  Two failgroups with four asmdisks in each failgroup

  compatible.asm set to 12.1

  The ASM_POWER_LIMIT is currently set to 1 in the ASM instances. There are three databases whose instances are up and which access data in the DGRP1 diskgroup.

  No other clients use this diskgroup.

  You want to add two asmdisks to each failgroup, complete the rebalance as quickly as possible, by avoiding checks for access to allocation units, and then restore database availability.

  Examine the list of actions (see exhibit):

  Exhibit:

  

  Identify the correct sequence of required steps:

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

  B. 1, 3, 5, 7

  C. 1, 8, 6, 3, 5, 8, 9, 7

  D. 1, 8, 6, 3, 5, 2, 10, 7

  Correct Answer: C

  Section: (none)

• Question 105:

  Which three statements are true about ASM Cloud File System (ACFS) tagging?

  A. acfssettag is a command provided by a platform-independent API to tag files.

  B. acfssettag is a command provided by a platform-dependent API to tag files.

  C. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.

  D. acfsutil encr on can be used to specify the tag names of the files to be encrypted.

  E. acfsutil tag set can be used to tag files.

  Correct Answer: ACE

  Section: (none)

  A: The acfssettag command sets the tag name on an Oracle ACFS file.

  Syntax

  sb8 acfssettag(const oratext *path, const oratext *tagname, oratext *value, size_t size, ub4 flags);

  C: Oracle ACFS tagging assigns a common naming attribute to a group of files. Oracle ACFS Replication can use this tag to select files with a unique tag name for replication to a different remote cluster site. The tagging option avoids having

  to replicate an entire Oracle ACFS file system.

  E: The acfsutil tag set command adds the given tag to the specified files or directories in an Oracle ACFS file system. Incorrect Answers:

  D: The acfsutil encr on command encrypts an Oracle ACFS file system, directories, or individual files. However, you specify a directory not a tag name.

  References: https://docs.oracle.com/database/121/OSTMG/GUID-9D88AC84-F3E1-432B-8907- E6D7647E1B0F.htm#OSTMG95633 https://docs.oracle.com/database/121/OSTMG/GUID-5A980C0A-BE5E-4489-8A25- ED9596BF6CA2.htm#OSTMG34700

• Question 106:

  PROD1, PROD2 and PROD3 are three active instances of the PROD database.

  Examine these commands executed on PROD1:

  SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid='*'; SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid='PROD1';

  Which statement is true?

  A. PARALLEL_MIN_SERVERS will be 200 for all instances of PROD.

  B. PARALLEL_MIN_SERVERS will be 100 for all instances of PROD.

  C. The second statement returns an error because this parameter must be identical for all instances.

  D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.

  Correct Answer: D

  Section: (none)

  First SET PARALLEL_MIN_SERVERS is set to 200 for all instances, then it is set to 100 for PROD1.

• Question 107:

  Which three statements are true about Global Resource Management in an Oracle 12c RAC database?

  A. Lazy remastering occurs when an instance shuts with SHUTDOWN IMMEDIATE.

  B. Object remastering causes all blocks in any instances' buffer cache from the same object to be mastered in the Global Resource Directory (GRD).

  C. When a database instance fails, then some global resource masters lost from the failing instance are remastered among the surviving instances.

  D. Lazy remastering instances occurs when an instance shuts with SHUTDOWN TRANSACTIONAL.

  E. Global Enqueue resources are recovered after Global Cache Resources after an instance failure.

  Correct Answer: BCD

  Section: (none)

  B: Remastering is the term used that describes the operation whereby a node attempting recovery tries to own or master the resource(s) that were once mastered by another instance prior to the failure. When one instance leaves the cluster, the GRD of that instance needs to be redistributed to the surviving nodes. RAC uses an algorithm called lazy remastering to remaster only a minimal number of resources during a reconfiguration.

  D: Using the SHUTDOWN TRANSACTIONAL command with the LOCAL option is useful to shut down a particular Oracle RAC database instance. Transactions on other instances do not block this operation.

  C: Recovery from instance failure is automatic, requiring no DBA intervention. In case of instance failure, a surviving instance can read the redo logs of the failed instance. For example, when using the Oracle Parallel Server, another instance performs instance recovery for the failed instance. In single-instance configurations, Oracle performs crash recovery for a database when the database is restarted, that is, mounted and opened to a new instance. The transition from a mounted state to an open state automatically triggers crash recovery, if necessary.

  Incorrect Answers:

  A: After a NORMAL or IMMEDIATE shutdown, instance recovery is not required. References: https://docs.oracle.com/database/121/RACAD/admin.htm#RACAD8910

• Question 108:

  Examine this query and output:

  SQL> select order_flag, cache_size, session_flag, keep_value, 2 from user_sequences where sequence_name = `SEQ1';

  O CACHE_SIZE S K

  Y 10 N N

  Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.

  The SEQ1 sequence is incremented from all instances equally and is frequently used.

  Which two statements should you execute to reduce SQ enqueue contention?

  A. alter sequence seq1 cache 10000;

  B. alter sequence seq1 order;

  C. alter sequence seq1 noorder;

  D. exec sys.dbms_shared_pool.keep (`SEQ1', `Q')

  E. alter sequence seq1 keep;

  Correct Answer: AD

  Section: (none)

  A: Use cache.

  D: The KEEP procedure keeps an object in the shared pool. Once an object has been kept in the shared pool, it is not subject to aging out of the pool. This may be useful for frequently used large objects. When large objects are brought into the shared pool, several objects may need to be aged out to create a contiguous area large enough.

  References:

  https://ora600tom.wordpress.com/2015/01/09/enq-sq-contention/ https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_shpool.htm#i999221

• Question 109:

  Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?

  A. Taking an AWR snapshot in a RAC database captures data from all instances that have the database opened.

  B. Taking an AWR snapshot in a RAC database captures data from the local instance only.

  C. Data captured by an AWR is aggregated across all instances before being stored in the database.

  D. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after the top of the hour before taking its AWR snapshot.

  E. AWR snapshots are created when control_management_pack_access is set to "none"

  Correct Answer: ACD

  Section: (none)

  AWR snapshots are collect at database level.

  Oracle extends the AWR tool for RAC databases by adding the possibility to generate snapshots reports against the whole cluster database, some database instances of the cluster database, a specific database instance of the cluster

  database, statistics for a specific select query.

  D: AWR_SNAPSHOT_TIME_OFFSET specifies an offset for the AWR snapshot start time. AWR snapshots normally start at the top of the hour (12:00, 1:00, 2:00, and so on). This parameter allows DBAs to specify an offset for the AWR snapshot start time.

  Incorrect Answers:

  E: CONTROL_MANAGEMENT_PACK_ACCESS specifies which of the Server Manageability Packs should be active. The following packs are available: The DIAGNOSTIC pack includes AWR, ADDM, and so on.

  The TUNING pack includes SQL Tuning Advisor, SQLAccess Advisor, and so on.

  The NONE value means that both packs are not available.

  References: https://docs.oracle.com/cloud/latest/db112/REFRN/initparams018.htm#REFRN10325 http://www.oracle-class.com/?p=2409

• Question 110:

  Which four tasks are performed by DBCA when you convert a single-instance database to a four-instance RAC database?

  A. creating additional redo threads

  B. creating additional undo tablespaces

  C. creating shared ASM disk groups

  D. adding cluster resources

  E. creating database services

  F. adding additional initialization parameters

  Correct Answer: ABDF

  Section: (none)

  A: Create redo threads that have at least two redo logs for each additional instance.

  B: If your single-instance database was using automatic undo management, then create an undo tablespace for each additional instance using the CREATE UNDO TABLESPACE SQL statement.

  Note:

  ABF: You can use Database Configuration Assistant to convert from single-instance Oracle databases to Oracle RAC. DBCA automates the configuration of the control file attributes, creates the undo tablespaces and the redo logs, and

  makes the initialization parameter file entries for cluster-enabled environments. It also configures Oracle Net Services, Oracle Clusterware resources, and the configuration for Oracle RAC database management for use by Oracle Enterprise

  Manager or the SRVCTL utility.

  References: https://docs.oracle.com/cd/B28359_01/install.111/b28264/cvrt2rac.htm