Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration

QUESTION NO: 1
Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

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

Correct Answer: A,B,C

QUESTION NO: 2
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

A. Global Enqueues may have converters and waiters in the same instance. B. In a RAC database, there is no LMDO process if only one instance is running. C. In a RAC One Node database, there is no LMD) process if only one instance is running. D. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances. E. Global Enqueues and Instance Locks replace latches completely in RAC database instances. F. Global Enqueues may have owners and waiters in the same instance.

Correct Answer: B,F

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

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

Correct Answer: B,C

QUESTION NO: 4
Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true? (Choose two.)

A. The service must be manually restarted with SRVCTL every time the instance hosting the service fails. B. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service. C. Clusterware will monitor the service while it is active. D. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service. E. When manually started, the service will always start on one or more available instances rather than on their preferred instances.

Correct Answer: C,D

QUESTION NO: 5
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)

A. An ADVM volume is individually named and can contain only one file system. B. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group. C. Only one ADVM volume can be created in an ASM disk group. D. File systems contained in ADVM volumes may only contain database files. E. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.

Correct Answer: A,B

QUESTION NO: 6
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)

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

Correct Answer: B,D

QUESTION NO: 7
Examine this command:

Which two statements are required for this command to succeed? (Choose two.)

A. The +DATA disk group should not be part of Flex ASM. B. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate). C. newtemplate must be defined for the +DATA disk group. D. Existing data files in TBS1 must also use the same template. E. User-defined subdirectories ORCL and USERS must already exist.

Correct Answer: C,E

QUESTION NO: 8
You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)

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 be created before starting a fourth instance if a thread is not already available. D. A thread of redo must contain at least two log groups before it can be enabled. E. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.

Correct Answer: C,D

Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration - 1z0-078 Exam Questions