【2019年8月】OCP 071认证考试最新版本的考试原题-第24题

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。临时表创建的目的就是为了测试,如果很多操作不支持,那就失去了测试的意义。)

上一篇:MySQL如何创建临时表


下一篇:c – 是否可以更改临时对象并将其作为参数传递?