单选题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?（）

MQT

Trigger

Read Only Cursor

Stored Procedure

参考答案和解析

正确答案： A

解析：暂无解析

更多“单选题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题

A stored procedure object is created into which DB2 object?（）A、AliasB、SchemaC、PackageD、Routine Space

点击查看答案
第2题

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

点击查看答案
第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 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.

点击查看答案
第5题

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.

点击查看答案
第6题

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.

点击查看答案
第7题

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 tablesB、view segmentC、table segmentD、data dictionaryE、object segmentF、performance tables

点击查看答案

IBM(000-730)

单选题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 MQTB TriggerC Read Only CursorD Stored Procedure”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容