Exam Prep Questions

1:	What is the name of the staging area in which you build the resource plan? A. Staging area B. Temporary area C. Pending area D. Building area
A1:	Answer C is the correct answer; you create resource plans in the pending area. Answer A is incorrect; although it can be considered to be a staging area, it is called a pending area. Answers B and D are not areas in the database.
2:	The SWITCH_GROUP parameter specifies which of the following: A. The consumer group that is a switchable consumer group B. The group that can have its status toggled between on and off C. The group to which a session will be switched when the session meets preestablished criteria D. The group from which the session will be switched when the session meets preestablished criteria
A2:	Answer C is correct; SWITCH_GROUP is the group to which a session will switch when it meets preexisting criteria. Answer A is incorrect; all consumer groups are switchable under defined circumstances. Answer B is incorrect; you cannot toggle groups off and on. Answer D is incorrect; it is the group to which the session will switch, not from which it will switch.
3:	From which data dictionary view can you determine what profile has been assigned to a given user? A. DBA_USERS B. DBA_PROFILES C. DBA_RESOURCE_LIMITS_SET D. V$USER
A3:	Answer A is correct; you can determine the profile assigned to any given user. Answer B is incorrect; DBA_PROFILES tells you the profiles in the database and their limits, but not to whom they have been assigned. Answers C and D are incorrect because they are not valid data dictionary views.
4:	You have created the following profiles in your database: DEVELOPERS for programmers, MANAGERS for managers, ACCOUNTING for people in the accounting department, CLIENTS for external users of the database, and OUSERS for everyone else. You have just been notified that you need to create a userid for a new regular user employee (Frieda), and you run the following command: CREATE USER Frieda IDENTIFIED BY peanut PASSWORD EXPIRE ACCOUNT UNLOCK; To which of the following profiles has Frieda been assigned? A. OUSER B. DEVELOPER C. ACCOUNTING D. DEFAULT
A4:	Answer D is correct; because you have not deliberately assigned Frieda to any profile, she will default to the DEFAULT profile. Answer A is incorrect; you may have meant for her to be assigned to the OUSER profile, but it needs to be assigned deliberately. Answers B and C are also incorrect because Frieda was not assigned to any profile and so has by default been assigned to DEFAULT.
5:	You have decided that you need to do some serious reorganization of your profiles in your database and move to a standard naming convention for the profiles in the database. In the process, you decide that you have to drop the dev01 profile and reassign its users to the DEVELOPER profile. How can you drop the dev01 profile and still allow your users to access the database while you are building the new profile? A. DROP PROFILE dev01; B. DROP PROFILE dev01 CASCADE DELETE; C. DROP PROFILE dev01 CASCADE; D. You have to wait till the DEVELOPER profile is ready to use to switch them to the new one, or they won't be able to connect.
A5:	Answer C is correct; you need to issue the DROP PROFILE command with the CASCADE keyword to drop the profile and have it automatically unassigned to all the users. Answer A is incorrect; it will drop the profile but will not unassign the profile from the users and would therefore error if any users were assigned. Answer B is incorrect; you don't CASCADE DELETE. The DELETE keyword would cause the command to fail. Answer D is incorrect; when you drop the profile, the users will be reassigned to the DEFAULT profile and will be able to continue to connect successfully.
6:	Your company has decided to implement a password expiration plan. What parameter do you need to set to cause all passwords to expire every 60 days? A. PASSWORD_LIFE_TIME B. PASSWORD_EXPIRATION_DAYS C. PASSWORD_REUSE_TIME D. PASSWORD_GRACE_TIME
A6:	Answer A is correct; PASSWORD_LIFE_TIME allows you to set the maximum number of days that can pass before the password is expired. Answer B is incorrect; it is not a valid parameter for password maintenance. Answer C is incorrect; PASSWORD_REUSE_TIME sets the amount of days that must pass before a password can be reused again. Answer D is incorrect; PASSWORD_GRACE_TIME is the period in which you have to change your password after it has expired.
7:	You have created the following profile in your development database: CREATE PROFILE limit_programmers LIMIT SESSIONS_PER_USER 2 CPU_PER_CALL 100 CONNECT_TIME 480 IDLE_TIME 45; How will Oracle determine the value of CPU_PER_SESSION? A. It will get the value from the DEFAULT profile and use that value. B. It will multiply CPU_PER_CALL by the average number of calls that the user can make in a given CONNECT_TIME session to determine what CPU_PER_SESSION should be. C. It will use the CPU_PER_CALL and sets CPU_PER_SESSION to that value as well. D. It will not set the value of CPU_PER_SESSION for this profile.
A7:	Answer A is correct; it will take the value from the DEFAULT profile whether or not you have changed its values and set the CPU_PER_SESSION to whatever the current value of that parameter is in the DEFAULT profile. Answer B is incorrect; Oracle won't do math to infer a value for a parameter. Answer C is incorrect; Oracle won't set the parameter based on another parameter name. Answer D is incorrect; the parameter will be set with an inferred value from DEFAULT.
8:	You want to use composite resource limits in your new Oracle database. Which of the following commands must be issued first so that your profiles' composite resources will be assigned a value for your composite limits? A. ALTER PROFILE B. ALTER SYSTEM C. ALTER RESOURCE COST D. ALTER USER
A8:	Answer C is correct; you need to issue the ALTER RESOURCE COST command to set the weighted values for the resources in your system. Answer A is incorrect; you can't alter the profile to set the resource weights. Answer B is incorrect; composite limits are connected to resources and profiles, not directly to the system. Answer D is incorrect; you do not have to alter individual users to make use of the changes to the profiles or to the resource weights.
9:	What initialization parameter must be set for Oracle to enforce the resource limits according to your profile settings? A. RESOURCE_LIMITS B. PROFILE_LIMITS C. ALLOW_PROFILES D. PROFILE_OPTION_VALUES
A9:	Answer A is correct; you set RESOURCE_LIMITS to trUE to be able to enforce resource limits in your database. Answers B, C, and D are incorrect; they are not valid parameters for the initialization file.
10:	What Oracle-supplied package do you use to maintain your Resource Manager components? A. DBMS_RES_MAN B. DMBS_RESOURCE_MANAGER C. DBMS_MANAGE_RESOURCES D. RMAN
A10:	Answer B is correct; DMBS_RESOURCE_MANAGER is the package that you use to help with resource manager management. Answers A and C are not part of the database. Answer D is incorrect; RMAN is a recovery manager and is used for backup and recovery, not resource management.