You created a tablespace with the following statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE ‘/proddb/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 TABLESPACEadtbs RESIZE 20G;
B.
ALTER TABLESPACEadtbs ADD DATAFILE;
C.
ALTER TABLESPACEadtbs MODIFY DATAFILE ‘/proddb/data/adtbs.dbf’ AUTOEXTEND
ON;
D.
ALTER TABLESPACEadtbs AUTOEXTEND ON;
E.
ALTER TABLESPACEadtbs ADD DATAFILE ‘/proddb/data/adtbs1.dbf’ SIZE 10G;