Which four resource limits are averaged by specified weighting to give a composite limit?
When assigning a COMPOSITE_LIMIT to a profile, Oracle calculates a weighted sum for these resource limits: PRIVATE_SGA CPU_PER_SESSION CONNECT_TIME LOGICAL_READS_PER_SESSION To specify the weights assigned to each limit, use the ALTER RESOURCE COST command. • Evaluate this statement: ALTER PROFILE juan LIMIT CPU_PER_SESSION 3600 (1/100 Sec) IDLE_TIME 30; (Min) How much time will be allowed in the next session for user JUAN? 36 seconds of cpu time and 30 minutes of inactivity CPU_PER_SESSION is expressed in hundredths of seconds and IDLE_TIME is expressed in minutes • You ran the script to create the VERIFY_FUNCTION function and it altered the DEFAULT profile. After the VERIFY_FUNCTION is enabled and the DEFAULT profile is altered, a user must change their password using these guidelines: 1. The new password must differ from the old password by more than three characters. 2. The password must have at least 4 characters. 3. The password cannot be equal to the username. 4.
