Oracle Exam 1Z0-084 Topic 3 Question 16 Discussion

Actual exam question for Oracle's 1Z0-084 exam

Question #: 16
Topic #: 3

[All 1Z0-084 Questions]

Examine this code block, which executes successfully:

DBMS_SERVER_ALERT. SET_THRESHOLD (

DBMS_SERVER_ALERT.CPU_TIME_PER_CALL, DBMS_SERVER_ALERT. OPERATOR_GE, '8000',

DBMS_SERVER_ALERT.OPERATOR_GE, '10000', 1, 2, 'inst1',

DBMS_SERVER_ALERT.OBJECT_TYPE_SERVICE, 'main.regress.rdbms.dev.us.example.com') ;

What will happen?

AA warning alert will be issued when CPU time exceeds 1 minute for each user call.

BA critical alert will be issued when CPU time exceeds 10000 microseconds for each user call.

CA warning alert will be issued only when CPU time exceeds 10000 microseconds for each user call.

DA critical alert will be issued when CPU time exceeds 2 minutes for each user call.

Show Suggested Answer

Suggested Answer: A, E

Regarding space usage in temporary tablespaces, the following statements are true:

A (Correct): When a global temporary table or a sort operation exceeds the available memory, Oracle Database allocates space in a temporary tablespace to store the temporary data or intermediate results.

E (Correct): Using temporary tablespace groups can prevent insufficient temporary tablespace for sort operations by providing a collective pool of space from multiple temporary tablespaces, which can be used for user sorting operations.

The other options provided have inaccuracies:

B (Incorrect): Oracle does not provide a mechanism for setting quotas on temporary tablespaces. Quotas can be set for permanent tablespaces but not for temporary ones.

C (Incorrect): A sort operation may fail due to insufficient space, but Oracle will attempt to allocate space in the temporary tablespace dynamically. If no space can be allocated, an error is returned rather than a sort failure.

D (Incorrect): If a session consumes all available temporary tablespace storage, Oracle will not hang the session; it will return an error to the session indicating that it has run out of temporary space.

Oracle Database Administrator's Guide: Managing Space for Schema Objects

Oracle Database Concepts: Temporary Tablespaces

by Deangelo at Aug 07, 2024, 02:08 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-084 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

1 months ago

Hmm, I'm going with C. The code seems to indicate that a warning alert will be issued only when the CPU time exceeds 10000 microseconds, not 8000 microseconds.

upvoted 0 times

Shawna

1 days ago

User1: I think it's B. The code specifies a critical alert when CPU time exceeds 10000 microseconds.

upvoted 0 times

...

2 months ago

I think the correct answer is B.

upvoted 0 times

...