Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration - 1z1-078 Exam Practice Test

A. All the instances must have the same number of redo log groups and each group must have the same number of redo log members. B. A redo log group added using alter database add logfile without the instance clause is added to each instance. C. A thread of redo must contain at least two log groups before it can be enabled. D. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL. E. A thread of redo must be created before starting a fourth instance if a thread is not already available.

A. Hub nodes require direct access to the voting disks. B. Leaf nodes require direct access to the voting disks. C. Each leaf node must be connected to storage shared across all cluster nodes. D. Hub nodes require direct access to the OCR file. E. Each hub node must be connected to storage shared across all hub nodes. F. Each leaf node must be connected to storage shared across all leaf nodes.

A. The upgrade must be done in-place. B. The upgrade must be done out-of-place. C. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility. D. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment. E. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment. F. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster. G. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.

A. They listen only for the ASM instance on the same node. B. They listen on behalf of any ASM instance and all database instances on the same node. C. They run from the Grid Infrastructure home by default. D. They listen only for database instances on the same node. E. There can be only one node listener per node.

A. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster. B. Their names can be seen in dice when connected to an ASM instance. C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started. D. They exist in both ASM and RDBMS instances, and display the same output. E. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.

A. The source PD3 must be closed on the CDS instance from where the command is executed. B. All running CDB instances must be open in restricted mode. C. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode. D. The source pdb must use a global temporary E. It can be executed only by a common user with the create pluggable database system privilege connected to the root container. F. Oracle Managed Files must be enabled or PD3 file name convert must be set.

A. A database instance on a node can only be a client of an ASM instance running on the same node. B. An ASM instance and database instances can coexist on the same node. C. ASM Cluster File System (ACFS) can be deployed on any nodes. D. A database instance on a node can be a client of an ASM instance running on any node. E. A database instance on a node cannot be a client of an ASM instance running on other nodes. F. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.

A. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced. B. The ASM_DISKGOUPS parameter is optional. C. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect. D. The maximum value of ASM_POWER_LIMIT is 1024. E. The default value of INSTANCE_TYPE is ASM.