1Z0-060 · Question #198
You issue the following commands: The directories '/u0l/app/oracle/oradata/orcl' and '/u0l/app/oracle/mydata' exist. Which statement describes the outcome?
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
How the community answered
(37 responses)- A11% (4)
- B3% (1)
- C84% (31)
- D3% (1)
Why each option
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.
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.
The TEMP101 temp file is placed in the explicitly specified directory from its CREATE TEMPORARY TABLESPACE statement, not in DB_CREATE_FILE_DEST.
Oracle's file creation precedence rules dictate that an explicitly named DATAFILE or TEMPFILE path in a CREATE TABLESPACE statement always overrides the DB_CREATE_FILE_DEST initialization parameter. Because both commands specify explicit paths to existing directories, each tablespace and its associated file are created exactly where the DDL instructs, with no redirection to DB_CREATE_FILE_DEST.
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
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLESPACE.html
Topics
Community Discussion
No community discussion yet for this question.