Which two methods would you use to resolve this error?

The hr user receiver, the following error while inserting data into the sales table: ERROR at
line 1: ORA-01653; unable to extend table HR.SALES by 128 in tablespace USERS On
investigation, you find that the users tablespace uses Automnrif 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 receiver, the following error while inserting data into the sales table: ERROR at
line 1: ORA-01653; unable to extend table HR.SALES by 128 in tablespace USERS On
investigation, you find that the users tablespace uses Automnrif 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.
Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter
to a nonzero value

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

C.
Altering the data life associated with the USERS tablespace to ex automatically

D.
Adding a data life to the USERS tablespace

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

Explanation:



Leave a Reply 8

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


agwa umoh

agwa umoh

B and C to me

Hvd

Hvd

C and D. B not, because the HR.SALES table will still be in the USERS tablespace.

yo

yo

C and D , i agree with Hvd

Ricky

Ricky

I Passed the exam IZO-062exam today with a score of 83%

Thanks!

Best Regards,
Ricky
[email protected]