IBM(000-730)单项选择题每日一练(2019.01.19)

单项选择题
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
单项选择题
For which of the following is a data warehouse optimized?（）
A.Backup and recovery
B.Transactions
C.Security
D.Queries
单项选择题
Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?（）
A.DB2 Express Edition
B.DB2 Personal Edition
C.DB2 Workgroup Server Edition
D.DB2 Enterprise Server Edition
单项选择题
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）
A.View
B.Alias
C.Table
D.Package
单项选择题
Which of the following describes the objects of a DB2 database and their relationships?（）
A.Instance
B.Table space
C.System catalog
D.Schema repository