Oracle
1Z0-063 · Question #125
You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G; The tablespace is nearly full and youneed to avoid any out of space errors…
The correct answer is A. ALTER TA3LESPACE adtbs RESI2E 20G; C. ALTER TABLESPACE adtbs AUTOEXTEND ON. See the full explanation below for the reasoning.
Question
You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G; The tablespace is nearly full and youneed to avoid any out of space errors for the load of a 5 gig table. Which two alter statements will achieve this?
Options
- AALTER TA3LESPACE adtbs RESI2E 20G;
- BALTER TA3LESPACE adtbs ADD DATAFILE;
- CALTER TABLESPACE adtbs AUTOEXTEND ON;
- DALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
- EALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;
How the community answered
(63 responses)- A73% (46)
- B5% (3)
- D6% (4)
- E16% (10)
Community Discussion
No community discussion yet for this question.