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

第1题：

You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

• A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
• B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
• C、 The database instance starts，but Automatic Memory Management is disabled
• D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

第2题：

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

第3题：

第4题：

Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using 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.

第5题：

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

第6题：

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

第7题：

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

第8题：

第9题：

You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

• A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
• B、 Before the instance starts， you receive an error about the missing redo log files of a group.
• C、 The instance starts and the database opens with an error message written to the alert log file.
• D、 The instance starts and the database opens because two redo log groups still exist.
• E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

第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