Oracle Database 12c: Advanced Administration — Question 136

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;

Correct answer: A, C

Explanation

The correct answers are A and C. Option A increases the size of the tablespace to accommodate more data, while option C enables autoextending, allowing the datafile to grow as needed. Options B, D, and E are either incomplete or do not provide a direct solution to the space issue.