Topic : Profile Management

What is a profile?


Answer :

Each database user is assigned a Profile that specifies limitations on various system resources available to the user.

Show Answer Discuss

What are the system resources that can be controlled through Profile ?


Answer :

The number of concurrent sessions the user can establish the CPU processing time available to the user's session the CPU processing time available to a single call to ORACLE made by a SQL statement the amount of logical I/O available to the user's session the amout of logical I/O available to a single call to ORACLE made by a SQL statement the allowed amount of idle time for the user's session the allowed amount of connect time for the user's session.

Show Answer Discuss

Which statement about profiles is false?


  • Profile assignments do not affect current sessions.
  • Profiles enable group resource limits for similar users.
  • Profiles are assigned to users; roles; and other profiles.
  • The ALTER USER command can be used to assign profiles to users.

Answer :

Profiles are assigned to users; roles; and other profiles.

Show Answer Discuss

Which password management feature is NOT available by using a profile?


  • Account locking
  • Password history
  • Password change
  • Password aging and expiration

Answer :

Password change

Show Answer Discuss

Which resource can not be controlled using profiles?


  • Idle time
  • CPU time
  • PGA memory allocations
  • Number of concurrent sessions for a user name

Answer :

Number of concurrent sessions for a user name

Show Answer Discuss