1z0-078 by Oracle Actual Free Exam Q&As

Question 1

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?

A. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
B. Transparent Application Failover (TAF)
C. Fast Connection Failover (FCF)
D. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)

Answer : C

Question 2

Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)

A. Only one GRD shadow resource may exist for an Enqueue Resource.
B. Shadow GRD resources may exist in more than one database instance for a resource.
C. Clustered ASM has GRD resources distributed among all ASM instances.
D. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
E. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
F. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
G. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.

Answer : BCF

Question 3

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

A. Client-side connect time load balancing works only if it uses a tnsnames entry specifying LOAD_BALANCE=yes.
B. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
C. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
D. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
E. In client-side load balancing, the SCAN listener uses the Load Balancing Advisory to direct a connection request to the least loaded instance hosting the service.

Answer : BD

Question 4

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

A. A CR image may get served from one instance to another to satisfy a read request.
B. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
C. An XCUR image is not shipped to another instance until commits occur for updated rows on the block.
D. A PI block image may exist for a specific database block in only one instance.
E. An XCUR block image may exist for a specific database block in only one instance.

Answer : AE

Question 5

Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)

A. An ADVM volume is individually named and can contain only one file system.
B. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
C. File systems contained in ADVM volumes may only contain database files.
D. Only one ADVM volume can be created in an ASM disk group.
E. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.

Answer : AB

Question 6

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

A. It can analyze performance over any given time period.
B. It can diagnose skew in response time.
C. It can analyze performance using data captured on all instances.
D. It can only analyze performance on the instance running the ADDM job.
E. It can diagnose latency problems in the Cluster Interconnect.
F. It runs automatically in Instance ADDM mode after each AWR snapshot is created.

Answer : ABC

Question 7

Which two statements are true about High Availability NFS (HANFS)? (Choose two.)

A. HANFS provides high availability in case of an NFS client failure.
B. HANFS' performance depends on the characteristics of the underlying ASM disks.
C. HANFS does not depend on NFS services provided by the underlying operating system.
D. HANFS provides high availability in case of cluster node failure.
E. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS filesystem.

Answer : BD

Question 8

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

A. They can be created only if OMF is enabled.
B. They are system generated at the time of ASM file creation.
C. They can be used to reference existing ASM files.
D. They are the only valid form that can be used for single file creation of a control file.
E. An alias may be created for an existing file by referring to the fully qualified file name.

Answer : BCE

Question 9

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

A. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
B. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
C. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
D. Clusterware will monitor the service while it is active.
E. When manually started, the service will always start on one or more available instances rather than on their preferred instances.

Answer : AD

Question 10

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

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

Answer : BC

Question 11

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

A. an application VIP
B. A Server Pool
C. a resource dependency definition
D. an application resource
E. a script agent

Answer : DE

Question 12

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

A. ASM Cluster File System (ACFS) can be deployed on any nodes.
B. A database instance on a node can be a client of an ASM instance running on any node.
C. A database instance on a node cannot be a client of an ASM instance running on other nodes.
D. A database instance on a node can only be a client of an ASM instance running on the same node.
E. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgoups.
F. An ASM instance and database instances can coexist on the same node.

Answer : BEF

Question 13

Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)

A. They listen only for database instances on the same node.
B. They listen on behalf of any ASM instance and all database instances on the same node.
C. They listen only for the ASM instance on the same node.
D. There can be only one node listener per node.
E. They run from the Grid Infrastructure home by default.

Answer : BE

Question 14

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?

A. 1, 2, 3, 4, 5 and 6.
B. 2, 3, 4 and 6.
C. 1, 2, 3 and 4.
D. 2, 3, 4, 5 and 6.
E. 1, 2, 3, 4 and 6.
F. 1, 2, 3, 4, 5, 6 and 7.