Oracle Database SQL — Question 189

Which three actions can you perform only with system privileges? (Choose three.)

Answer options

• A. Query any table in a database.
• B. Execute a procedure in another schema.
• C. Log in to a database instance.
• D. Access flat files, which are stored in an operating system directory, via the UTL_FILE package.
• E. Use the WITH GRANT OPTION clause.

Correct answer: A, B, D

Explanation

The correct answers A, B, and D require system privileges because they involve accessing resources or executing actions that are restricted to users with elevated permissions. Option C is incorrect because logging into a database instance typically does not require system privileges, and option E is incorrect as it pertains more to object privileges rather than system privileges.