Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
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.
Answer is BEF https://oracle-base.com/articles/misc/temporary-tables
BEF is correct