|
Explanation: By activating the resumable space allocation feature you can correct space quota exceeded error when you exceeded the space that assigned to you in the tablespace. Incorrect Answers: 1: It will not wait indefinitely for the quota to be increased. Only until the timeout value is reached. 2: The statement will not fail: using the resumable space allocation feature the statement will wait in a suspended state until the quota is increased or until the timeout value is reached 4: It will not invoke the default trigger that resets user quota. Reference: OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 47-51 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 25-32 Chapter 1: Oracle9i Database Administration and Management Features
|