1z0-078問題集、Oracle実際の試験問題

質問 1

Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). (Choose three.)

A. Each cluster node must have at least two network interface cards.

B. You must create a Grid Management Repository database.

C. A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.

D. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.

E. A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.

F. You must enable the Name Server Cache Daemon

正解: D,E,F

質問 2

Which two steps must always be performed to delete node host04 from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)? (Choose two.)

A. Run the crsctl delete node -n host04 command as root on host04.

B. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.

C. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.

D. Run the crsct1 unpin css - host04 command as root on host04.

E. Run the rootcrs.pl -deconfig -force command as root on host04.

F. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.

正解: B,E

質問 3

Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)

A. It cannot be used to automate the opening of the PDB by the Clusterware.

B. It is uniformly available on all instances for administrator-managed databases.

C. It is not automatically registered in the OCR.

D. It is automatically registered in the OCR.

E. It is created and started on only one instance when using policy-managed database configuration.

正解: B,D

質問 4

Examine these descriptions of ASM instance shutdown behavior:
1) The ASM instance shuts down immediately without an orderly dismount of disk groups.
2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
Which two lists are correct matches for these descriptions? (Choose two.)

A. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

B. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE

C. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT

D. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT

E. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT

正解: A,B

質問 5

You must deploy several Oracle 19c 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 seven requirements are met by your plan?

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

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

C. 2, 3, 4 and 6.

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

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

F. 1, 2, 3 and 4.

正解: F

質問 6

Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)

A. When a policy is first created, it is initially active.

B. An administrator-defined policy may be activated using the srvctl utility.

C. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.

D. When a policy is activated, resources cannot be automatically started to comply with the policy definition.

E. When a policy is activated, resources can be automatically stopped to comply with the policy definition.

F. When a policy is first created, it is initially inactive.

正解: B,E,F

質問 7

Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)

A. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.

B. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.

C. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.

D. The CLUVFY utility can check the integrity of the OCR but not the OLR.

E. The OCRCONFIG utilty can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.

正解: A,B,C

質問 8

Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)

A. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.

B. The default value of INSTANCE_TYPE is ASM.

C. The ASM_DISKGOUPS parameter is optional.

D. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.

E. The maximum value of ASM_POWER_LIMIT is 1024.

正解: B,C

Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration - 1z0-078 模擬練習