Oracle
1Z0-052 · Question #131
1Z0-052 Question #131: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #131. The question stem and answer options stay visible for context.
Managing Database Storage Structures
Question
You execute a command to resize a data file, sales.dbf, of size 200 MB in your database: ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M; Which statement is true about this command?
Options
- AThe command must be issued in MOUNT state.
- BThe command succeeds only if the data file is offline.
- CThe command must be issued when the database is in the archivelog mode.
- DThe command succeeds if no extent in the tablespace is currently allocated above the 150 MB
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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
#datafile resize#ALTER DATABASE DATAFILE#extents#tablespace