morbidity statistics

题目

morbidity statistics

相似考题

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

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

3.在sqlserver数据库中,通过哪条语句可以检查查询使用的时间和CPU使用情况?()A.使用set statistics io语句B.使用set statistics time语句C.使用set statistics CPU语句D.使用set statistics time and CPU语句

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

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

  • 第1题：

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

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

    正确答案:C

  • 第2题：

    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

  • 第3题：

    vital statistics


    正确答案: 生命统计，以人口生命事件为内容的统计活动。生命事件包括人口的出生、死亡、婚姻，以及有关民事身份的变动等。从广义上说，生命统计活动可以概括为有关人口生命事件的原始登记、资料整理，以及统计和分析。

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

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

  • 第8题：

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

    使用set statistics io语句

    B

    使用set statistics time语句

    C

    使用set statistics CPU语句

    D

    使用set statistics time and CPU语句


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

  • 第9题：

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

  • 第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题：

    名词解释题
    产褥病率(puerperal morbidity)

    正确答案： 它是指分娩24小时以后的10日内，用口表每日测量体温4次，有2次≥38℃。
    解析： 暂无解析

  • 第13题：

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

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

    正确答案:D

  • 第14题：

    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

  • 第15题：

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

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

    正确答案:B

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

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

  • 第19题：

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

  • 第20题：

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


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

  • 第21题：

    单选题
    Which command sequence displays queue statistics for an interface?（）
    A

    monitor interface ge-0/0/0 queue

    B

    show interfaces queue ge-0/0/0

    C

    show interfaces ge-0/0/0 statistics extensive

    D

    show statistics queue detail


    正确答案： 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 job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for 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.


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

相关内容