ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
分类： Oracle
2019-11-06 10:08:36
Choose three.
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。临时表创建的目的就是为了测试，如果很多操作不支持，那就失去了测试的意义。)
