Managing Roles   «Prev  Next»

Oracle System Privileges - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. When you grant a user a system privilege such as CREATE TABLE or CREATE INDEX, what does that privilege allow the user to do?
Please select the best answer.
  A. Create, alter, or drop the object in all schemas
  B. Create the object in any schema in the database
  C. Create, alter, and drop the object in the user's schema only
  D. Create the object, but not alter or drop it, in the user's schema only

2. What do the ANY privileges allow you to do?
Please select the best answer.
  A. Create any type of database object in any schema
  B. Create any type of database object in your own schema
  C. Create a specific type of database object in any schema
  D. Create a specific type of database object in your own schema

3. You need to give a user the ability to modify tables for other users in the database. Which privilege should you grant?
Please select the best answer.
  A. CREATE TABLE
  B. ALTER ANY TABLE
  C. CREATE ANY TABLE
  D. ALTER TABLE

4. You need to give a user the ability to alter the user's own tables. What privilege should you grant?
Please select the best answer.
  A. ALTER ANY TABLE
  B. ALTER TABLE
  C. ALTER OWN TABLE
  D. CREATE TABLE