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:
D
c,d
B, D.
B,D
B and C to me
C and D. B not, because the HR.SALES table will still be in the USERS tablespace.
C and D , i agree with Hvd
I Passed the exam IZO-062exam today with a score of 83%
Thanks!
Best Regards,
Ricky
[email protected]