单选题Upon starting your database， you receive the following error：   SQL> startup ORACLE instance started.  Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 

第1题：

Upon starting your database， you receive the following error：   SQL> startup ORACLE instance started.  Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted.  ORA-00313： open failed for members of log group 1 of thread 1  ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01.log’ ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01a.log’   You can choose from the following steps：   a. Restore the database datafiles.  b. Issue the alter database clear unarchived logfile group 1 command. c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using point-in-time recovery. f. Issue the Startup Mount command to mount the database.  g. Back up the database.  Which is the correct order of these steps in this case？（）

• A、a， f， e， d， g
• B、f， e， d
• C、f， b， c， g
• D、a， f， c
• E、The database cannot be recovered.

第2题：

Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

• A、The retention period to support flashback
• B、The expected length of the longest-running query
• C、The number of undo tablespaces in the database
• D、The size of the Flash Recovery Area for the database instance

第3题：

You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）

• A、Writes buffers to disk 
• B、Writes current redo log number to datafile headers 
• C、Writes redo log information to disk 
• D、Reads information into memory for users

第4题：

You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）

• A、Configure Java Pool to cache the java objects.
• B、Configure Streams Pool to enable parallel processing.
• C、Increase Shared Pool size to cache more PL/SQL objects.
• D、Increase Database Buffer Cache size to increase cache hits.
• E、Configure Large Pool to be used by RMAN and shared server.
• F、Increase the total System Global Area （SGA） size to increase memory hits.

第5题：

You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）

• A、 the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
• B、 the column of the V$INSTANCE_RECOVERY view
• C、 the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
• D、 the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

第6题：

Which of the following is true about the MPLS header and its EXP field size？（）

• A、The MPLS header is 2 bytes，and the EXP field is 3 bits long.
• B、The MPLS header is 1 byte，and the EXP field is 3 bits long.
• C、The MPLS header is 4 bytes，and the EXP field is 3 bits long.
• D、The MPLS header is 3 bytes，and the EXP field is 3 bits long.

第7题：

You executed the following command to start the database：  SQL> STARTUP  ORACLE instance started.  Total System Global Area 281018368 bytes  Fixed Size 789000 bytes  Variable Size 229635576 bytes  Database Buffers 50331648 bytes  Redo Buffers 262144 bytes ORA-00205： error in identifying controlfile， check alert log for more info  Which view would you query at this stage to investigate this missing control file？（）

• A、V$INSTANCE
• B、V$CONTROLFILE
• C、DBA_CONTROL_FILES
• D、V$DATABASE_PROPERTIES
• E、V$CONTROLFILE_RECORD_SECTION

第8题：

What are the consequences of executing the SHUTDOWN ABORT command？ （）

• A、The database files are synchronized.
• B、Uncommitted changes are not rolled back.
• C、The database is closed， but the instance is still started.
• D、Database buffers and redo buffers are not written to the disk.
• E、The database undergoes automatic media recovery during the next startup.

第9题：

You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）  

• A、 10M
• B、 400M
• C、 600M
• D、 800M

第10题：

You receive the following error：   ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit   Identify the reason for receiving the above error message？（）

• A、 The sort area is very small.
• B、 There is no more space in the Undo tablespace.
• C、 The flash recovery area is full.
• D、 The online redo log file is full.