Oracle
1Z0-063 · Question #125
1Z0-063 Question #125: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-063 to reveal the answer and full explanation for question #125. The question stem and answer options stay visible for context.
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;
Unlock 1Z0-063 to see the answer
You've previewed enough free 1Z0-063 questions. Unlock 1Z0-063 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.