Curious about Actual Oracle Database (1Z0-078) Exam Questions?

Here are sample Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration (1Z0-078) Exam questions from real exam. You can get more Oracle Database (1Z0-078) Exam premium practice questions at TestInsights.

Page: 1 /
Total 77 questions

Want more questions? Get Premium Access.

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

A2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT

B2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT

C3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT

D3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE

E3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

Correct : D, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

A2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT

B2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT

C3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT

D3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE

E3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

0 / 1500

Question 2

Which three statements are true about undo management in a RAC environment? (Choose three.)

AYou can dynamically assign a newly created undo tablespace to an instance.

BIn a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.

CAn instance that performs instance recovery can write to the undo tablespace of a failed instance.

DA mixture of automatic undo management and manual undo management is supported within a RAC database.

EIt is necessary to assign a specific undo tablespace to a specific instance.

Correct : A, B, C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AYou can dynamically assign a newly created undo tablespace to an instance.

BIn a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.

CAn instance that performs instance recovery can write to the undo tablespace of a failed instance.

DA mixture of automatic undo management and manual undo management is supported within a RAC database.

EIt is necessary to assign a specific undo tablespace to a specific instance.

0 / 1500

Question 3

Examine this query and output:

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

The SEQ1 sequence is incremented from all instances equally and is frequently used.

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

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

Balter sequence seal cache 10000;

Calter sequence seql noorder;

Dalter sequence seql keep;

Ealter sequence seql order;

Correct : B, C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

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

Balter sequence seal cache 10000;

Calter sequence seql noorder;

Dalter sequence seql keep;

Ealter sequence seql order;

0 / 1500

Question 4

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

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

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

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

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

EIt supports multiple databases assigned to the same server pool.

Correct : B, D, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

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

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

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

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

EIt supports multiple databases assigned to the same server pool.

0 / 1500

Question 5

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

AOnly one GRD shadow resource may exist for an Enqueue Resource.

BShadow GRD resources may exist in more than one database instance for a resource.

CClustered ASM has GRD resources distributed among all ASM instances.

DAll GRD Enqueue Resource master metadata is held in the large pool of the same database instance.

EAll GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.

FRAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.

GRAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.

Correct : B, C, F

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AOnly one GRD shadow resource may exist for an Enqueue Resource.

BShadow GRD resources may exist in more than one database instance for a resource.

CClustered ASM has GRD resources distributed among all ASM instances.

DAll GRD Enqueue Resource master metadata is held in the large pool of the same database instance.

EAll GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.

FRAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.

GRAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.

0 / 1500

Page: 1 / 16
Total 77 questions

Unlock Full
1Z0-078 Exam Features

In Just $49 You can Access

All Official Question Types
Interactive Web-Based Practice Test Software
No Installation or 3rd Party Software Required
Customize your practice sessions (Free Demo)
24/7 Customer Support

Get Full Access Now

Marked Questions
1Z0-078 Exam

1Z0-078 Exam Question 1
1Z0-078 Exam Question 2
1Z0-078 Exam Question 3
1Z0-078 Exam Question 4
1Z0-078 Exam Question 5

Download PDF File Demo

Try Web-Based Exam Practice Software Demo

Commenting

In order to participate in the comments you need to be logged-in.
You can sign-up or login