Oracle
1Z0-067 · Question #160
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…
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #160. The question stem and answer options stay visible for context.
New Features for Storage
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 you need 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;
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#bigfile tablespace#AUTOEXTEND#RESIZE#tablespace extension