Oracle System Privileges - Quiz Explanation

The correct answers are indicated below, along with text that explains the correct answers.
1. When you grant a user an object 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
  The correct answer is C. When you grant a user and object privilege, you allow the user to create, alter, and drop the object in user's own schema only. Object creation privileges such as CREATE TABLE and CREATE INDEX are given to users to allow them to create objects in their own schema. Since the user owns the object created, these privileges also convey the right to alter or drop the object.

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
  The correct answer is C. The ANY privileges allow you to create specific types of objects in schemas other than your own. CREATE ANY TABLE, for example, allows you to create tables for other users. D is partially correct. Because the ANY privileges let you create objects in any schema, you could create them in your own. A and D are incorrect because there is no one privilege that lets you create any type of object. Type of object has its own ANY privilege associated with it.

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
  The correct answer is B. You should grant the ALTER ANY TABLE system privilege. CREATE ANY TABLE does not allow you to alter the tables that you create. CREATE TABLE only allows you to alter tables in your schema, and there is no such thing as an ALTER TABLE privilege.

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
  The correct answer is D. The CREATE TABLE privilege not only allows users to create tables of their own, but it allows users to alter and drop those tables as well. B and C are incorrect because those privileges don't exist. A would allow the user to alter not only the user's own tables, but those of every other user as well.