System privileges versus object privileges
6 practice questions under this official exam objective (1Z0-071) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Which Three Actions Can Be Performed Only With System Privileges?
Oracle separates system privileges, which are granted at the data-dictionary level and are not tied to a named object, from object privileges, which a
Which Two Statements Are True About WITH GRANT OPTION?
WITH GRANT OPTION lets the grantee of an object privilege pass that privilege on to other users in the database, but never to PUBLIC, which is why (B,
Which Three Statements About Oracle Privileges and Roles Are True?
Oracle privileges and roles questions test whether you can separate system privileges (database-wide rights) from object privileges and role ownership
System and Object Privileges in Oracle Database
This question tests the rules for granting system and object privileges, specifically focusing on WITH GRANT OPTION limitations and cascading revocati
Which Three Object Privileges Apply to Tables, Views, and Sequences?
Understand which object privileges can be granted on tables, views, and sequences in Oracle. This page explains why UPDATE, ALTER, and REFERENCES are
Which GRANT Statements Execute Successfully on Roles?
Oracle GRANT syntax keeps system privileges (no ON clause) and object privileges (privilege ON object) in two separate statement forms. This page expl