db2 730 考试题库g 哪位大哥放上来

来源：百度知道 编辑：UC知道 时间：2024/07/04 13:16:28
Item 16 of 64 (B)
A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_sequence CACHE 10 ORDER
The following statements are successfully executed in sequence through separate database connections:
CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar
CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar
CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar
What is the current value of the :con1hvar host variable?
A. 2
B. 3
C. 11
D. 30

Item 2 of 64 (C)
Which of the following objects contains control structures that are considered
the bound form of SQL statements?
A. UDT
B. Trigger
C. Package
D. Access plan

Item 3 of 64 (C)
Which of the following resources can be explicitly locked?
A. Row
B. Page
C. Table
D. Column

Item 4 of 64 (A)
Which of the following describes how DB2 9 stores an XML document if the
XML Extender is not used?
A. CLOB
B. BLOB
C. Hierarchically
D. Rows and columns

Item 5 of 64 Mark item for review (D)
A stored procedure object is created into which DB2 object?
A. Alias
B. Schema
C. Package
D. Routine Space

Item 6 of 64 (B)
Application A issues the following SQL statements within in a single transact