Oracle Oracle Certifications 1Z0-432 Questions & Answers

• Question 31:

  According to the OEM Log Checker, the OCR has failed and must be restored. Which option accurately describes how to fix the problem?

  A. #su oracle ocrconfig -showbackup ocrconfig -replace/oraocfs/crs/data.ocr -replacement +ADMINDG

  B. #su grid ocrconfig -showbackup ocrconfig -replace/oraocfs/crs/data.ocr -replacement +ADMINDG

  C. As root execute: ocrconfig -showbackup ocrconfig -local /oraocfs/crs/data.ocr -recover +ADMINDG

  D. As root execute: ocrconfig -showbackup ocrconfig -replace /oraocfs/crs/data.ocr -replacement +ADMINDG

  E. #su - grid ocrconfig -showbackup ocrconfig -cluster/oraocfs/crs/data.ocr -recover +ADMINDG

  Correct Answer: D

• Question 32:

  Which code must you use to increase the cardinality of the ASM in the cluster?

  A. [root@o16r02 bin]# ./srvct1 add asm -count 1[root@o16r02 bin]# ./srvct1 modify asmASM home: /u01/app/12.1.0/gridPassword file: +DATA/orapwASM ASM listener: LISTENER

  ASM instance count: 1

  Cluster ASM listener: ASMNETILSNR_ASM

  B. [root@o16r02 bin]# ./crvct1 modify asm -count 1[root@o16r02 bin]# ./crvct1 add asmASM home: /u01/app/12.1.0/gridPassword file: +DATA/orapwASMASM listener: LISTENER ASM instance count: 1 Cluster ASM listener: ASMNETILSNR_ASM

  C. [root@o16r02 bin]# ./srvct1 modify asm -count 1[root@o16r02 bin]# ./srvct1 config asmASM home: /u01/app/12.1.0/gridPassword file: +DATA/orapwASMASM listener: LISTENER ASM instance count: 1 Cluster ASM listener: ASMNETILSNR_ASM

  D. [root@o16r02 bin]# ./crvct1 modify asm -count 1[root@o16r02 bin]# ./srvct1 config asmASM home: /u01/app/12.1.0/gridPassword file: +DATA/orapwASMASM listener: LISTENER ASM instance count: 1 Cluster ASM listener: ASMNETILSNR_ASM

  Correct Answer: C

• Question 33:

  Which statement about the srvctl modify instance command is correct?

  A. For a policy-managed database, this command defines an instance name to use when the database runs on the specified node.

  B. For an administrator-managed database, this command restores the configuration of a database instance

  C. You can use this command to rename or relocate a running instance.

  D. This command is only available with Oracle RAC One Node.

  Correct Answer: A

• Question 34:

  Identify the root cause of Enqueue: CF - Contention in this scenario.

  

  A. Root cause is a stalled LGWR due to LGWR waits Enqueue: CF contention is caused by the db file sequential reads

  B. Root cause is blocked LGWR due to LGWR waits LGWR waits ENQUEUE: CF contention is a symptom of the db file scattered reads and excessive ITL waits

  C. Root cause is a blocked LGWR due to LGWR waits for enqueue: CF - contention, which may be held by another background process. Background process may hold a CF enqueue while updating the control file

  D. Root cause is blocked LGWR due to SCAN_LISTENERS(s) dropping client connections during DoS event

  Correct Answer: C

• Question 35:

  The exhibit describes an Oracle Clusterware startup.

  

  Which item is missing?

  A. ohasd

  B. ocssd

  C. crsd

  D. octssd

  E. osysmond

  F. oraagent

  Correct Answer: A

• Question 36:

  The ACFS volume that contains video data needs a snapshot before a bulk load. Which creates a snapshot?

  A. $ acfsutil snap create snapshot_before_ load/adsmount/ads_vol1

  B. $ acfsutil create snap snapshot_before_load/adsmount/ads_voll

  C. $ acfsutil-c -s snapshot_before_load /adsmount/ads_vol1

  D. $ acfsutil-s -1 snapshot_before_load -v /adsmount/ads_vol1

  Correct Answer: A

• Question 37:

  The Free server pool contains servers that are not assigned to any other server pools. Which two attributes of the free server pool can be edited by the user?

  A. SERVER_NAMES

  B. MIN_SIZE

  C. MAX_ZIZE

  D. IMPORTANCE

  E. ACL

  Correct Answer: DE

• Question 38:

  A customer is using the policy-managed database by name RACDB on a 4-node cluster. The server

  names in the Cluster are: dasher, vixen, comet, and dancer.

  There are two server pools defined, frontoffice and backoffice The attributes are as follows

  Serverpoolmportance MinMax

  Frontoffice 1022

  Backoffice 512

  There are two uniform services being created, crmsrv and hrsrv.

  crmsrv is being assigned to serverpoolfrontoffice and hrsrv is assigned to backoffice.

  Currently, all four nodes are up and running. The database and its services are running as follows:

  The serverpoolfrontoffice , which is running the crmsrv service is being run on the dasher and vixen hosts

  The serverpoolbackoffice, which is running hrsvc service is being run on comet and dancer hosts.

  What happens when the dasher node fails?

  A. Nothing happens because any service relocation is a major interruption to the clients who are connecting to the services.

  B. One of the nodes is moved from the backofficeserverpool to the fronofficeserverpool . This is moved with the consideration or importance and minimum attributes configured. Effectively, the crmsrv service wil run in two nodes and hrsvc will run in one node.

  C. Rebootlescrs cluster stack will be tried in all the duster nodes to resolve the issue. If this is not resolved, all nodes in the cluster get bounced to resolve the issues

  D. Because the crmsrv service is defined as uniform service the cluster ensures at least one node is up and running, which is the current case. So, there will be no service relocation that will happen.

  Correct Answer: A

• Question 39:

  In a clustered Oracle ASM environment, a diskgroup is mounted in restricted mode. Which statement is correct?

  A. You can mount the disk group on all the nodes.

  B. You can issue any command, as long as you are using the force option.

  C. You can open the database located on this disk group only in standalone mode.

  D. You can open the database on this disk group only in restricted mode.

  E. You know that nobody is using the disk group, so you can perform a fast rebalancing on the disk group.

  Correct Answer: E

• Question 40:

  You are tasked with managing an Oracle RAC 12cR1 installation, which is using Oracle Flex Cluster.

  While analyzing the installation you realize that racdbnode2 should be configured as a Leaf node instead

  of a Hub node.

  Which commands must you use to determine the cluster node type (role) of racdbnode2 and change the

  role to Leaf node of the same node?

  A. [GRID]>srvct1 config vip -node racdbnode2[GRID]>crsct1 get node role config#Change to root#u password: XXXX[GRID]>crsct1 config -i node role leaf

  B. [GRID]>srvct1 config vip -node racdbnode2[GRID]>crsct1 get node role config[GRID]>crsct1 set node role leaf[GRID]>crsct1 stop crs[GRID]>crsct1 start crs

  C. [GRID]>srvct1 config vip -node racdbnode2[GRID]>crsct1 get node role config#Change to root#u password: XXXX[GRID]>crsct1 set node role leaf[GRID]>crsct1 stop crs[GRID]>crsct1 start crs

  D. [GRID]>srvct1 set vip -node racdbnode2[GRID]>crsct1 modify node role config#Change to root#u

  password: XXXX

  [GRID]>crsct1 set node role leaf

  [GRID]>crsct1 restart crs

  Correct Answer: C