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()
- 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 boundary of the file.