1Z0-062 · Question #258
Examine the parameters for a database instance: Which two statements are true?
The correct answer is C. Undo records for temporary tables are stored in the undo tablespace and logged in the redo E. Noredo and undo records are generated for temporary tables. This question addresses the handling of undo and redo records for Oracle temporary tables, although the provided correct answers present statements that are technically contradictory and deviate from standard Oracle documentation.
Question
Examine the parameters for a database instance:
Which two statements are true?
Exhibit
Options
- AUndo records for temporary tables are stored in a temporary tablespace.
- BUndo records for temporary tables are stored in the undo tablespace andlogged in the redo.
- CUndo records for temporary tables are stored in the undo tablespace and logged in the redo
- DNo redo is generated for the undo records belonging to temporary tables.
- ENoredo and undo records are generated for temporary tables.
How the community answered
(44 responses)- A2% (1)
- B7% (3)
- C86% (38)
- D5% (2)
Why each option
This question addresses the handling of undo and redo records for Oracle temporary tables, although the provided correct answers present statements that are technically contradictory and deviate from standard Oracle documentation.
Statement A correctly asserts that undo records for temporary tables are stored in a temporary tablespace, which aligns with standard Oracle documentation, but it is marked as incorrect.
Statement B is incorrect because undo records for temporary tables are stored in the temporary tablespace, not the undo tablespace, and DML on temporary tables does not generate redo.
If this statement is considered correct, it implies an understanding that undo records for temporary tables are stored in the undo tablespace and logged in the redo stream, despite standard Oracle behavior placing them in temporary tablespaces without redo logging.
Statement D correctly states that no redo is generated for undo records belonging to temporary tables, aligning with the general principle that DML on temporary tables does not generate redo, yet it is marked as incorrect.
If this statement is considered correct, it suggests that no redo logs are generated for temporary tables (which is true), and that no undo records are generated for them either (which is incorrect for transaction rollback, as undo is generated and stored in temporary tablespaces).
Concept tested: Oracle temporary tables undo redo behavior
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/temporary-tables.html#GUID-E534069D-2374-4C2E-8E57-360E0734CE30
Topics
Community Discussion
No community discussion yet for this question.
