Your database instance is running.You are not able to access

第1题：

The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）

• A、The database user OPS$SKD will be able to administer the database.
• B、The authentication detail for the database user OPS$SKD is recorded in the password file.
• C、The local operating system user SKD will be able to access the database instance without specifying the username and password.
• D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

第2题：

our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

• A、Oracle Net Manager
• B、Listener Control utility
• C、Database Configuration Assistant
• D、Oracle Net Configuration Assistant

第3题：

第4题：

A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）

• A、Data Pump
• B、Oracle Net Manager
• C、Oracle Enterprise Manager
• D、Oracle Universal Installer （OUI）
• E、Database Configuration Assistant （DBCA）

第5题：

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、Oracle Migration Assistant
• B、Recovery Manager （RMAN）
• C、Oracle Data Pump Export and Import
• D、conventional Oracle Export and Import
• E、operating system utilities to copy the files to the ASM instance

第6题：

You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）

• A、The instance would hang.
• B、The instance needs to be shut down.
• C、The instance would be in the open state.
• D、The instance would abort in such cases.
• E、The instance would be in the open and invalid state.
• F、The instance would in the open state， but all the background processes will be restarted.

第7题：

For which database operation would you need the database to be in the MOUNT state（）

• A、renaming the control files
• B、re-creating the control files
• C、dropping a user in your database
• D、dropping a tablespace in your database
• E、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

第8题：

第9题：

Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command：LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance（）

• A、The sessions are able to perform only queries.
• B、The sessions are not affected and continue to function normally.
• C、The sessions are terminated and the active transactions are rolled back.
• D、The sessions are not allowed to perform any operations till the listener is started

第10题：

Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

• A、Oracle Net Manager
• B、Listener Control utility
• C、Database Configuration Assistant
• D、Oracle Net Configuration Assistant