1Z0-060 Question #198: Real Exam Question with Answer & Explanation

The correct answer is C: The two tablespaces are created with the data file and temp file in their respective locations as. When explicit file paths are provided in CREATE TABLESPACE or CREATE TEMPORARY TABLESPACE DDL, Oracle uses those specified locations and ignores the DB_CREATE_FILE_DEST parameter.

Question

You issue the following commands: The directories '/u0l/app/oracle/oradata/orcl' and '/u0l/app/oracle/mydata' exist. Which statement describes the outcome?

Exhibit

Options

AThe AUGUST_SALES tablespace is created with its data file in the DB_CREATE_FILE_DEST
BThe TEMP101 tablespace is created with its temp file in the DB_CREATE_FILE_DEST location
CThe two tablespaces are created with the data file and temp file in their respective locations as
DTablespace creation ignores the data file and temp file locations specified in the CREATE

Explanation

When explicit file paths are provided in CREATE TABLESPACE or CREATE TEMPORARY TABLESPACE DDL, Oracle uses those specified locations and ignores the DB_CREATE_FILE_DEST parameter.

Common mistakes.

A. DB_CREATE_FILE_DEST is only applied when no explicit DATAFILE clause is provided; the explicit path in the CREATE TABLESPACE statement takes precedence over this parameter.
B. The TEMP101 temp file is placed in the explicitly specified directory from its CREATE TEMPORARY TABLESPACE statement, not in DB_CREATE_FILE_DEST.
D. Oracle never ignores an explicitly coded DATAFILE or TEMPFILE location in a CREATE TABLESPACE command; explicit paths always override initialization parameter defaults.

Concept tested. Oracle tablespace file location precedence over DB_CREATE_FILE_DEST

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLESPACE.html

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice