Which three statements are true about GLOBAL TEMPORARY TABLES?
A) A GLOBAL TEMPORARY TABLE cannot have PUBLIC SYNONYM.
B) A GLOBAL TEMPORARY TABLE can have multiple indexes
C) A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.
D) Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.
E) A GLOBAL TEMPORARY TABLE can have only one index.
F) A tigger can be created on a GLOBAL TEMPORARY TABLE
Answer：BCD
(解析：全局临时表跟普通表一样，可以创建索引、视图、触发器等等，dml 操作同样也会产生 redo。临时表创建的目的就是为了测试，如果很多操作不支持，那就失去了测试的意义。)
【2019年8月】OCP 071认证考试最新版本的考试原题-第24题
原文：https://blog.51cto.com/13854012/2448109