Oracle
1Z0-034 · Question #56
1Z0-034 Question #56: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #56. The question stem and answer options stay visible for context.
Question
You created a tablespace with the following statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G; There is now a requirement to increase the size of the tablespace. Which two ALTER statements are correct in this scenario? (Choose two.)
Options
- AALTER TABLESPACE adtbs RESIZE 20G;
- BALTER TABLESPACE adtbs ADD DATAFILE;
- CALTER TABLESPACE adtbs AUTOEXTEND ON;
- DALTER TABLESPACE adtbs ADD DATAFILE'/proddb/data/adtbs1.dbf' SIZE 10G;
- EALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 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.