vital statistics

题目

vital statistics

相似考题

1.［A］ additional ［B］ vital ［C］ singular ［D］ exceptional

2.Which three statements are true about SQL plan directives?()A. They are tied to a specific statement or SQL id.B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.C. They are used to gather only missing statistics.D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.E. They instruct the optimizer to create only column group statistics.F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

3.Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);Which three statements are true about the effect of this command?()A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

4.You executed the following commands:Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?()A. The statistics are stored in the pending statistics table in the data dictionary.B. The statistics are treated as the current statistics by the optimizer for all sessions.C. The statistics are treated as the current statistics by the optimizer for the current sessions only.D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

更多“vital statistics”相关问题

  • 第1题：

    在sqlserver数据库中,通过哪条语句可以检查查询使用的时间和CPU使用情况?()

    A.使用set statistics io语句

    B.使用set statistics time语句

    C.使用set statistics CPU语句

    D.使用set statistics time and CPU语句


    参考答案：B

  • 第2题：

    比率分析应当选择的操作菜单是（）

    • A、Analyze→Descriptive Statistics→Frequencies
    • B、Analyze→Descriptive Statistics→Descriptives
    • C、Analyze→Descriptive Statistics→Crosstabs
    • D、Analyze→Descriptive Statistics→Ratio

    正确答案:D

  • 第3题：

    VPC（Vital Platform Computer）指（）。


    正确答案:安全处理计算机

  • 第4题：

    生命征（vital sign）


    正确答案:是评价生命活动存在与否及其质量的指标，包括体温、脉搏、呼吸和血压，为体格检查时必须检查的项目之一

  • 第5题：

    Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）；  Which statementdescribes the effect of the above command（）

    • A、Automatic statistics collection is stopped for the CUSTOMERS table.
    • B、Statistics for the CUSTOMERS table are locked and cannot be overwritten.
    • C、Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
    • D、Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics

    正确答案:D

  • 第6题：

    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

  • 第7题：

    Examine the command：  SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）

    • A、Automatic statistics collection is stopped for the CUSTOMERS table.
    • B、Statistics for the CUSTOMERS table are locked and cannot be overwritten.
    • C、Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
    • D、Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.

    正确答案:D

  • 第8题：

    单选题
    You need to design the retrieval of advertising statistics without compromising security. What should you do?（）
    A

    Design a Notification Services solution that sends the advertising statistics to specified subscribers by e-mail.

    B

    Design a SQL Server Web service that runs a stored procedure to return the statistics on a call from the advertisers application.

    C

    Design a Database Mail solution that sends the advertising statistics to e-mail addresses that are specified in a table.

    D

    Design a stored procedure to return the statistics on a call from the advertisers application.

    E

    Design a user-defined function to return the statistics on a call from the advertisers application.


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

  • 第9题：

    单选题
    在sqlserver数据库中，通过哪条语句可以检查查询使用的时间和CPU使用情况？（）
    A

    使用set statistics io语句

    B

    使用set statistics time语句

    C

    使用set statistics CPU语句

    D

    使用set statistics time and CPU语句


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

  • 第10题：

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

  • 第11题：

    单选题
    While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）
    A

    It updates the existing SQL profiles with current statistics.

    B

    It makes the statistics information available to GATHER_STATS_JOB

    C

    It initiates the statistics collection process by running GATHER_STATS_JOB

    D

    It logs a warning message in the alert log so that the DBA can perform statistics collection manually.


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

  • 第12题：

    填空题
    VPC（Vital Platform Computer）指（）。

    正确答案： 安全处理计算机
    解析： 暂无解析

  • 第13题：

    交叉分组下频数分析应选择的菜单是（）

    • A、Analyze→Descriptive Statistics→Frequencies
    • B、Analyze→Descriptive Statistics→Descriptives
    • C、Analyze→Descriptive Statistics→Crosstabs
    • D、Analyze→Descriptive Statistics→Ratio

    正确答案:C

  • 第14题：

    All of the following types of statistics are reported by the iostat command tool EXCEPT:（）.

    • A、 Free memory
    • B、 CPU statistics 
    • C、 Disk statistics 
    • D、 Terminal statistics

    正确答案:A

  • 第15题：

    morbidity statistics


    正确答案: 疾病统计，是居民健康统计的重要内容之一，它的任务是研究疾病在人群中发生、发展及其流行的规律，为病因学研究、疾病防治和评价疾病防治效果提供科学依据。

  • 第16题：

    在sqlserver数据库中，通过哪条语句可以检查查询使用的时间和CPU使用情况？（）

    • A、使用set statistics io语句
    • B、使用set statistics time语句
    • C、使用set statistics CPU语句
    • D、使用set statistics time and CPU语句

    正确答案:B

  • 第17题：

    You executed the following commands：   SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；   Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）

    • A、 The statistics are stored in the pending statistics table in the data dictionary.
    • B、 The statistics are treated as the current statistics by the optimizer for all sessions.
    • C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.
    • D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.

    正确答案:A

  • 第18题：

    While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）

    • A、It updates the existing SQL profiles with current statistics.
    • B、It makes the statistics information available to GATHER_STATS_JOB
    • C、It initiates the statistics collection process by running GATHER_STATS_JOB
    • D、It logs a warning message in the alert log so that the DBA can perform statistics collection manually.

    正确答案:B

  • 第19题：

    单选题
    You executed the following commands：   SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；   Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）
    A

     The statistics are stored in the pending statistics table in the data dictionary.

    B

     The statistics are treated as the current statistics by the optimizer for all sessions.

    C

     The statistics are treated as the current statistics by the optimizer for the current sessions only.

    D

     The statistics are temporary and used by the optimizer for all sessions until this session terminates.


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

  • 第20题：

    单选题
    Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）；  Which statementdescribes the effect of the above command（）
    A

    Automatic statistics collection is stopped for the CUSTOMERS table.

    B

    Statistics for the CUSTOMERS table are locked and cannot be overwritten.

    C

    Existing statistics for the CUSTOMERS table become unusable for the query optimizer.

    D

    Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics


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

  • 第21题：

    单选题
    Examine the command：  SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）
    A

    Automatic statistics collection is stopped for the CUSTOMERS table.

    B

    Statistics for the CUSTOMERS table are locked and cannot be overwritten.

    C

    Existing statistics for the CUSTOMERS table become unusable for the query optimizer.

    D

    Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.


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

  • 第22题：

    单选题
    All of the following types of statistics are reported by the iostat command tool EXCEPT:（）.
    A

     Free memory

    B

     CPU statistics 

    C

     Disk statistics 

    D

     Terminal statistics


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

  • 第23题：

    单选题
    The order of importance in addressing damage control is（）.
    A

    control flooding，control fire，repair structural damage

    B

    restore vital services，control fire，control flooding

    C

    control fire，restore vital services，control flooding

    D

    control fire，control flooding，repair structural damage


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

相关内容