单选题You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）A Size of redo logs B Number of datafiles C LOG_CHECKPOINT_INTER

题目内容(请给出正确答案)

单选题

You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）

Size of redo logs

Number of datafiles

LOG_CHECKPOINT_INTERVAL

LOG_CHECKPOINT_TIMEOUT

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题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？（）Aonline redo log filesBalert log filesCcontrol fileDdatafiles associated with the SYSTEM tablespace

点击查看答案
第2题

单选题You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）A Database Datafiles B Database Control Files C Online redo logsD Archived redo logs E The database SPFILE F None of the above, all these files are backed up.

点击查看答案
第3题

单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）A Writes buffers to disk B Writes current redo log number to datafile headers C Writes redo log information to disk D Reads information into memory for users

点击查看答案
第4题

单选题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？（）AOracle Enterprise ManagerBThe V$LOG viewCThe V$LOGFILE viewDThe V$FLASHBACK_DATABASE_LOGS view

点击查看答案
第5题

单选题You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）A Size of redo logs B Number of datafiles C LOG_CHECKPOINT_INTERVAL D LOG_CHECKPOINT_TIMEOUT

点击查看答案
第6题

单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）AThe archived redo logs are stored in an operating system-dependent location.BThe archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.CThe archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.DThe archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.

点击查看答案
第7题

多选题You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）ADisable automatic checkpoint tuning.BCheck the size of the redo log file size and increase the size if it is small.CSet the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.DDecrease the number of redo log members if there are more than one redo log members available in each redo log group.

点击查看答案

单选题You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）A Size of redo logs B Number of datafiles C LOG_CHECKPOINT_INTER

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容