QUESTION 121:
You executed the following command to resize a data file, sales.dbf, of size 200MB in your database:
ALTER DATABASE DATAFILE /remorse/sales.dbf RESIZE 150M;
What would be the effect of this command?
A.The command succeeds and the data beyond 150 MB is lost.
B.The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
C.The command fails because it is not possible to reduce the size of the data file.
D.The command fails because it is possible to reduce only the size of the system data file.