Oracle Oracle Database 1Z0-068 Questions & Answers

• Question 51:

  You administer an Oracle 12c RAC database whose clients connect to the database instances using SCAN listeners.

  Which two statements are true regarding client-side connect-time load balancing? (Choose two.)

  A. You must add SCAN VIPs to the REMOTE_LISTENER parameter to enable correct listener cross- registration.

  B. Client connection requests are automatically load balanced across the IP addresses defined for the listeners. SCAN

  C. You must explicitly set LOAD_BALANCE=ON in the client-side TNS entry being used.

  D. The LOCAL_LISTENER parameter for each instance must be manually set to point to the node listener on each node.

  E. SCAN listeners redirect connection requests to a node listener for the appropriate instance.

  Correct Answer: BE

  Section: (none)

• Question 52:

  Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose three.)

  A. They are automatically configured to use Enterprise Manager Express.

  B. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation.

  C. They can be policy managed.

  D. They can be administrator managed.

  E. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource,

  F. They can have multiple pluggable databases (PDB) when the container database (CDB) is created.

  Correct Answer: BCD

  Section: (none)

  Reference: https://docs.oracle.com/database/121/RILIN/dbcacrea.htm#RILIN1037

• Question 53:

  Examine this command:

  $ srvctl modify service -db RACDB -service SRVBl -clbgoal LONG

  This three-Instance RAC database uses Flex ASM.

  Which two statements are true regarding server-side connect-time load balancing using SCAN listeners for this service? (Choose two.)

  A. It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client.

  B. The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service.

  C. The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service.

  D. It is disabled because the -c1bgoal attribute is set to LONG.

  E. The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service.

  Correct Answer: AD

  Section: (none)

• Question 54:

  Disk group DGRP1 has these attributes:

  1. Normal redundancy

  2. Two failure groups FG1 and FG2 with two disks each

  3. Compatibility settings set to 12.1

  The FG1 failure group goes offline due to hardware failure.

  Which two statements are true? (Choose two.)

  A. The redundancy is lowered until the FG1 failgroup is restored and the disk group resynchronized.

  B. New allocation units are mirrored in the FG2 failure group until FG1 is restored and the disk group resynchronized.

  C. Transactions on database objects stored in tablespaces in the DGRP1 disk group fail.

  D. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

  Correct Answer: BC

  Section: (none)

• Question 55:

  Which two statements are true about clustered ASM instances? (Choose two.)

  A. An ASM instance must store its SPFILE in ASM.

  B. The ASM passwordfile can be stored in $GRID_HOME/dbs on local storage of a cluster node.

  C. The ASM passwordfile can be stored in a diskgroup that is accessible to all ASM instances.

  D. The SPFILE must be stored in $GRID_HOME/dbs on local storage of a cluster node.

  E. The SPFILE must be stored in a diskgroup that is accessible to all ASM instances.

  Correct Answer: CD

  Section: (none)

• Question 56:

  Examine this command and output:

  [root@host01 ~]# / sbin/acfsutil snap create snap001 /u0l/app/grid/acfsmount/

  acfsutil snap create: Snapshot operation is complete.

  Examine this command:

  [root@host01 ~]# / sbin/acfsutil snap create

  Correct Answer: C

  Section: (none)

• Question 57:

  Which three statements are true about fully qualified file names in ASM? (Choose three.)

  A. They are system generated at the time of ASM file creation.

  B. They can be used to reference existing ASM files.

  C. They can be created only if OMF is enabled.

  D. They are the only valid form that can be used for single file creation of a control file.

  E. An alias may be created for an existing file by referring to the fully qualified file name.

  Correct Answer: ABE

  Section: (none)

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b31107/asmfiles.htm#OSTMG10264

• Question 58:

  A clustered ASM Instance has the DATA diskgroup mounted.

  Which two can be used to display information about databases accessing files in the DATA diskgroup? (Choose two.)

  A. asmcmd lsct

  B. v$session

  C. v$process

  D. v$asm_client

  E. asmcmd lsdg

  Correct Answer: DE

  Section: (none)

  Reference: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_util004.htm#OSTMG94556

• Question 59:

  Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement? (Choose two.)

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

  B. ASM disks can never be undropped as a result of a DROP DISKGROUP.

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

  D. Disks must be rebalanced manually after successfully undropping them.

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

  Correct Answer: AE

  Section: (none)

  Reference: https://oracle-base.com/articles/10g/automatic-storage-management-10g

• Question 60:

  View the Exhibit.

  

  Which three statements are true? (Choose three.)

  A. The three listed disks may have previously belonged to a disk group.

  B. The three listed disks may already be members of an existing disk group.

  C. To allow an 11g R2 database to use this disk group, ASM Compatibility must be 11.2 or lower.

  D. The COMPATIBLE parameter of any database client using this disk group can be less than or equal to 12.1.

  E. ADVM compatibility can be set greater than or equal to 11.2 without changing the value of ASM compatibility.

  F. The three listed disks are have definitely not been provisioned using ASMLIB.

  Correct Answer: ADE

  Section: (none)