Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Chapter 16. Managing Password Security and Resources

Terms you'll need to understand:

• FAILED_LOGIN_ATTEMPTS

• PASSWORD_LOCK_TIME

• PASSWORD_LIFE_TIME

• PASSWORD_GRACE_TIME

• EXPIRED

• ACCOUNT LOCK

• ACCOUNT UNLOCK

• PASSWORD_REUSE_TIME

• PASSWORD_REUSE_MAX

• PASSWORD_VERIFY_FUNCTION

• DEFAULT profile

• RESOURCE_LIMIT

• SESSIONS_PER_USER

• CPU_PER_SESSION

• CPU_PER_CALL

• LOGICAL_READS_PER_SESSION

• PRIVATE_SGA

• LOGICAL_READS_PER_CALL

• IDLE_TIME

• CONNECT_TIME

• COMPOSITE_LIMIT

• ADMINISTER_RESOURCE_MANAGER

• DBMS_RESOURCE_MANAGER

• Pending area

• Resource consumer groups

• Resource plans

• Resource directives

Concepts you'll need to master:

• Manage passwords using profiles.

• Administer profiles.

• Control use of resources using profiles.

• Obtain information about profiles, password management, and resources from the data dictionary. ...