niusouti.com

多选题Which two statements are true with respect to the maintenance window？（） .AA DBA can enable or disable an individual task in all maintenance windows.BA DBA cannot change the duration of the maintenance window after it is created.CIn case of a long maint

题目
多选题
Which two statements are true with respect to the maintenance window？（） .
A

A DBA can enable or disable an individual task in all maintenance windows.

B

A DBA cannot change the duration of the maintenance window after it is created.

C

In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.

D

A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window

相似考题

1.The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()A. to prevent the creation of an excessive number of scheduler job classesB. to allow the Automated Maintenance Tasks to use system resources without any restrictionC. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

2.Which maintenance functions can a GMDSS Radio Operator perform ________．A.The Operator can make fine internal adjustments to the transmitter as long as the output power does not change by more than one percentB.The Operator is responsible for ensuring that INMARSAT antennas are free of built-up soot and clear of obstaclesC.All levels of maintenance must be performed by a licensed GMDSS Radio MaintainerD.The Operator may install an EPROM in order to ensure that the equipment continues to operate within legal constraints

3. 英译中：Could you call maintenance to fix the window and housekeeping to clean the carpet, please?

4.Which of the following advisors is run in every maintenance window by the auto－task system?()A. The Memory AdvisorB. The SQL Tuning AdvisorC. The Undo AdvisorD. The SQL Access Advisor

更多“多选题Which two statements are true with respect to the maintenance window？（） .AA DBA can enable or disable an individual task in all maintenance windows.BA DBA cannot change the duration of the maintenance window after it is created.CIn case of a long maint”相关问题

  • 第1题：

    Which of the following is not a typical maintenance task within a network maintenance model？（）

    • A、Providing technical customer support
    • B、Changing configurations
    • C、Updating software
    • D、Monitoring network performance
    • E、Replacing hardware
    • F、Scheduling backups

    正确答案:A

  • 第2题：

    Which TWO of the following tasks of system maintenance can be improved by using Remote Deployment Manager？（）

    • A、Deployment
    • B、Software maintenance
    • C、Driver updates
    • D、Disposal
    • E、Software inventory

    正确答案:A,D

  • 第3题：

    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

    • A、The online redo log files and online data files are opened.
    • B、All the online data file headers are checked for consistency.
    • C、Instance recovery is performed before opening the database.
    • D、The path and existence of all the log file members are checked

    正确答案:A,B

  • 第4题：

    Which two statements are true with respect to the maintenance window？（） .

    • A、 A DBA can enable or disable an individual task in all maintenance windows.
    • B、 A DBA cannot change the duration of the maintenance window after it is created.
    • C、 In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.
    • D、 A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window

    正确答案:A,D

  • 第5题：

    Which of the following advisors is run in every maintenance window by the auto-task system?（）

    • A、The Memory Advisor
    • B、The SQL Tuning Advisor
    • C、The Undo Advisor
    • D、The SQL Access Advisor

    正确答案:B

  • 第6题：

    Which two statements are true with respect to the maintenance window? （）

    • A、A DBA can enable or disable an individual task in all maintenance windows.
    • B、A DBA cannot change the duration of the maintenance window after it is created.
    • C、In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
    • D、A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

    正确答案:A,D

  • 第7题：

    单选题
    Which of the following is not a typical maintenance task within a network maintenance model？（）
    A

    Providing technical customer support

    B

    Changing configurations

    C

    Updating software

    D

    Monitoring network performance

    E

    Replacing hardware

    F

    Scheduling backups


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

  • 第8题：

    多选题
    Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)
    A

    Segment Advisor

    B

    SQL Access Advisor

    C

    Optimizer statistics gathering

    D

    Automatic SQL Tuning Advisor

    E

    Automatic Database Diagnostics Monitor


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

  • 第9题：

    单选题
    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement is true in this scenario（）
    A

    The statistics collection continues until all objects are processed.

    B

    The job is terminated and the statistics collected are restored to a time before the job started.

    C

    This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.

    D

    The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened


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

  • 第10题：

    多选题
    Which two statements are true regarding views?（）
    A

    A subquery that defines a view cannot include the GROUP BY clause

    B

    A view that is created with the subquery having the DISTINCT keyword can be updated

    C

    A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

    D

    A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table


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

  • 第11题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；  Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


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

  • 第12题：

    多选题
    Which TWO of the following tasks of system maintenance can be improved by using Remote Deployment Manager？（）
    A

    Deployment

    B

    Software maintenance

    C

    Driver updates

    D

    Disposal

    E

    Software inventory


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

  • 第13题：

    Which of the following are benefits to server virtualization?（）

    • A、Better server hardware leverage
    • B、Increased application security
    • C、Smaller backup window needed
    • D、Lower power consumption
    • E、Smaller datacenter footprint
    • F、Little to no maintenance needed

    正确答案:A,B,E

  • 第14题：

    Which three statements are true regarding the functioning of the Autotask Background Process （ABP）？（）

    • A、 It creates jobs without considering the priorities associated with them.
    • B、 It translates tasks into jobs for execution by the scheduler.
    • C、 It determines the list of jobs that must be created for each maintenance window.
    • D、 It is spawned by the MMON background process at the start of the maintenance window.
    • E、 It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

    正确答案:B,C,D

  • 第15题：

    The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）

    • A、to prevent the creation of an excessive number of scheduler job classes
    • B、to allow the Automated Maintenance Tasks to use system resources without any restriction
    • C、to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
    • D、to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

    正确答案:D

  • 第16题：

    Which statement most accurately describes the implementation of a SQL Access Advisor recommendation？（）  

    • A、 SQL Access Advisor recommendations are automatically implemented.
    • B、 Individual SQL Access Advisor recommendations can be scheduled for implementation.
    • C、 All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
    • D、 SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
    • E、 None of the above.

    正确答案:B

  • 第17题：

    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement is true in this scenario（）

    • A、The statistics collection continues until all objects are processed.
    • B、The job is terminated and the statistics collected are restored to a time before the job started.
    • C、This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
    • D、The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened

    正确答案:D

  • 第18题：

    多选题
    Which of the following are benefits to server virtualization?（）
    A

    Better server hardware leverage

    B

    Increased application security

    C

    Smaller backup window needed

    D

    Lower power consumption

    E

    Smaller datacenter footprint

    F

    Little to no maintenance needed


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

  • 第19题：

    多选题
    After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


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

  • 第20题：

    多选题
    Which three statements are true regarding the functioning of the Autotask Background Process （ABP）？（）
    A

    It creates jobs without considering the priorities associated with them.

    B

    It translates tasks into jobs for execution by the scheduler.

    C

    It determines the list of jobs that must be created for each maintenance window.

    D

    It is spawned by the MMON background process at the start of the maintenance window.

    E

    It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.


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

  • 第21题：

    单选题
    Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?（）
    A

    SQL Access Advisor recommendations are automatically implemented.

    B

    Individual SQL Access Advisor recommendations can be scheduled for implementation.

    C

    All SQL Access Advisor recommendations for a specific task must be implemented at the same time.

    D

    SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.

    E

    None of the above.


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

  • 第22题：

    多选题
    Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?（）
    A

    A DBA can check specific tables with the DMU

    B

    The database to be migrated must be opened read-only.

    C

    The release of the database to be converted can be any release since 9.2.0.8.

    D

    The DMU can report columns that are too long in the converted characterset.

    E

    The DMU can report columns that are not represented in the converted characterset.


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

  • 第23题：

    单选题
    Which maintenance functions can a GMDSS Radio Operator perform（）.
    A

    The Operator can make fine internal adjustments to the transmitter as long as the output power does not change by more than one percent

    B

    The Operator is responsible for ensuring that INMARSAT antennas are free of built-up soot and clear of obstacles

    C

    All levels of maintenance must be performed by a licensed GMDSS Radio Maintainer

    D

    The Operator may install an EPROM in order to ensure that the equipment continues to operate within legal constraints


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

相关内容