Which two alter statements will achieve this?

You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs
DATAFILE ‘/proddb/data/adtbs.dbf’ SIZE 10G; The tablespace is nearly full and you need to
avoid any out of space errors for the load of a 5 gig table. Which two alter statements will

achieve this?

You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs
DATAFILE ‘/proddb/data/adtbs.dbf’ SIZE 10G; The tablespace is nearly full and you need to
avoid any out of space errors for the load of a 5 gig table. Which two alter statements will

achieve this?

A.
ALTER TA3LESPACE adtbs RESI2E 20G;

B.
ALTER TA3LESPACE adtbs ADD DATAFILE;

C.
ALTER TABLESPACE adtbs AUTOEXTEND ON;

D.
ALTER TA3LESPACE adtbs ADD DATAFILE ‘/proddb/data/adtbsl.dbf’ SIZE 1QG;

E.
ALTER TA3LESPACE adtbs MODIFY DATAFILE ‘/proddb/data/adtbs.dbf AUTOEXTEND
ON;



Leave a Reply 4

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


Aejaz

Aejaz

Have anyone tested this command ALTER TABLESPACE adtbs AUTOEXTEND ON; ? Is it tablespace or datafile that should be autoextend on?