2024 Valid 1z0-078 Real Exam Questions (Updated) 100% Dumps & Practice Exam [Q35-Q52]

admin 1z0-078 Oracle August 12, 2024

Rate this post

2024 Valid 1z0-078 Real Exam Questions (Updated) 100% Dumps & Practice Exam

[UPDATED 2024] Oracle 1z0-078 Questions Prepare with Free Demo of PDF

Oracle 1z0-078 Exam Syllabus Topics:

Topic	Details
Topic 1	Optional Install for the Grid Infrastructure Management Repository Install a patchset with the Oracle Universal Installer (OUI) utility
Topic 2	Explain the types of patches and upgrades available Explain the hivh availability components of Oracle Clusterware
Topic 3	Explain how global resources are managed Determine RAC-specific wait-events, global enqueues and system statistics
Topic 4	Describe the architecture and components of Flex ASM Monitor ASM instances using the V$ASM dynamic performance views
Topic 5	Configure the RAC database to use ARCHIVELOG mode and the fast recovery area Convert a single instance Oracle database to RAC
Topic 6	Configure client-side connect-time load balancing and failover Convert an Oracle RAC One Node database to a RAC database

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

Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.

All ASM Disks belonging to a disk group should be of the same size for optimal performance.

Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.

All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.

To improve performance a database must have two disk groups; one for data and one for the fast recovery area.

NO.36 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.

NO.37 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.

NO.38 A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.
The COMPATIBLE.ASM, COMPATIBLE.RDBMS, and COMPATIBLE.ADVM parameters are currently set to 11.2 for all diskgroups..
You must support these capabilities in all diskgroups:
1. ACFS Replication
2. ACFS Encryption
To what minimum values must the compatible attributes be set?

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.

Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1

Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.

Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.

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

NO.40 Examine the output of the asmcmd and srvctl commands:

Then you execute this command:
$ srvctl relocate asm -currentnode host03 -targetnode host02
Which three statements are true regarding the execution of this command based on the output shown? (Choose three.)

It fails because the ASM instance has not been shut down first on HOST03.

It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.

It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.

It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.

It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.

It fails because an ASM instance is not configured to run on HOST02.

NO.41 Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 19c RAC? (Choose two.)

A CR image may get served from one instance to another to satisfy a read request.

An xcur image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.

An xcur image is not shipped to another instance until commits occur for updated rows on the block.

A Pi block image may exist for a specific database block in only one instance.

An xcur block image may exist for a specific database block in only one instance.

NO.42 Which three statements are true about accessing ASM files? (Choose three.)

Database instances perform read I/O using an ASM instance as an I/O Server.

Database instances can write metadata to ASM diskgroups.

Database instances perform read I/O directly to ASM Disks.

ASM instances can write metadata to ASM diskgroups.

If a database instance writes to an ASM-based datafile whose redundancy attribute is set to mirror, then the ASM instance writes the mirror copy

NO.43 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.

NO.44 Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 92c Clusterware? (Choose two.)

an application VIP

A Server Pool

a resource dependency definition

an application resource

a script agent

NO.45 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.

NO.46 Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?

When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.

When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.

When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.

When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.

NO.47 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.

NO.48 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

NO.49 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.

NO.50 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.

NO.51 Examine this command executed on the first node of a four-node cluster:
$ < DATABASE_ORACLE_HOME >/OPatch/opatch apply 33575673
What does this command do?

It applies a patch to one oracle home only on the first cluster node.

It applies a patch to one database ORACLE home on alll cluster nodes.

It applies a patch to all database oracle homes with the same release only on the first cluster node.

It applies a patch to all oracle homes with the same release only on the first cluster node.

It applies a patch to all database oracle homes with the same release on all cluster nodes.

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

It is uniformly available on all instances for administrator-managed databases.

It cannot be used to automate the opening of the PDB by the Clusterware.

It is automatically registered in the OCR.

It is created and started on only one instance when using policy-managed database configuration.

It is not automatically registered in the OCR.