IBM(000-730)單項(xiàng)選擇題每日一練(2019.01.23)

來源：考試資料網(wǎng)

1 A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 & User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?（）

點(diǎn)擊查看答案

2 Given the following tables: CONTINENTS ID NAME COUNTRIES
1 Antarctica 0
2 Africa 53
3 Asia 47
4 Australia 14
5 Europe 43
6 North America 23
7 South America 12
REGION ID LOCATION 1 East 2 West
How many rows would be returned using the following statement? SELECT location FROM continents, region（）

點(diǎn)擊查看答案

3 Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）

點(diǎn)擊查看答案

4 Given the following two tables:
TAB1 C1 C2
A 11 B 12 C 13 TAB2 CX CY
A 21 C 22 D 23
The following results are desired:
C1 C2 CX CY
A 11 A 21 C 13 C 22 -- --D 23
Which of the following queries will yield the desired results?（）

點(diǎn)擊查看答案

5 Which of the following is the main feature of an OLTP application?（）

點(diǎn)擊查看答案

广告位招租联系QQ:5245112（WX同号）