Which two ALTER statements are correct in this scenario?

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.)

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;



Leave a Reply 0

Your email address will not be published. Required fields are marked *