多选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started？（）ACreating the parse tree of the statementBWriting the modified data blocks to the 

第1题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

• A、The database is in mount state.
• B、One of the tablespaces is offline.
• C、One of the tablespaces is read only.
• D、The database operates in ARCHIEVELOG mode. 
• E、The database operates in NOARCHIEVELOG mode.

第2题：

You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database：  1：SGA is allocated.  2：Control file is read.  3：Redo log files are read.  4：Instance recovery is started.  5：Background processes are started.  6：Data files are checked for consistency.  7：Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）

• A、7，1，5，2，3，6，4
• B、1，2，3，7，5，6，4
• C、7，1，4，5，2，3，6
• D、1，7，5，4，2，3，6

第3题：

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？（）

• A、Transactions are rolled back using redo log files.
• B、Transactions are rolled forward using redo log files.
• C、Transactions are rolled back using redo log files and archived log files.
• D、Transactions are rolled forward using redo log files and rolled back using redo log files.

第4题：

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte？（）

• A、This clause is not valid for a temporary or undotablespace.
• B、If thetablespaceis in the NOLOGGING mode， no operation on thetablespacewill generate redo.
• C、Thetablespacewill be IntheNOLOGGING mode by default， if not specified while creating atablespace.
• D、Thetablespace-level logging attribute can be overridden by logging specification at the table， index， materialized view， materialized view log， and partition levels.

第5题：

The following are the details of your database：   Instance name：test   Host name：tech1.us.oracle.com   IP address：145.33.230.186  Enterprise Manager Console HTTP Port number：5500   You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control？（）

• A、http：//145.33.230.186：5500/em
• B、http：//www.145.33.230.186：5500/em
• C、http：//tech1.us.oracle.com：5500/em
• D、http：//test.145.33.230.186：5500/em
• E、http：//test.tech1.us.oracle.com：5500
• F、http：//www.tech1.us.oracle.com：5500/em
• G、http：//test.tech1.us.oracle.com：5500/em

第6题：

You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

• A、Application Server Control
• B、Oracle Management Service
• C、Oracle Enterprise Manager Repository
• D、Oracle Enterprise Manager Database Control

第7题：

You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

• A、You must have started the database instance in restricted mode.
• B、You must have started the database instance inNORMALmode.
• C、You must have started the database instance with server parameter file.
• D、You must have started the database instance but must not have mounted.
• E、You must have started the database instance but must not have opened.

第8题：

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）

• A、Displays only the list of default values
• B、Displays only the list of all basic parameters
• C、Displays the currently in effect parameter values
• D、Displays only the list of all advanced parameters
• E、Displays the list of all the parameter files of a database
• F、Displays the current contents of the server parameter file.

第9题：

The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）  

• A、 The Oracle database will perform block checking for the index blocks only
• B、 The Oracle database will not perform block checking for any of the data blocks
• C、 The Oracle database will perform block checking for the default permanent tablespace only
• D、 The Oracle database will perform block checking for the data blocks in all user tablespaces
• E、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

第10题：

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started？（）

• A、Creating the parse tree of the statement
• B、Writing the modified data blocks to the data files
• C、Writing the modified data to the archived redo log files
• D、Updating the control file to indicate the most recent checkpoint
• E、Updating the data file header to indicate the most recent checkpoint
• F、Reading the blocks to database buffer cache if they are not already there