itgle.com

多选题To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）ALOG_HISTORYBJOB_LOG_RETENTIONCWINDOW_LOG_RETENTIONDWHICH_LOGELOG_NAME

题目
多选题
To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）
A

LOG_HISTORY

B

JOB_LOG_RETENTION

C

WINDOW_LOG_RETENTION

D

WHICH_LOG

E

LOG_NAME

相似考题

1.You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A. The collection level for the AWR should be set to BASICB. The moving window size must be less than Undo RetentionC. The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

2.What qualification is NOT mentioned as a preference?A.Knowledge of stage set design B.Expertise in the history of theater C.Experience in making period costumes D.A university degree in a related field

3. In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command：  CONFIGURE RETENTION POLICY TO NONE;  What would be the impact of this setting？（）A、The retention policy is cleared.B、RMAN does not consider any backup as obsolete.C、The retention policy is set to its default setting of redundancy 1.D、The retention policy is set to its default setting of recovery window 7.

4.To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?()A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAME

参考答案和解析
正确答案： D,E
解析： 暂无解析
更多“To set the history retention period for either window loggin”相关问题

  • 第1题：

    You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）

    • A、The collection level for the AWR should be set to BASIC
    • B、The moving window size must be less than Undo Retention
    • C、The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
    • D、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

    正确答案:D

  • 第2题：

    Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future.  What action would you take to achieve this task？（）

    • A、Set the STATISTICS_LEVEL initialization parameter to ALL.
    • B、Create a baseline on a pair of snapshots that have the statistics of the peak­load period in the database.
    • C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak­load period.
    • D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.

    正确答案:B

  • 第3题：

    You have an Exchange Server 2010 organization that contains 20 mailbox databases. You configure each database to retain all deleted items for 30 days.You need to ensure that all items that pass the retention period are permanently deleted daily between 02：00 and 06：00. Which cmdlet should you use？（）

    • A、Set-MailboxDatabase
    • B、Set-MailboxServer
    • C、Set-OrganizationConfig
    • D、Set-RetentionPolicy

    正确答案:A

  • 第4题：

    You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）

    • A、set SQL_TRACE=True 
    • B、set UNDO_RETENTION=14400 
    • C、set FAST_START_MTTR_TARGET=240 
    • D、set LOG_CHECKPOINT_INTERVAL=240 
    • E、set DB_FLASHBACK_RETENTION_TARGET=14400 
    • F、set the RETENTION GUARANTEE clause for the undo tablespace

    正确答案:B,E

  • 第5题：

    Initially， for the Automatic Workload Repository （AWR） statistics，the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However，when you observe the Memory Advisor on a Friday，you find that the statistics are available only for two days， Thursday and Friday，of that week. What would have caused the statistics to be removed？（）

    • A、On Wednesday， the statistics have been purged.
    • B、On Wednesday， the retention period has been set to zero.
    • C、On Wednesday， the collection interval has been set to zero.
    • D、On Wednesday， the collection level has been changed to All.
    • E、On Wednesday， the retention period has been set to one day.
    • F、On Wednesday， the retention period has been set to two days
    • G、On Wednesday, the collection level has been changed to Typical.
    • H、On Wednesday, the collection interval has been set to 1440 minutes.

    正确答案:F

  • 第6题：

    Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）

    • A、Set the STATISTICS_LEVEL initialization parameter to ALL.
    • B、Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
    • C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
    • D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.

    正确答案:B

  • 第7题：

    You work as a network exchange administrator at company.com.the company.com network currently consists of a single active directory forest containing a single domain named company.com.the company.com organization makes use of microsoft exchange server 2010 as their messaging solution.thecompany.com organization currently makes use of a computer named -ex01.during the course of the business week you receive instruction from company.com to configure a retention period of 30 days for all deleted message items whilst ensuring that each item which passes the retention period are removed between 3：00 and 5：00 on a daily basis. What should you do？（）

    • A、you should consider having the maintenance schedule of king database changed for the retention and removal of message items.
    • B、you should consider having the messaging record management （mrm） schedule for-ex01 changed for the retention and removal of message items.
    • C、you should consider having the set-retention policy cmdlet run to schedule the retention and removal of message items.
    • D、you should consider having the start-managed folder assistant cmdlet run to schedule the retention and removal of message items.

    正确答案:A

  • 第8题：

    单选题
    The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）
    A

    set DB_FLASHBACK_RETENTION_TARGET=10800  

    B

    create a new scheduler window for the time period of 24 hours and use the optimizer statistics 

    C

    modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings 

    D

    specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations


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

  • 第9题：

    单选题
    The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future.  What would you do？（）
    A

     Create two custom ADDM tasks.

    B

     Modify the AWR snapshot time interval to two hours.

    C

     Create a new scheduler window for a time period of two hours.

    D

     Modify the Automatic Workload Repository （AWR） snapshot retention period to two hours.


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

  • 第10题：

    多选题
    To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?（）
    A

    LOG_HISTORY

    B

    JOB_LOG_RETENTION

    C

    WINDOW_LOG_RETENTION

    D

    WHICH_LOG

    E

    LOG_NAME


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

  • 第11题：

    单选题
    Initially， for the Automatic Workload Repository （AWR） statistics，the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However，when you observe the Memory Advisor on a Friday，you find that the statistics are available only for two days， Thursday and Friday，of that week. What would have caused the statistics to be removed？（）
    A

    On Wednesday， the statistics have been purged.

    B

    On Wednesday， the retention period has been set to zero.

    C

    On Wednesday， the collection interval has been set to zero.

    D

    On Wednesday， the collection level has been changed to All.

    E

    On Wednesday， the retention period has been set to one day.

    F

    On Wednesday， the retention period has been set to two days

    G

    On Wednesday, the collection level has been changed to Typical.

    H

    On Wednesday, the collection interval has been set to 1440 minutes.


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

  • 第12题：

    多选题
    Your database instance is functional for the past one month. The Automatic Workload Repository（AWR） snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL.  You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day.  Choose two actions any of which can be referred to first to diagnose the problem. （）
    A

    Use the Active Session History report.

    B

    Use the AWR Compare Periods report.

    C

    Use an ADDM analysis between 7 PM and 9 PM of the previous day.

    D

    Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.


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

  • 第13题：

    Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future.  What action would you take to achieve this task（）

    • A、Insert finding directives for ADDM tasks in the future.
    • B、Create a baseline on a pair of snapshots spanning the peak-load period.
    • C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
    • D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.

    正确答案:B

  • 第14题：

    To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?（）

    • A、LOG_HISTORY
    • B、JOB_LOG_RETENTION
    • C、WINDOW_LOG_RETENTION
    • D、WHICH_LOG
    • E、LOG_NAME

    正确答案:A,D

  • 第15题：

    能够实现“窗体总在最前端”界面效果的API函数是（）。

    • A、Set Window Pos 
    • B、Set Window API 
    • C、Set Window Shape 
    • D、Declare API

    正确答案:A

  • 第16题：

    Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）

    • A、It is the time period after which the undo data becomes obsolete.
    • B、It is the time period after which the committed undo data would be transferred to a temporarytablespace.
    • C、It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.
    • D、It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.

    正确答案:C

  • 第17题：

    Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.  What action would you take to achieve this task（）

    • A、Insert finding directives for ADDM tasks in the future.
    • B、Create a baseline on a pair of snapshots spanning the peak-load period.
    • C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
    • D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots

    正确答案:B

  • 第18题：

    The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）

    • A、set DB_FLASHBACK_RETENTION_TARGET=10800  
    • B、create a new scheduler window for the time period of 24 hours and use the optimizer statistics 
    • C、modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings 
    • D、specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations

    正确答案:D

  • 第19题：

    You need to design a strategy for managing the messages that are sent to the customer service mailboxes. What should you do？（）

    • A、Create a separate storage group and database to contain the customer service mailboxes. Enable circular logging for this storage group
    • B、Create a separate storage group and database to contain the customer service mailboxes. Set the deleted item retention period for this database to zero
    • C、Place the customer service mailboxes on a new mailbox store in the storage group that contains the main office user mailboxes. Enable circular logging for this storage group
    • D、Place the customer service mailboxes on a new mailbox store in the storage group that contains the branch office user mailboxes. Set the deleted item retention period for this database to zero

    正确答案:A

  • 第20题：

    单选题
    In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command：  CONFIGURE RETENTION POLICY TO NONE;  What would be the impact of this setting？（）
    A

    The retention policy is cleared.

    B

    RMAN does not consider any backup as obsolete.

    C

    The retention policy is set to its default setting of redundancy 1.

    D

    The retention policy is set to its default setting of recovery window 7.


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

  • 第21题：

    单选题
    The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）
    A

    Create two custom ADDM tasks.

    B

    Modify the AWR snapshot time interval to two hours.

    C

    Create a new scheduler window for a time period of two hours.

    D

    Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.


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

  • 第22题：

    单选题
    Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）
    A

    It is the time period after which the undo data becomes obsolete.

    B

    It is the time period after which the committed undo data would be transferred to a temporarytablespace.

    C

    It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.

    D

    It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.


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

  • 第23题：

    单选题
    You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）
    A

    The command produces an error because the retention period cannot be reduced

    B

    All historical data older than 3 years is purged from the flashback archive FLA1

    C

    All historical data is retained but the subsequent flashback data archives are maintained for only 3 years

    D

    All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time


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

  • 第24题：

    单选题
    What qualification is NOT mentioned as a preference?
    A

    Knowledge of stage set design

    B

    Expertise in the history of theater

    C

    Experience in making period costumes

    D

    A university degree in a related field


    正确答案： C
    解析：
    第2段分别表明了A项、C项和D项对应的优先条件，但并未提到B项中的话剧史的专业知识，因此B项说法错误。

相关内容