Oracle Database 12c Advance Adminstration1z0-063 Test 2

Question : 11 of 40

Marks: +1, -0

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? (Choose two.)

ALTER TABLESPACE adtbs RESI2E 20G;
ALTER TABLESPACE adtbs ADD DATAFILE;
ALTER TABLESPACE adtbs AUTOEXTEND ON;
ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Validate

Go to Question:

Prev Question

Next Question