OCP-1Z0-053-V13.02-701

701. A user defined es the following error while loading Ming a large volume of inserts into a table:

 

The issue is resolved by increasing the space quota on the USERS tablespace for the user. But the user

May perform such transaction in the future. You w ant to ensure that the command waits rather

Produce an error when such an event occurs the next time.

What can you do to achieve this before running the command in the future?

A. Set RESUMABLE_TIMEOUT for the instance.

B. Set the RESOURCE_LIMIT Parameter to TRUE.

C. Enable the database instance to use asynchronous commit.

D. Set the LOG_CHECKPOINT_TIMEOUT parameter to a nonzero value for the database instance.

Answer: C

Answer:

Reference: http://docs.oracle.com/cd/E11882_01/server.112/e25494/schema.htm#ADMIN11584

Select A according to the official document.

[Oracle @ rtest ~] $ Oerr ora 1, 1536

01536,000 00, "space quota exceeded for tablespace '% S '"

// * Cause: The space quota for the segment owner in the tablespace has

// Been exhausted and the operation attempted the creation of

// New segment extent in the tablespace.

// * Action: Either drop unnecessary objects in the tablespace to reclaim

// Space or have a privileged user increase the quota on this

// Tablespace for the segment owner.

How Resumable Space Allocation Works

The following is an overview of how resumable space allocation works. Details are contained in later sections.