Which three actions can you perform 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.
The Answer Is:
A, B, C
This question includes an explanation.
Explanation:
A. Correct. Truncating a table, especially in another schema, requires the ALTER ANY TABLE or DROP ANY TABLE system privilege. B. Correct. Accessing external files through the database involves the CREATE ANY DIRECTORY privilege, which is a system privilege. C. Correct. Creating a session in a database, which is required to log in, necessitates the CREATE SESSION system privilege. D. Incorrect. Querying any table is an object privilege, which can be granted by the owner of the table. E. Incorrect. The WITH GRANT OPTION clause is used with object privileges, not system privileges. F. Incorrect. Executing a procedure in another schema requires the EXECUTE object privilege on that procedure.
Oracle Database Security Guide provides the details about system privileges necessary for these actions.
1z0-071 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"