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

Choose three

Which three actions can you perfom only with system privileges?

A) Truncate a table in another schema.

B) Access flat files via a database, which are stored in an operating system directory.

C) Log in to a database.

D) Query any table in a database.

E) Use the WITH GRANT OPTION clause.

F) Execute a procedure in another schema.

Answer：CDF

(解析：这道题考的就是可以授权哪些系统权限去做哪些活儿。

C：create session

D：select any table

F：EXECUTE ANY PROCEDURE

原来以为 AAnswer：正确，结构查询发现没有 truncate any table 的权限。

)