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