IBM(000-730)單項選擇題每日一練(2019.04.24)

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

1 Which of the following is a characteristic of a schema?（）

2 Given the following stored procedure:CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6), OUT p_sum DECIMAL(9,2) ) SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);How can this stored procedure be called from the Command Line Processor?（）

點擊查看答案

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（）

點擊查看答案

4 Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?（）

點擊查看答案

5 Which of the following actions may cause a trigger to be fired?（）

點擊查看答案