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
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