1Z0-062 · Question #374
DEFERRED_SEGMENT_CREATION is TRUE in one of your databases. You execute this command: Which three statements are true immediately after this statement executes successfully?
The correct answer is A. A database object is created. B. No database segment is created. C. The table and column definitions are stored in the data dictionary. When DEFERRED_SEGMENT_CREATION is TRUE, creating a table immediately establishes it as a database object and stores its definitions in the data dictionary, but postpones physical storage segment allocation until data is inserted.
Question
DEFERRED_SEGMENT_CREATION is TRUE in one of your databases. You execute this command:
Which three statements are true immediately after this statement executes successfully?
Options
- AA database object is created.
- BNo database segment is created.
- CThe table and column definitions are stored in the data dictionary.
- DNo table definition is stored in the data dictionary.
- ENo column definitions are stored in the data dictionary.
- FNo object definition is stored in the data dictionary.
How the community answered
(26 responses)- A81% (21)
- D12% (3)
- E4% (1)
- F4% (1)
Why each option
When `DEFERRED_SEGMENT_CREATION` is TRUE, creating a table immediately establishes it as a database object and stores its definitions in the data dictionary, but postpones physical storage segment allocation until data is inserted.
Executing `CREATE TABLE` successfully creates a new table object in the database, which is an instance of a database object.
With `DEFERRED_SEGMENT_CREATION` set to TRUE, the physical segment for the table is not allocated until data is first inserted into it, meaning no segment is created immediately after `CREATE TABLE`.
The table and column definitions, along with other metadata for the new table object, are immediately stored in the data dictionary views (like `USER_TABLES`, `USER_TAB_COLUMNS`) upon successful creation.
The table definition is stored in the data dictionary immediately, even if segment creation is deferred.
The column definitions are stored in the data dictionary immediately as part of the table object's metadata.
The object definition (for the table) is indeed stored in the data dictionary immediately.
Concept tested: Oracle DEFERRED_SEGMENT_CREATION and CREATE TABLE
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-tables.html#GUID-6F22FC28-76A4-486C-9204-CF964205C94B
Topics
Community Discussion
No community discussion yet for this question.