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

701. A user receives the following error while performing 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 than

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 

答案解析：

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

根據官方文檔，此題選A

[oracle@rtest ~]$ oerr ora 1536

01536, 00000, "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 a

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