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

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

1 A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）

點(diǎn)擊查看答案

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

點(diǎn)擊查看答案

3 How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END（）

點(diǎn)擊查看答案

4 Which of the following will begin a new unit of work?（）

點(diǎn)擊查看答案

5 Which of the following is a characteristic of a sequence?（）

點(diǎn)擊查看答案