Weekend Biggest Discount Flat 70% Offer - Ends in 0d 00h 00m 00s - Coupon code: 70diswrap

DumpsWrap Logo

Oracle 1z0-078 Dumps

Page: 1 / 8
Total 77 questions
Get 1z0-078 Full Access Download 1z0-078 PDF

Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Questions and Answers

Question 1

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

Options:

A.

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

B.

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

C.

It is automatically registered in the OCR.

D.

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

E.

It is not automatically registered in the OCR.

Question 2

Which statement describes the purpose ofcolocation_tagfor client routing with Oracle database 19c?

Options:

A.

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

B.

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

C.

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

D.

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

Question 3

Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

Options:

A.

Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

B.

Global Enqueues may have converters and waiters in the same instance.

C.

Global Enqueues may have owners and waiters in the same instance.

D.

Global Enqueues and Instance Locks replace latches completely in RAC database instances.

E.

In a RAC database, there is no LMDO process if only one instance is running.

F.

In a RAC One Node database, there is no LMD) process if only one instance is running.

Question 4

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

Options:

A.

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

B.

You must enable the Name Server Cache Daemon

C.

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

D.

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

E.

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

F.

You must create a Grid Management Repository database.

Question 5

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 Poolprod.

4. ERP is a policy managed, singleton service using Server Poolprod.

5. Grid infrastructure is installed and running in its default configuration.

Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

Options:

A.

High availability for the CRM service

B.

Load balancing of connection requests across all six database instances

C.

High availability for the ERP service

D.

Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners

E.

Load balancing of connection requests for ERP across all database instances running on servers in the prod pool

F.

Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners

G.

Load balancing of connection requests for CRM across all database instances running on servers in the prod pool

Question 6

Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c.

All databases have one or more services defined.

The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.

The Oracle 11g Release 2, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN).

You must change the public VIPs.

Which three actions must be performed to change the VIPs onhost01, the first node in the cluster? (Choose three.)

Options:

A.

Use srvctl start vip to start the VIP on host01.

B.

Use oifcfg setif to start the VIP on host01.

C.

Use oifcfg setif to stop the VIP on host01.

D.

Use srvctl modify nodeapps to change the VIP on host01.

E.

Use srvctl stop vip to stop the VIP on host01.

Question 7

Examine this query and output:

as

Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.

TheSEQ1sequence is incremented from all instances equally and is frequently used.

Which two statements should you execute to reduce SQ enqueue contention? (Choose two.)

Options:

A.

exec sys.dbms shared pool.keep('SEQ1','Q'>

B.

alter sequence seal cache 10000;

C.

alter sequence seql noorder;

D.

alter sequence seql keep;

E.

alter sequence seql order;

Question 8

Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)

Options:

A.

Replication is automatically terminated if the primary file system has less than 2 GB free space.

B.

ACFS auditing information is replicated from the primary file system to the standby file system.

C.

Standby redo log files are required on the standby site for synchronous redo transport.

D.

The privilege sysrepl has been introduced for ACFS replication.

E.

One site of an ACFS replication configuration can host both primary and standby file systems.

Question 9

Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)

Options:

A.

Use the crsct1 set trace res "resource_name=debugging_level" command.

B.

Use the crsct1 set log res "resource_name=debugging_level2" command.

C.

Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.

D.

Use the cluvfy comp command for the specific resource within a component.

Question 10

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?

Options:

A.

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.

B.

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.

C.

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.

D.

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.

E.

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.

Question 11

Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)

Options:

A.

Services support the balancing of client connections across RAC database instances.

B.

In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.

C.

Load balancing can be done by the client or the listener, but not both, for any one connection request.

D.

Client-side connect-time load balancing can balance connection requests across SCAN listeners.

E.

Load balancing can be done by the client, the listener, or both, for any one connection request.

Question 12

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

Options:

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.

Question 13

Which two statements are true aboutv$asm-views in a clustered environment? (Choose two.)

Options:

A.

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

B.

Their names can be seen inv$fixed_tablewhen connected to an instance of any type that is started.

C.

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

D.

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

E.

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

Question 14

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

Options:

A.

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.

B.

Transparent Application Continuity is enabled when failover type=auto.

C.

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.

D.

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

E.

Transparent Application Continuity is enabled when failover type=All

Question 15

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

Options:

A.

An administrator-managed resource can be started manually using srvct1.

B.

A policy-managed resource can be started manually using crsct1.

C.

An administrator-managed resource can be started manually using crsct1.

D.

The action script is automatically set when using a policy-managed resource.

E.

A policy-managed resource can be started manually using srvct1.

F.

Resource dependencies are automatically set when using a policy-managed resource.

Question 16

Examine the output of theasmcmdandsrvctlcommands:

as

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

Question 17

A Java application using thickJDBCconnections 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?

Options:

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)

Question 18

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

Options:

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.

Question 19

Examine this command:

as

Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)

Options:

A.

Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.

B.

It can contain ASM Dynamic Volume Manager (ADVM) volumes.

C.

Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.

D.

The ASM compatible attributes can be changed to 12. l for this disk group.

E.

Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.

Question 20

Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)

Options:

A.

Database block buffers

B.

Mutexes

C.

Redo log buffers

D.

Latches

E.

Enqueues

F.

Cursors

Question 21

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

Options:

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

Question 22

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

Options:

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.

Question 23

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

Options:

A.

an application VIP

B.

A Server Pool

C.

a resource dependency definition

D.

an application resource

E.

a script agent

Load More 1z0-078 Questions
Page: 1 / 8
Total 77 questions
Get 1z0-078 Full Access Download 1z0-078 PDF