Pass Your Exam With 100% Verified 1z0-078 Exam Questions [Q29-Q48]

Rate this post

Pass Your Exam With 100% Verified 1z0-078 Exam Questions

1z0-078 Dumps PDF – 1z0-078 Real Exam Questions Answers

Oracle 1z0-078 Exam Syllabus Topics:

Topic	Details
Topic 1	Configure client-side connect-time load balancing and failover Convert an Oracle RAC One Node database to a RAC database
Topic 2	Explain the types of patches and upgrades available Explain the hivh availability components of Oracle Clusterware
Topic 3	Describe the multitenant architecture in RAC and non-RAC environments Use Automatic Database Diagnostic Monitor (ADDM) in RAC
Topic 4	Explain global enqueue and instance lock management Explain the benefits of Fast Application Notification (FAN)
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	Optional Install for the Grid Infrastructure Management Repository Install a patchset with the Oracle Universal Installer (OUI) utility
Topic 7	Configure server-side connect-time load balancing Use DBCA to convert a single-instance database to a RAC One Node database

NO.29 A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.
Broken connections must be re-established as quickly as possible.
Which feature will support this requirement?

Transparent Application Failover (TAF) using Fast Application Notification (FAN)

Transparent Application Failover (TAF)

Fast Connection Failover (FCF)

Fast Connection Failover (FCF) with Transparent Application Failover (TAF)

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

Different nodes in a cluster may belong to separate administrator-defined categories.

All nodes in a cluster belong to the same Oracle-supplied category.

A server may be added to only one category using the crsctl utility.

All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.

All server attributes used for categorization are administrator modifiable.

Server categories can only be used for nodes running an application server.

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

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

NO.33 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.34 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.35 Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)

An ADVM volume is individually named and can contain only one file system.

ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.

File systems contained in ADVM volumes may only contain database files.

Only one ADVM volume can be created in an ASM disk group.

To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.

NO.36 Which three statements are true about fully qualified file names in ASM? (Choose three.)

They can be created only if OMF is enabled.

They are system Generated at the time of ASM file creation.

They can be used to reference existing ASM files.

They are the only valid form that can be used for single file creation of a control file.

An alias may be created for an existing file by referring to the fully qualified file name.

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

NO.38 Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)

The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.

The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.

The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner’s environment.

The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner’s environment.

The upgrade must be done in-place.

Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.

The upgrade must be done out-of-place.

NO.39 Secure Cluster Communication protects the cluster interconnect from common security threats when used together with Single Network Support. Secure Cluster Communication includes message digest mechanisms, protection against fuzzing, and uses Transport Layer Security (TLS) to provide privacy and data integrity between the cluster members.
Which statement is true about securing cluster interconnect communication?

Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c and Database administrators or cluster administrators do not need to make any configuration changes for this feature.

Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c using an auto-generated encryption key that is stored locally on each node of the cluster in an Oracle Wallet and Database administrators or cluster administrators must provide a valid path for the Wallet file.

Security for the cluster interconnect is invoked by auto-generated server certificates that will be assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c.

Database administrators or cluster administrators must provide an encryption key during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.

Database administrators or cluster administrators must provide a valid server certificate and an Oracle Wallet for each node during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.

NO.40 Which three statements are true about fully qualified file names in ASM? (Choose three.)

They can be created only if OMF is enabled.

They are system Generated at the time of ASM file creation.

They can be used to reference existing ASM files.

They are the only valid form that can be used for single file creation of a control file.

An alias may be created for an existing file by referring to the fully qualified file name.

NO.41 Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)

an 0/S user to own the Oracle Database installation

an O/S group called dba

an O/S user to own the Grid Infrastructure installation

an O/S group to own the software inventory

A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage

an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation

NO.42 For which three entities can the “what-if” command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)

Cluster resources

Database transactions

Local resources

Administrator-defined resources

Pluggable Databases (PDBs)

NO.43 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.44 Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)

The Grid Infrastructure Management Repository is only required when using ASM.

Specifying the use of Grid Naming Service is optional.

Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of

The Clusterware binaries may be installed without installing ASM binaries.

High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.

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

Zero Downtime Patching requires out-of-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.

When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.

When using Zero Downtime Patching, Oracle Grid Infrastructure OS system software, kernel modules and system commands including ACFS, AFD, OLFS, and OKA are not updated.

Zero Downtime Patching requires in-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.

Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.

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

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