07: Password and Ref

Chapter 7: User Creation and Management

TRUE/FALSE

1. Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.

ANS: T PTS: 1 REF: 196

2. User names in Oracle10g can consist of up to 30 characters.

ANS: T PTS: 1 REF: 196

3. The password for a user can be set with the PASSWORD clause of the CREATE USER command.

ANS: F PTS: 1 REF: 197

4. Permissions allow users to execute certain SQL statements in Oracle10g.

ANS: F PTS: 1 REF: 198

5. Object privileges allow users to perform DML operations on the data contained within database objects.

ANS: T PTS: 1 REF: 198

6. The INSERT, UPDATE, and DELETE object privileges can be applied to tables and views.

ANS: T PTS: 1 REF: 200

7. Both system and object privileges can be granted with the GRANT command.

ANS: T PTS: 1 REF: 199-200

8. A user can be granted both system and object privileges in the same GRANT command.

ANS: F PTS: 1 REF: 199-200

9. The GRANT clause of the GRANT command identifies the user who is granting a specific privilege.

ANS: F PTS: 1 REF: 199-201

10. The WITH GRANT OPTION is required to allow a user to grant the specified object privileges to other users.

ANS: T PTS: 1 REF: 201

11. The system privileges available in Oracle10g can be viewed through the SYSTEM_PRIVILEGE_MAP data dictionary view.

ANS: T PTS: 1 REF: 198

12. The UPDATE ANY TABLE privilege is a system privilege.

ANS: F PTS: 1 REF: 200

13. Any privilege with the ANY keyword in it is automatically an object privilege.

ANS: F PTS: 1 REF: 198

14. The ON clause of the GRANT command is used to specify which objects can be altered by the system privilege(s) specified in the command.

ANS: F PTS: 1 REF: 201

15. The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.

ANS: T PTS: 1 REF: 202-203

16. A role can only be granted to other roles.

ANS: F PTS: 1 REF: 204

17. Even if a set of privileges