You created a tablespace with this statement:CREATE BIGFILE TABLESPACE adtbs -DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G
Posted: Sun Jun 11, 2023 3:54 pm
You created a tablespace with this statement:CREATE BIGFILE TABLESPACE adtbs -DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;The tablespace is nearly full and youneed to avoid any out of space errors for the load of a5 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;
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;