CMS专题

单选题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?()AIncrease the 

题目
单选题
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.

如果没有搜索结果,请直接 联系老师 获取答案。
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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.

正确答案:D

第2题:

You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()

  • A、 VERSIONS_STARTSCN
  • B、 VERSIONS_STARTTIME
  • C、 VERSIONS_XID
  • D、 VERSIONS_OPERATION

正确答案:C

第3题:

You are maintaining an OLTP database in Oracle10g. You set the value of the LOG_ARCHIVE_TRACE parameter to zero. What is the impact of this setting? () 

  • A、 The trace files will be disabled only for a specific session.
  • B、 Tracing will be disabled for a client identifier.
  • C、 Tracing will be disabled only for the ARCn process.
  • D、 The SQL Trace facility will be disabled for the instance.

正确答案:C

第4题:

You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()  

  • A、the value of the UNDO_RETENTION initialization parameter
  • B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
  • C、the online redo log files size
  • D、the number of redo log members in a group

正确答案:C

第5题:

You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required?()

  • A、 V$DATABASE
  • B、 V$FLASHBACK_DATABASE_STAT
  • C、 V$FLASHBACK_DATABASE_LOG
  • D、 V$RECOVERY_FILE_DEST

正确答案:B

第6题:

You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16?()  

  • A、 by using the RMAN utility
  • B、 by using the export/import utility
  • C、 by using the ALTER DATABASE command
  • D、 by enabling the change tracking feature

正确答案:C

第7题:

You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA?()

  • A、 SQL Tuning Advisor
  • B、 Undo Advisor
  • C、 ADDM
  • D、 Memory Advisor

正确答案:D

第8题:

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.

正确答案:B

第9题:

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

正确答案:A

第10题:

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()

  • A、 online redo log files
  • B、 alert log files
  • C、 control file
  • D、 datafiles associated with the SYSTEM tablespace

正确答案:C

更多相关问题