Oracle
1Z0-034 · Question #56
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…
The correct answer is A. ALTER TABLESPACE adtbs RESIZE 20G; C. ALTER TABLESPACE adtbs AUTOEXTEND ON. See the full explanation below for the reasoning.
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;
How the community answered
(22 responses)- A82% (18)
- B9% (2)
- D5% (1)
- E5% (1)
Community Discussion
No community discussion yet for this question.