Oracle Oracle Database 1Z0-068 Questions & Answers

• Question 131:

  Examine these commands:

  $ srvctl add service 璬b racdb 璼ervice erp 璼erverpool srvpooll

  - failovertype TRANSACTION 璫ommit_outcome TRUE ?replay_init_time 1800

  - retention 86400 璶otification TRUE 璻lbgoal SERVICE_TIME 璫lbgoal SHORT

  - failoverretry 30 ?failoverdelay 10 $ srvctl start service ?db racdb ?service erp

  Instances RACDB_1 and RACDB_2 run on host01 and host02, respectively. Which three statements are true regarding the service erp?

  A. Connections to the database using erp benefit from Application Continuity.

  B. erp is configured for an administrator-managed RAC database.

  C. Load Balancing Advisory (LBA) will be disabled for this service.

  D. Connections to the database using erp benefit from Load Balancing.

  E. Connections to the database using erp benefit from Transaction Guard.

  Correct Answer: ADE

  Section: (none)

  A: To enable Application Continuity for Java, set the failovertype parameter to TRANSACTION.

  D: -clbgoal {SHORT | LONG}

  Connection Load Balancing Goal. Use a value of SHORT for this parameter for run-time load balancing, or if using an integrated connection pool.

  E: Enable Transaction Guard through the -commit_outcome parameter. When it is set to TRUE, the commit outcome for a transaction is accessible after the transaction's session fails due to a recoverable outage.

  Incorrect Answers:

  C: Load Balancing Advisory (LBA) is set through 璻lbgoal parameter. Set this parameter to SERVICE_TIME to balance connections by response time

  References: https://docs.oracle.com/database/121/RACAD/srvctladmin.htm#RACAD5050

• Question 132:

  Which three statements are true about the Global Enqueue Service and Global Enqueue Service (GES) Resources in Oracle 12c RAC?

  A. The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.

  B. The LMD0 runs only on the instance that masters all GES resources.

  C. When a GES resource is dequeued, converters if any exist for that resource, are processed before any waiter for that resource.

  D. The LMD0 process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.

  E. The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode.

  F. An LMD0 process runs on all instances.

  G. The foreground process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.

  Correct Answer: AFG

  Section: (none)

• Question 133:

  Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 12c RAC?

  A. An XCUR block image may exist for a specific database block in only one instance.

  B. A CR image may get served from one instance to another to satisfy a read request.

  C. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.

  D. A PI block image may exist for a specific database block in only one instance.

  Correct Answer: AB

  Section: (none)

  A: xcur is a RAM block that has been acquired in exclusive current mode. According the Oracle documentation, if a buffer state is exclusive current (XCUR), an instance owns the resource in exclusive mode.

  B: cr mode indicates a "cloned" RAM block (a "stale" block), that was once in xcur mode. The instance has shared access to the block and can only perform reads. The cr state means the owning instance can perform a consistent read of the block, if the instance holds an older version of the data.

  References: http://www.dba-oracle.com/t_v$bh_status_free_buffer_blocks.htm

• Question 134:

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

  Server pool prod_pool has a cardinality of three and all six hosts of the cluster app.

  Examine these commands executed on HOST01:

  $ srvctl add service 璬b CDB1 璸db PDB_1 service AR 璼erverpool prod_pool 璫ardinality singleton $ srvctl start service 璬b CDB1 璼ervice AR

  Which two statements are true regarding the AR service?

  A. AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.

  B. AR is available on any one available CDB1 instance in prod_pool at any one time.

  C. AR can fail over to any one of the available CDB1 instances.

  D. AR is available only on the CDB1 instance on HOST01.

  E. AR can fail over to any other available CDB1 instance in prod_pool.

  Correct Answer: CD

  Section: (none)

• Question 135:

  Which three statements are true about the services created when the DBCA is used to create a RAC database?

  A. They can be policy managed for a multitenant database.

  B. Singleton services are not permitted for multitenant databases.

  C. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service.

  D. Policy-managed services specified for a database allow the creation of a new server pool using DBCA.

  E. They can be administrator managed for a multitenant database.

  Correct Answer: BCE

  Section: (none)

  C: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in Oracle Enterprise Manager Cloud Control, if available, or SRVCTL.

  E: During installation, if you select a multitenant container database (CDB), and configure pluggable databases (PDBs), then Oracle recommends that you add services to the PDBs after installation. Incorrect Answers:

  D: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in Oracle Enterprise Manager Cloud Control, if available, or SRVCTL. References: https://docs.oracle.com/database/121/RIWIN/dbcacrea.htm#RIWIN1320

• Question 136:

  Examine the output of this command: ASMCMD> volinfo

  Correct Answer: AD

  Section: (none)

• Question 137:

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

  It runs on an eight-node cluster and a serverpool prod_pool has three servers.

  Examine these commands executed on HOST01:

  $ srvctl add service 璬b CDB1 璸db PDB_1 璼ervice HR 璼erverpool prod_pool $ srvctl start service 璬b CDB1 璼ervice HR

  $ srvctl stop service 璬b CDB1 璼ervice HR

  Which two statements are true?

  A. HR is uniformly managed across all instances in prod_pool.

  B. srvctl stop service only closes PDB_1 in the instance on HOST01.

  C. srvctl stop service closes PDB_1 on all CDB1 instances.

  D. srvctl stop service prevents logins for HR only to CDB1 on HOST01.

  E. srvctl stop service prevents logins to any instance of CDB1 using service HR.

  F. HR is available on a single instance of prod_pool.

  Correct Answer: BF

  Section: (none)

• Question 138:

  Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement?

  A. It cancels pending drops of disks dropped using the DROP DISKGROUP command.

  B. A disk cannot be undropped as a result of a drop diskgroup.

  C. It automatically unmounts the disks after successfully undropping them.

  D. It is not possible to cancel pending drops of disks dropped using the force option.

  Correct Answer: BD

  Section: (none)

  The UNDROP DISKS clause of the ALTER DISKGROUP statement cannot be used to restore disks that are being dropped as the result of a DROP DISKGROUP statement, or for disks that are being dropped using the FORCE clause.

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm

• Question 139:

  Examine the output of the asmcmd and srvctl commands:

  $ asmcmd showclustermode

  ASM cluster : Flex mode enabled

  $ srvctl status asm 璬etail

  ASM is running on host01, host03

  ASM is enabled.

  $ srvctl config asm

  ASM home: /u01/app/12.1.0/grid

  Password file: +DATA/orapwASM

  ASM listener: LISTENER

  ASM instance count: 2

  Cluster ASM listener: ASMNET1LSNR_ASM

  Then you execute this command:

  $ srvctl relocate asm ?currentnode host03 璽argetnode host02

  Which three statements are true regarding the execution of this command based on the output shown?

  A. It fails because an ASM instance is not configured to run on HOST02.

  B. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.

  C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.

  D. It fails because the ASM instance has not been shut down first on HOST03.

  E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnected.

  F. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.

  Correct Answer: CEF

  Section: (none)

• Question 140:

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

  A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.

  B. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.

  C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.

  D. acfsutil encr on can be used to specify the encryption key length for a directory or file.

  E. An ACFS snapshot can be ACFS encrypted.

  Correct Answer: ADE

  Section: (none)

  acfsutil encr on