Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 205

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

    Correct Answer: B, C, F

    GLOBAL TEMPORARY TABLES (GTTs) can be referenced in the defining query of a view, which means they are flexible in terms of query definitions. DML operations on GLOBAL TEMPORARY TABLES generate no REDO, minimizing the overhead for temporary operations. Also, a trigger can be created on a GLOBAL TEMPORARY TABLE, which allows for procedural actions when certain DML actions occur. However, they can have multiple indexes, and they can have public synonyms, contradicting some of the other options provided.

Discussion
Sathitest071Options: BEF

Answer is BEF https://oracle-base.com/articles/misc/temporary-tables

lucemqyOptions: BEF

BEF is correct