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()
A:The command must be issued in MOUNT state.
B:The command succeeds only if the data file is offline.
C:The command must be issued when the database is in the archivelog mode.
D:The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
出自:Oracle认证