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
ans a,c
Ans A,C