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

單項(xiàng)選擇題
Which of the following is a characteristic of a schema?（）
A.Foreign key references cannot cross schema boundaries.
B.A DB2 user must be created before a schema with the same name can be created.
C.If no schema is specified when an object is created, the default schema PUBLIC is used.
D.A schema enables the creation of multiple objects in a database without encountering namespace collisions.
單項(xiàng)選擇題
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?（）
A.CALL increase_salary('A00')
B.VALUES increase_salary('A00')
C.CALL increase_salary('A00', ?)
D.VALUES increase_salary('A00', ?)
單項(xiàng)選擇題
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（）
A.CALL getratews11('USA','CANADA')
B.CALL expenses.getratews11('USA','CANADA')
C.SELECT getratews11('USA','CANADA') FROM expenses
D.SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency
單項(xiàng)選擇題
Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?（）
A.Journal
B.Task Center
C.Control Center
D.Activity Monitor
單項(xiàng)選擇題
Which of the following actions may cause a trigger to be fired?（）
A.DROP
B.ALTER
C.DELETE
D.ROLLBACK