单选题Your database initialization parameter file has the following entry：   SEC_MAX_FAILED_LOGIN_ATTEMPTS=3   Which statement is true regarding this setting？（）AIt drops the connection after the specified number of login attempts fail for any user.BIt is enf

第1题：

You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

• A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
• B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
• C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
• D、 Increase the value of the SGA_TARGET initialization parameter.

第2题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

• A、 control file
• B、 all datafiles
• C、 password file
• D、 online redo log file
• E、 archive redo log file
• F、 server parameter file
• G、 only the SYSTEM datafile

第3题：

In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？  

• A、 database buffer cache
• B、 shared pool
• C、 PGA
• D、 large pool

第4题：

Which two file types must be included in a closed database backup taken with operating system commands？（）

• A、data files
• B、control file
• C、password file
• D、online redo log files
• E、initialization parameter file

第5题：

You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）

• A、 0
• B、 1
• C、 NONE
• D、 DEFAULT

第6题：

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

• A、 The database will not start.
• B、 The database will start but will not retain the undo data in the undo segment.
• C、 The database will start， and the undo segment will contain the undo data for at least one hour.
• D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.

第7题：

You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）

• A、 DB_RECOVERY_FILE_DEST only
• B、 DB_FLASHBACK_RETENTION_TARGET only
• C、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only
• D、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only
• E、 DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and
• F、 DB_FLASHBACK_RETENTION_TARGET

第8题：

Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command？（）

• A、The command would return an error because LOG_BUFFER is a static parameter.
• B、The parameter value would be changed and it would come into effect immediately.
• C、You need to restart the database so that parameter changes can come into effect.
• D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

第9题：

You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）

• A、The advisory memory has been turned off.
• B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
• C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
• D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
• E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

第10题：

The database is configured for automatic archive logging. Along with the other required parameters， this entry is in the initialization file：log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1？（）

• A、control file
• B、tnsnames.ora
• C、data dictionary
• D、initialization parameter file