Oracle Exam 1Z0-064 Topic 9 Question 19 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 19
Topic #: 9

Examine the command:

SQL> ALTER SYSTEM SET TEMP_UNDO_ENABLED = TRUE;

Which two statements are true about setting the parameter value to TRUE?

AIt improves performance because DML and DDL operations performed on temporary tables do not use the database buffer cache and redo log buffer.

BIt improves database performance by reducing the overhead on the PGA.

CIt reduces the amount of redo generated for DML operations performed on temporary tables.

DIt reduces the amount of undo stored in the undo tablespace.

Show Suggested Answer

Suggested Answer: B, D

by Alisha at May 08, 2022, 06:32 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!