Which two ALTER statements are correct in this scenario?

You created a tablespace with the following statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE ‘/probdb/data/adtbs.dbf’ SIZE 10G;
There is now a requirement to increase the size of the tablespace.
Which two ALTER statements are correct in this scenario? (Choose two.)
A. ALTER TABLESPACE adtbs RESIZE 20G;
B. ALTER TABLESPACE adtbs ADD DATAFILE;
C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
D. ALTER TABLESPACE adtbs ADD DATAFILE’/proddb/data/adtbs1.dbf’ SIZE 10G;
E. ALTER TABLESPACE adtbs MODIFY DATAFILE ‘/proddb/data/adtbs.dbf’ AUTOEXTEND ON;

Download Printable PDF. VALID exam to help you PASS.