Prev Question
Next Question

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;

Explanation:
http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

Prev Question
Next Question

Leave a Reply

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