[Mar 15, 2024] Pass Oracle Database 1z1-078 Exam With 79 Questions [Q38-Q54]

NO.38 Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)

NO.39 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.)

NO.40 Zero Downtime Patching uses Fleet Patching and Provisioning to patch Oracle Grid Infrastructure without bringing down Oracle RAC database instances.
Which three statements are true about Zero-Downtime Oracle Grid Infrastructure Patching? (Choose three.)

NO.41 Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)

NO.42 Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

NO.43 Which two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.)

NO.44 Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?

NO.45 Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)

NO.46 Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)

NO.47 Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)

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

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

NO.50 You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)

NO.51 You support a RAC database with these characteristics:
1. There are six instances.
2. Server Pool prod has a maximum of four servers.
3. CRM is a policy managed, uniform service using Server Pool prod.
4. ERP is a policy managed, singleton service using Server Pool prod.
5. Grid infrastructure is installed and running in its default configuration.
Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

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

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

NO.54 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.)