Which three actions can you perform only with system privileges? (Choose three.)
Which three actions can you perform only with system privileges? (Choose three.)
The ability to query any table in a database requires the SELECT ANY TABLE system privilege, which allows access to all tables across the database. Logging in to a database instance requires the CREATE SESSION system privilege, which is necessary for establishing a session within the database. Accessing flat files in an operating system directory via the UTL_FILE package requires system-level privileges to manage interaction between the database and the file system.
A. Query any table in a database. True. The ability to query any table across the database requires the SELECT ANY TABLE system privilege. This is a system-level permission and not specific to objects within a user's schema. B. Execute a procedure in another schema. True. To execute a procedure in another schema, a user would need the EXECUTE ANY PROCEDURE system privilege. While direct object privileges can be granted to execute a specific procedure, the system privilege is broader and not restricted to a single schema. C. Log in to a database instance. True. Logging in to a database instance requires the CREATE SESSION system privilege. This is a fundamental system privilege that grants the user the ability to connect to the database. Answer from GPT4
https://docs.oracle.com/cd/A97630_01/server.920/a96540/statements_912a.htm#2073689
D 'WARNING:The privileges needed to access files in a directory object are operating system specific. UTL_FILE directory object privileges give you read and write access to all files within the specified directory.'
https://www.examtopics.com/discussions/oracle/view/8222-exam-1z0-071-topic-1-question-235-discussion/
ACD is right i think
C Log in to database - Create session system privilege
B "Execute a procedure in another schema" This is an object privilege
Sorry EXECUTE ANY PROCEDURE system privilege
A READ ANY TABLE system privilege allows a user to query tables, views, or materialized views in any schema in the database.