CertsTopics Logo

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

Full Access Oracle 1z0-078 Tutorials

Page: 5 / 6
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 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.

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