单选题You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process.  Which action will enable you to disable the trac

题目
单选题
You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process.  Which action will enable you to disable the trace files generated by the ARCn background process？（）
A

 Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.

B

 Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.

C

 Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.

D

 Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.

相似考题

1.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.

2.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.

3. 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 utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature

4.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.

更多“You are maintaining an OLTP database in Oracle10g. You find ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

    • A、 redo log files
    • B、 password file
    • C、 control file
    • D、 change tracking file

    正确答案:D

  • 第5题：

    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

    • A、 by using the Flashback Database feature
    • B、 by using RMAN incomplete recovery
    • C、 by performing a user-managed incomplete recovery
    • D、 by dropping and re-creating the index tablespace

    正确答案:D

  • 第6题：

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


    正确答案： A
    解析： 暂无解析

  • 第7题：

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


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process.  Which action will enable you to disable the trace files generated by the ARCn background process？（）
    A

     Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.

    B

     Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.

    C

     Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.

    D

     Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）
    A

     redo log files

    B

     password file

    C

     control file

    D

     change tracking file


    正确答案： B
    解析： 暂无解析

  • 第10题：

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


    正确答案： A
    解析： 暂无解析

  • 第11题：

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


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）
    A

    Datafiles

    B

     Current control file

    C

     Server parameter file （spfile）

    D

     Password file


    正确答案： D
    解析： 暂无解析

  • 第13题：

    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter？（）

    • A、 Zero
    • B、 One or more
    • C、 NONE
    • D、 DEFAULT

    正确答案:B

  • 第14题：

    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

  • 第15题：

    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

    • A、Datafiles
    • B、 Current control file
    • C、 Server parameter file （spfile）
    • D、 Password file

    正确答案:D

  • 第16题：

    You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

    • A、 UNTIL SEQUENCE
    • B、 UNTIL SCN
    • C、 UNTIL CHANGE
    • D、 UNTIL CANCEL

    正确答案:C,D

  • 第17题：

    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

    • A、 incomplete recovery
    • B、 complete recovery
    • C、 recovery using the Flashback Database feature
    • D、 recovery using the export/import utility

    正确答案:A

  • 第18题：

    单选题
    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）
    A

     incomplete recovery

    B

     complete recovery

    C

     recovery using the Flashback Database feature

    D

     recovery using the export/import utility


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

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


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）
    A

     by using the Flashback Database feature

    B

     by using RMAN incomplete recovery

    C

     by performing a user-managed incomplete recovery

    D

     by dropping and re-creating the index tablespace


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use？（）
    A

     LIST command

    B

     CROSSCHECK command

    C

     REPORT command

    D

     SHOW command


    正确答案： D
    解析： 暂无解析

  • 第23题：

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


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    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 optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）
    A

     Oracle Enterprise Manager

    B

     The V$LOG view

    C

     The V$LOGFILE view

    D

     The V$FLASHBACK_DATABASE_LOGS view


    正确答案： A
    解析： 暂无解析

相关内容