单选题Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）A MQTB TriggerC Read Only CursorD Stored Procedure

题目
单选题
Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）
A

MQT

B

Trigger

C

Read Only Cursor

D

Stored Procedure

相似考题

1.Which statements are true regarding the Query Result Cache? ()A. It can be set at the system, session, or table level.B. It is used only across statements in the same session.C. It can store the results from normal as well as flashback queries.D. It can store the results of queries based on normal, temporary, and dictionary tables.

2.A stored procedure object is created into which DB2 object?()A.AliasB.SchemaC.PackageD.Routine Space

3.Which of the following statements is mot correct about mirroring?()A.Mirroring, with the write-verify option turned on, can be used to increase performance.B.Mirroring is a better choice that disk-striping, for large sequential-access file system when one is looking for performance.C.Mirroring, with a parallel-scheduling policy, may improve I/O read-operation performance.D.Mirroring, with maximum inter-disk allocation policy, is used to enhance availability.

4.Which of the following database objects can be used to raise an error if a table is updated?()A.PackageB.TriggerC.Stored ProcedureD.Informational Constraint

更多“单选题Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）A MQTB TriggerC Read Only CursorD Stored Procedure”相关问题

  • 第1题：

    Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）

    • A、MQT
    • B、Trigger
    • C、Read Only Cursor
    • D、Stored Procedure

    正确答案:A

  • 第2题：

    The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）

    • A、database table 
    • B、transactional trigger 
    • C、stored procedure 
    • D、FROM clause query 
    • E、client-side procedure

    正确答案:D

  • 第3题：

    Which of the following database objects can be used to raise an error if a table is updated?（）

    • A、Package
    • B、Trigger
    • C、Stored Procedure
    • D、Informational Constraint

    正确答案:B

  • 第4题：

    Which the two are true about the JSTL core iteration custom tags？（）

    • A、 It may iterate over arrays， collections， maps and strings.
    • B、 The body of the tag may contain EL code， but not scripting code.
    • C、 When looping over collections， a loop status object may be used in the tag body.
    • D、 It may iterate over a map， but only the key of the mapping may be used in the tag body.
    • E、 When looping over integers （for example begin1=’1’ end=’10’）， a loop status object may not be used in the tag body.

    正确答案:A,C

  • 第5题：

    The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）

    • A、Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 
    • B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
    • C、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 
    • D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. 
    • E、Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 
    • F、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.

    正确答案:F

  • 第6题：

    Which two PL/SQL8 features are supported in Oracle Forms?（）

    • A、methods 
    • B、object tables 
    • C、object columns 
    • D、collection types 
    • E、object as stored procedure parameters

    正确答案:B,C

  • 第7题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）  

    • A、You should configure the database for Read Committed Snapshot isolation. 
    • B、You should modify the stored procedure to use the Snapshot isolation level 
    • C、You should configure the database for Auto Update Statistics asynchronously 
    • D、You should modify the stored procedure to use the Repeatable Read isolation level

    正确答案:B

  • 第8题：

    单选题
    You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）
    A

    Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 

    C

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. 

    E

    Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.


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

  • 第9题：

    多选题
    Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）
    A

    You can find information about only active transactions from the view

    B

    You can find information about read only transactions from the view

    C

    You require the SELECT ANY TRANSACTION system privilege to access the view

    D

    You can find information about both active and committed transactions from the view

    E

    You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view


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

  • 第10题：

    单选题
    You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）
    A

    Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 

    C

    Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 

    E

    Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.


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

  • 第11题：

    单选题
    Which is an example of a dynamic SELECT statement? （）
    A

    A query whose object names change during its execution. 

    B

    A query whose object names are not known until run time. 

    C

    A query whose bind variables values change during execution. 

    D

    A query whose bind variable values are not known until run time.


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

  • 第12题：

    多选题
    Which statements are true regarding the Query Result Cache？（）
    A

    It can be set at the system， session， or table level.

    B

    It is used only across statements in the same session.

    C

    It can store the results from normal as well as flashback queries.

    D

    It can store the results of queries based on normal，temporary，and dictionary tables.


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

  • 第13题：

    You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）

    • A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
    • B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
    • C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
    • D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
    • E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

    正确答案:E

  • 第14题：

    A stored procedure object is created into which DB2 object?（）

    • A、Alias
    • B、Schema
    • C、Package
    • D、Routine Space

    正确答案:B

  • 第15题：

    Which of the following statements is mot correct about mirroring?（）

    • A、Mirroring, with the write-verify option turned on, can be used to increase performance.
    • B、Mirroring is a better choice that disk-striping, for large sequential-access file system when one is looking for performance.
    • C、Mirroring, with a parallel-scheduling policy, may improve I/O read-operation performance.
    • D、Mirroring, with maximum inter-disk allocation policy, is used to enhance availability.

    正确答案:C

  • 第16题：

    Which statements are true regarding the Query Result Cache？（） 

    • A、 It can be set at the system， session， or table level.
    • B、 It is used only across statements in the same session.
    • C、 It can store the results from normal as well as flashback queries.
    • D、 It can store the results of queries based on normal，temporary，and dictionary tables.

    正确答案:A,C

  • 第17题：

    The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.

    • A、user tables
    • B、view segment
    • C、table segment
    • D、data dictionary
    • E、object segment
    • F、performance tables

    正确答案:D

  • 第18题：

    Which is an example of a dynamic SELECT statement? （）

    • A、A query whose object names change during its execution. 
    • B、A query whose object names are not known until run time. 
    • C、A query whose bind variables values change during execution. 
    • D、A query whose bind variable values are not known until run time.

    正确答案:B

  • 第19题：

    单选题
    The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）
    A

    Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 

    C

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. 

    E

    Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 

    F

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.


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

  • 第20题：

    单选题
    A stored procedure object is created into which DB2 object?（）
    A

    Alias

    B

    Schema

    C

    Package

    D

    Routine Space


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

  • 第21题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）
    A

    You should configure the database for Read Committed Snapshot isolation. 

    B

    You should modify the stored procedure to use the Snapshot isolation level 

    C

    You should configure the database for Auto Update Statistics asynchronously 

    D

    You should modify the stored procedure to use the Repeatable Read isolation level


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

  • 第22题：

    单选题
    Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
    A

     The VERSIONS BETWEEN clause may be used in DML statements.

    B

     The VERSIONS BETWEEN clause may be used in DDL statements.

    C

     The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

    D

     The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.


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

  • 第23题：

    单选题
    Which of the following statements is mot correct about mirroring?（）
    A

    Mirroring, with the write-verify option turned on, can be used to increase performance.

    B

    Mirroring is a better choice that disk-striping, for large sequential-access file system when one is looking for performance.

    C

    Mirroring, with a parallel-scheduling policy, may improve I/O read-operation performance.

    D

    Mirroring, with maximum inter-disk allocation policy, is used to enhance availability.


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

相关内容