单选题In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level.  Y

第1题：

In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above（）

• A、By assigning profiles for the users
• B、By implementing Fine-Grained Auditing （FGA）
• C、By granting a secure application role to the users
• D、By implementing the Database Resource Manager plan

第2题：

Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）

• A、User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；
• B、User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；
• C、User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；
• D、User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；
• E、User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；

第3题：

第4题：

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

• A、renaming the control files
• B、dropping a user in your database
• C、enabling or disabling redo log archiving
• D、dropping a tablespace in your database
• E、re-creating the control files， after you lost all the control files in your database

第5题：

You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）

• A、FULL
• B、SCHEMAS
• C、REMAP_SCHEMA
• D、REMAP_DATAFILES
• E、REMAP_TABLESPACE

第6题：

The database users are connecting to the PROD database from different  applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one.  Which action would you take to achieve this objective？（）

• A、set the SESSIONS to 1 in the parameter file
• B、grant SINGLE SESSION privilege to all of the users
• C、set the SESSIONS_PER_USER to 1 in the users’ profile
• D、grant RESTRICTED SESSION privilege to all of the database users
• E、create a role with SINGLE SESSION privilege and assign the role to the users

第7题：

You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16？（）  

• A、 by using the RMAN utility
• B、 by using the export/import utility
• C、 by using the ALTER DATABASE command
• D、 by enabling the change tracking feature

第8题：

In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

• A、the alert log file
• B、the core dump files
• C、the change tracking file
• D、the user session trace files
• E、the database audit trail files
• F、the background process trace files

第9题：

When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）

• A、audit trail
• B、alert log file
• C、user trace file
• D、online trace file
• E、background trace file
• F、operating system event viewer

第10题：

The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.  Which option of Data Pump Import would you use to accomplish this？（）  

• A、 owner
• B、 touser
• C、 attach
• D、 remap_schema