Which two methods would you use to resolve this error?

The HR user receives the following error while inserting data into the sales table:

On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is
the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error?

The HR user receives the following error while inserting data into the sales table:

On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is
the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error?

A.
Altering the data file associated with the USERS tablespace to ex automatically

B.
Adding a data file to the USERS tablespace

C.
Changing segment space management for the USERS tablespace to manual

D.
Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to
the new tablespace

E.
Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Richard

Richard

The correct answer should be A and B.