It retains the integrity constraints defined on the table.
D.
A ROLLBACK statement can be used to retrieve the deleted data.
E.
It always retains the space used by the removed rows.
F.
A FLASHBACK TABLE statement can be used to retrieve the deleted data.
The Answer Is:
B, C
This question includes an explanation.
Explanation:
When using the TRUNCATE TABLE command in Oracle, several aspects of the table's structure and associated database objects are impacted. Here's an explanation of each option:
A: Incorrect. TRUNCATE TABLE does not drop triggers associated with the table; they remain defined.
B: Correct. Indexes on the table are retained and not dropped when you truncate a table. However, if the index is a domain index, it may be dropped depending on its type.
C: Correct. Integrity constraints such as primary keys, foreign keys, etc., are retained unless they are on a disabled state where truncation can lead to constraint being dropped.
D: Incorrect. A TRUNCATE TABLE operation cannot be rolled back. It is a DDL (Data Definition Language) operation and commits automatically.
E: Incorrect. The TRUNCATE TABLE operation deallocates the space used by the data unless the REUSE STORAGE clause is specified.
F: Incorrect. TRUNCATE TABLE operation removes all the rows in a table and does not log individual row deletions, thus FLASHBACK TABLE cannot be used to retrieve the data.
[Reference: Oracle Database SQL Language Reference 12c, documentation on the TRUNCATE TABLE statement.]
1z0-071 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"