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 的权限。

)

11-11 14:16