Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Oracle 1z0-078 Dumps

Page: 1 / 6
Total 77 questions

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

Question 1

Examine these descriptions of ASM instance shutdown behavior:

1) The ASM instance shuts down immediately without an orderly dismount of disk groups.

2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.

3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.

Which two lists are correct matches for these descriptions? (Choose two.)

Options:

A.

2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT

B.

2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT

C.

3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT

D.

3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE

E.

3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

Question 2

Examine this command:

SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;

Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

Options:

A.

The source PD3 must be closed on the CDS instance from where the command is executed.

B.

The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.

C.

The source pdb must use a global temporary

D.

It can be executed only by a common user with the create pluggable database system privilege connected to the root container.

E.

Oracle Managed Files must be enabled or PD3 file name convert must be set.

F.

All running CDB instances must be open in restricted mode.

Question 3

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

Options:

A.

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

B.

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.

C.

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

D.

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.

Question 4

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 5

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

Options:

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

Question 6

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

The upgrade must be done in-place.

F.

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

G.

The upgrade must be done out-of-place.

Question 7

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

Options:

A.

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

B.

Grid Infrastructure must be installed on all cluster nodes.

C.

The Clusterware stack must be up on all cluster nodes.

D.

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

E.

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

F.

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

Question 8

Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

Options:

A.

It can manage database services only if they are defined as UNIFORM services.

B.

It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.

C.

A server pool can be managed by QoS even if it does have database instances running on any server in the pool.

D.

Databases managed by QoS can be administrator managed or policy managed.

E.

It supports multiple databases assigned to the same server pool.

Question 9

Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 19c? (Choose two.)

Options:

A.

If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.

B.

Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.

C.

If network time protocol (NJP) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.

D.

Configure network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.

E.

Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started.

Question 10

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

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

Which two statements are true regarding the actions performed? (Choose two.)

Options:

A.

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

B.

The ACFS mount registry with Oracle restart is automatically deleted.

C.

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

D.

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

E.

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

Question 14

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 15

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 16

Examine this command:

Which two statements are required for this command to succeed? (Choose two.)

Options:

A.

The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

B.

newtemplate must be defined for the +DATA disk group.

C.

Existing data files in TBS1 must also use the same template.

D.

User-defined subdirectories ORCL and USERS must already exist.

E.

The +DATA disk group should not be part of Flex ASM.

Question 17

You want to create a tablespace,SALES, with these requirements:

1. Its data file has an alias namesales.dbf.

2. Its data file is stored in the directoryCURRENT_YRin the disk groupDATA.

Examine this command:

SQL> CREATE TABLESPACE sales;

Which two tasks must you perform to meet these requirements? (Choose two.)

Options:

A.

Create the current yr directory in the root directory (+).

B.

Create the current yr directory in the +data disk group.

C.

Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.

D.

Add the autoextend on clause to the command.

E.

lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.

Question 18

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 19

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

All server attributes used for categorization are administrator modifiable.

F.

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

Question 20

Examine this command and output:

Examine this command:

Which statement must be true for the successful execution of the second command?

Options:

A.

The disk group compatibility attribute for advm must be set to 12. l or higher.

B.

The parent snapshot must be read-only.

C.

The underlying advm volume must be configured with high redundancy.

D.

The parent snapshot must be read/write.

Question 21

Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?

Options:

A.

They can be applied in-place.

B.

When performing rolling patches, the vips for the node being patched are relocated to another node.

C.

Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.

D.

When performing rolling patches,crsctl query crs softwareversionalways displays the earliest version of the software running anywhere in the cluster.

Question 22

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

Options:

A.

A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.

B.

An ACFS snapshot can be ACFS encrypted.

C.

acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.

D.

acfsucil encr on can be used to specify the encryption key length for a directory or file.

E.

acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.

Question 23

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?

Options:

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.

Page: 1 / 6
Total 77 questions