单选题In your database， the users SYS and SYSTEM have been assigned the profiles， ADMIN_PROF1 and ADMIN_PROF2， respectively. The rest of the database administrators are assigned the profile ADMIN_PROF3. You create a profile， USER_PROF， and assign it to the a

第1题：

You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）

• A、Assign the DEFAULT profile to the users
• B、Set the RESOURCE_LIMIT parameter to TRUE in the parameter file
• C、Create a new profile with CPU restrictions and assign it to the users
• D、Specify the users as members of the DEFAULT_CONSUMER_GROUP
• E、Revoke the DBA role and grant CONNECT and RESOURCE role to the users

第2题：

From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users.   Which method would you use to achieve this objective？（）

• A、create a plan directive in the SYS_GROUP
• B、create the pending area for the consumer group
• C、activate the provided SYSTEM_PLAN in Resource Manager
• D、set the TIMED_STATISTICS parameter to TRUE in the parameter file
• E、set the execution time limit for all users， except SYS and SYSTEM， in their profiles

第3题：

You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；  Which statement describes the result（）

• A、The command produces an error.
• B、The profile is dropped and current user sessions use the DEFAULT profile immediately.
• C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
• D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.

第4题：

You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?（）

• A、It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
• B、It contains username and passwords of database users who are members of the OSOPER operating system group.
• C、It contains usernames and passwords of database users who are members of the OSDBA operating system group.
• D、It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
• E、It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

第5题：

You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

• A、SYSTEM 
• B、OUTLN 
• C、INTERNAL 
• D、SYS

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

In your database， the users SYS and SYSTEM have been assigned the profiles， ADMIN_PROF1 and ADMIN_PROF2， respectively. The rest of the database administrators are assigned the profile ADMIN_PROF3. You create a profile， USER_PROF， and assign it to the application user， Adams. After a week you realize that the profile is no longer required and you decide to drop it. What will Adam’s profile be after the USER_PROF profile has been dropped？（）

• A、no profiles
• B、the default profile
• C、same as the profile of SYS user
• D、same as the profile of SYSTEM user

第14题：

A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work.  ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）

• A、Modify the profile assigned to the user.
• B、Modify the roles assigned to the users.
• C、Modify the object privileges assigned to the user.
• D、Modify the system privileges assigned to the users.
• E、Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

第15题：

While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

• A、the CREATE TABLE .. command
• B、sorting of the SYSTEM tablespace’s data
• C、sorting of data required by recursive SQL statements
• D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
• E、sorting of data if the users have not been allocated temporary tablespace explicitly
• F、sorting of data if the users have been allocated temporary tablespace explicitly

第16题：

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?（）

• A、All users except SYS
• B、All users except SCOTT
• C、All users except sys and SCOTT
• D、All users except sys, system, and SCOTT

第17题：

You create a Web application. The Web application enables users to change fields in their personal profiles. Some of the changes are not persisting in the database. You need to raise a custom event to track each change that is made to a user profile so that you can locate the error. Which event should you use?（）

• A、WebAuditEvent
• B、WebEventManager
• C、WebBaseEvent
• D、WebRequestEvent

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：