You issue the following commands:
SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata/orcl';
SQL> CREATE TABLESPACE august_sales DATAFILE '/u01/app/oracle/mydata/mysales.dbf' size 10M;
SQL> CREATE TEMPORARY TABLESPACE temp101 TEMPFILE '/u01/app/oracle/mydata/mytemp101.tmp' SIZE 20M;
The directories '/u0l/app/oracle/oradata/orcl'and '/u0l/app/oracle/mydata'exist. Which statement describes the outcome?
A. The AUGUST_SALES tablespace is created with its data file in the DB_CREATE_FILE_DEST location and the TEMP101 tablespace is created with its temp file in the '/u01/app/oracle/mydata'location.
B. The TEMP101tablespace is created with its temp file in the DB_CREATE_FILE_DEST location and the AUGUST_SALES tablespace is created with its data file in the '/u01/app/oracle/mydata/mysales.dbf'location.
C. The two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATE commands.
D. Tablespace creation ignores the data file and temp file locations specified in the CREATE commands, and creates both the tablespaces in the DB_CREATE_FILE_DEST location.
Correct Answer:
C