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 statementB、Writing the modified data blocks to the data filesC、Writing the modified data to the archived redo log filesD、Updating the control file to indicate the most recent checkpointE、Updating the data file header to indicate the most recent checkpointF、Reading the blocks to database buffer cache if they are not already there
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
相关考题：
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.
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 valuesB、Displays only the list of all basic parametersC、Displays the currently in effect parameter valuesD、Displays only the list of all advanced parametersE、Displays the list of all the parameter files of a databaseF、Displays the current contents of the server parameter file.
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.
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 ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control
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，4B、1，2，3，7，5，6，4C、7，1，4，5，2，3，6D、1，7，5，4，2，3，6
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.
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/emB、http：//www.145.33.230.186：5500/emC、http：//tech1.us.oracle.com：5500/emD、http：//test.145.33.230.186：5500/emE、http：//test.tech1.us.oracle.com：5500F、http：//www.tech1.us.oracle.com：5500/emG、http：//test.tech1.us.oracle.com：5500/em
According to your backup strategy， you performed an incremental level 0 backup of yourdatabase. Which statement regarding this backup is true？（）A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.
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 onlyB、 The Oracle database will not perform block checking for any of the data blocksC、 The Oracle database will perform block checking for the default permanent tablespace onlyD、 The Oracle database will perform block checking for the data blocks in all user tablespacesE、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
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.
You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.
You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）A、Event Viewer gives more details on the failure.B、The alert log file gives detailed information about the failure.C、PMON rolls back the transaction and releases the locks.D、SMON rolls back the transaction and releases the locks.E、The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.F、Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
Your boss at Supportcenter.cn 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.
Your boss at Certkiller .com 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.
You have the following requirements in relation to the detection of block corruption for your database instance： Check for logical self-consistency of data blocks when modified in memory. Checksums are calculated before and after the block change. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically？（）A、 Set the DB_SECUREFILE parameter to PERMITTEDB、 Set the DB_ULTRA_SAFE parameter to DATA_ONLYC、 Set the DB_LOCK_CHECKSUM parameter to TYPICALD、 Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.
单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）AThe database is in mount state.BOne of the tablespaces is offline.COne of the tablespaces is read only.DThe database operates in ARCHIEVELOG mode.EThe database operates in NOARCHIEVELOG mode.
单选题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？（）ATransactions are rolled back using redo log files.BTransactions are rolled forward using redo log files.CTransactions are rolled back using redo log files and archived log files.DTransactions are rolled forward using redo log files and rolled back using redo log files.
多选题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 data filesCWriting the modified data to the archived redo log filesDUpdating the control file to indicate the most recent checkpointEUpdating the data file header to indicate the most recent checkpointFReading the blocks to database buffer cache if they are not already there
多选题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？（）Ahttp：//145.33.230.186：5500/emBhttp：//www.145.33.230.186：5500/emChttp：//tech1.us.oracle.com：5500/emDhttp：//test.145.33.230.186：5500/emEhttp：//test.tech1.us.oracle.com：5500Fhttp：//www.tech1.us.oracle.com：5500/emGhttp：//test.tech1.us.oracle.com：5500/em
单选题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？（）AYou must have started the database instance in restricted mode.BYou must have started the database instance inNORMALmode.CYou must have started the database instance with server parameter file.DYou must have started the database instance but must not have mounted.EYou must have started the database instance but must not have opened.
单选题Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）AThe database is in mount state.BOne of the tablespaces is offline.COne of the tablespaces is read only.DThe database operates in ARCHIEVELOG mode. EThe database operates in NOARCHIEVELOG mode.
单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）ADisplays only the list of default valuesBDisplays only the list of all basic parametersCDisplays the currently in effect parameter valuesDDisplays only the list of all advanced parametersEDisplays the list of all the parameter files of a databaseFDisplays the current contents of the server parameter file.
多选题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？（）AThis clause is not valid for a temporary or undotablespace.BIf thetablespaceis in the NOLOGGING mode， no operation on thetablespacewill generate redo.CThetablespacewill be IntheNOLOGGING mode by default， if not specified while creating atablespace.DThetablespace-level logging attribute can be overridden by logging specification at the table， index， materialized view， materialized view log， and partition levels.
单选题Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？ （）ATransactions are rolled back using redo log files.BTransactions are rolled forward using redo log files.CTransactions are rolled back using redo log files and archived log files.DTransactions are rolled forward using redo log files and rolled back using redo log files.
单选题According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）AThe backup is similar to image copy.BThe backup contains all used data blocks.CThe backup contains only unused data blocks.DThe backup contains all data blocks changed since the last incremental level 1 backup.
单选题You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）AThe backup is similar to image copy.BThe backup contains all used data blocks.CThe backup contains only unused data blocks.DThe backup contains all data blocks changed since the last incremental level 1 backup.