Question 78:
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?
Answer options:
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;