Oracle 1z1-078 Real Exam Questions and Answers FREE [Q17-Q36]

4.7/5 - (3 votes)

Oracle 1z1-078 Real Exam Questions and Answers FREE

Exam Dumps 1z1-078 Practice Free Latest Oracle Practice Tests

Oracle 1z1-078 Exam Syllabus Topics:

Topic	Details
Topic 1	Perform ongoing maintenance tasks on ASM disk groups Explain how ASM files, directories and aliases are created and managed
Topic 2	Explain global enqueue and instance lock management Explain the benefits of Fast Application Notification (FAN)
Topic 3	Explain use of Affinity to reduce Global Resource Contention Define undo tablespaces in a RAC environment
Topic 4	Describe the multitenant architecture in RAC and non-RAC environments Use Automatic Database Diagnostic Monitor (ADDM) in RAC
Topic 5	Optional Install for the Grid Infrastructure Management Repository Install a patchset with the Oracle Universal Installer (OUI) utility
Topic 6	Configure the RAC database to use ARCHIVELOG mode and the fast recovery area Convert a single instance Oracle database to RAC
Topic 7	Describe the architecture and components of Flex ASM Monitor ASM instances using the V$ASM dynamic performance views

NEW QUESTION 17
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)

If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.

ASM disk groups used for voting files and OCR files require a quorum failqroup.

The Installer permits the creation of a disk group for use by the voting disks and OCR file.

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

The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.

The service must be manually restarted with SRVCTL every time the instance hosting the service fails.

The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.

Clusterware will monitor the service while it is active.

When manually started, the service will always start on one or more available instances rather than on their preferred instances.

NEW QUESTION 19
Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)

An application VIP is created on the default network by the appvipcfg utility.

Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.

If an application sends messages to be displayed and sets the display variable, then an application VIP is required.

An application VIP can be created with the crsccl utility.

An application VIP is created on the interconnect network by the crsccl utility.

NEW QUESTION 20
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)

All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.

Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.

A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.

A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.

Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.

NEW QUESTION 21
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?

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

2, 3, 4 and 6.

1, 2, 3 and 4.

2, 3, 4, 5 and 6.

1, 2, 3, 4 and 6.

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

NEW QUESTION 22
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 thread of redo must be created before starting a fourth instance if a thread is not already available.

A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.

All the instances must have the same number of redo log groups and each group must have the same number of redo log members.

A redo log group added using alter database add logfile without the instance clause is added to each instance.

A thread of redo must contain at least two log groups before it can be enabled.

NEW QUESTION 23
Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)

New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-

The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.

New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

Transactions on database objects stored in tablespaces in the dgrpi disk group fail.

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

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

You must enable the Name Server Cache Daemon

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

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

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

You must create a Grid Management Repository database.

NEW QUESTION 25
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.)

The ACFS file system will be permanently removed from the volume.

The ACFS mount registry with Oracle restart is automatically deleted.

The disabling of volume does not destroy data in the file system.

The volume can be enabled and the file system can be mounted back again to access the existing data.

The ACFS file system will be permanently removed from the volume only if the file system is empty.

NEW QUESTION 26
Which statement is true about Oracle Database 19c SGA Management?

Oracle RAC Resource Management only allows assignment of the SGA during instance startup.

Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.

Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.

Oracle RAC Resource Management only allows assignment of the SGA during database startup.

NEW QUESTION 27
Examine the output of this command:

The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command? (Choose two.)

It fails to resize voli because it must be executed as a user belonging to the sysasm group.

It fails to resize the filesystem because it must be unmounted before resizing.

It succeeds but leaves the file system unmounted.

It resizes voli.

It resizes the filesystem mounted on /u01/app/grid/acfsmount.

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

They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.

Their names can be seen in v$fixed_table when connected to an instance of any type that is started.

Their names can be seen in dice when connected to an ASM instance.

gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.

They exist in both ASM and RDBMS instances, and display the same output.

NEW QUESTION 29
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)

ASM Cluster File System (ACFS) can be deployed on any nodes.

A database instance on a node can be a client of an ASM instance running on any node.

A database instance on a node cannot be a client of an ASM instance running on other nodes.

A database instance on a node can only be a client of an ASM instance running on the same node.

A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.

An ASM instance and database instances can coexist on the same node.

NEW QUESTION 30
Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)

Each hub node must be connected to storage shared across all hub nodes.

Each leaf node must be connected to storage shared across all cluster nodes.

Each leaf node must be connected to storage shared across all leaf nodes.

Leaf nodes require direct access to the voting disks.

Hub nodes require direct access to the OCR file.

Hub nodes require direct access to the voting disks.

NEW QUESTION 31
Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)

Transparent Application Continuity is automatically enabled for a session when a database session reaches a safe place (such as a connection test or a known recoverable point) and the transactions are drained at the database.

Transparent Application Continuity is enabled when failover type=auto.

Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes.

Recovery of the user database session is done safely by enabling auto recover within the user database session.

Transparent Application Continuity is enabled when failover type=All

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

The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor

The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.

There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.

There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

NEW QUESTION 33
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)

One undo tablespace for each pdb is required.

PDBs can have local temporary

You can open one, several, or all PD3s on one, several, or all cdb instances.

It requires the cdb to use shared undo management.

One undo tablespace for each instance is required.

PDBs must use shared Temporary

NEW QUESTION 34
Which three statements are true about undo management in a RAC environment? (Choose three.)

You can dynamically assign a newly created undo tablespace to an instance.

In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.

An instance that performs instance recovery can write to the undo tablespace of a failed instance.

A mixture of automatic undo management and manual undo management is supported within a RAC database.

It is necessary to assign a specific undo tablespace to a specific instance.

NEW QUESTION 35
Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?

Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.

Dynamic Service Fallback allows a service to fall back to a preferred instance when the available instance performance falls below a specified threshold after it was failed over to an available instance.

To enable Dynamic Service Fallback, you should specify the level of performance of a preferred instance for a service to be relocated to an available instance by setting the -fallback attribute of a service to “Low, Medium, or High”.

Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance.

NEW QUESTION 36
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)

ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.

Grid Infrastructure must be installed on all cluster nodes.

The Clusterware stack must be up on all cluster nodes.

The Clusterware stack must be up on all cluster nodes where the Database software will be installed.

SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.

Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.

Verified 1z1-078 Exam Dumps Q&As – Provide 1z1-078 with Correct Answers: https://www.testbraindump.com/1z1-078-exam-prep.html

Oracle 1z1-078 Real Exam Questions and Answers FREE [Q17-Q36]

Oracle 1z1-078 Exam Syllabus Topics:

Updated Apr-2026 Pass 1Z0-1133-24 Exam – Real Practice Test Questions [Q10-Q31]

2022 Latest 1Z0-1037-21 Exam Dumps Recently Updated 72 Questions [Q36-Q54]

[Jun-2022] Oracle 1Z1-888 DUMPS WITH REAL EXAM QUESTIONS [Q63-Q86]

Leave a Reply Cancel reply

Oracle 1z1-078 Exam Syllabus Topics:

Related Posts

Leave a Reply Cancel reply