Oracle Exam 1Z0-060 Topic 2 Question 13 Discussion

Actual exam question for Oracle's 1Z0-060 exam

Question #: 13
Topic #: 2

You issue the following commands:

The directories '/u0l/app/oracle/oradata/orcl' and '/u0l/app/oracle/mydata' exist.

Which statement describes the outcome?

AThe 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.

BThe TEMP101 tablespace 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.

CThe two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATE commands.

DTablespace 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.

Show Suggested Answer

Suggested Answer: C

by Vincent at May 07, 2022, 10:58 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-060 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!