Online Access Free 1z1-078 Practice Test

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

Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)

• A.Specifying the use of Grid Naming Service is optional.
• B.The Grid Infrastructure Management Repository is only required when using ASM.
• C.Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
• D.High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
• E.The Clusterware binaries may be installed without installing ASM binaries.

Examine this command and output:

Examine this command:

Which statement must be true for the successful execution of the second command?

• A.The parent snapshot must be read/write.
• B.The disk group compatibility attribute for advm must be set to 12. l or higher.
• C.The underlying advm volume must be configured with high redundancy.
• D.The parent snapshot must be read-only.

Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c.
All databases have one or more services defined.
The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.
The Oracle 11g Release 2, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPs.
Which three actions must be performed to change the VIPs on host01, the first node in the cluster? (Choose three.)

• A.Use srvctl modify nodeapps to change the VIP on host01.
• B.Use oifcfg setif to start the VIP on host01.
• C.Use srvctl start vip to start the VIP on host01.
• D.Use srvctl stop vip to stop the VIP on host01.
• E.Use oifcfg setif to stop the VIP on host01.

Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

• A.Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
• B.All ASM Disks belonging to a disk group should be of the same size for optimal performance.
• C.Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
• D.All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
• E.To improve performance a database must have two disk groups; one for data and one for the fast recovery area.