DB2（计算机初级资格程序员基础知识考试卷）.docVIP

试卷第 PAGE 1 页共 NUMPAGES 1 页 DB2（计算机初级资格程序员基础知识考试卷） 姓名:_____________ 年级:____________ 学号:______________ 题型 选择题 填空题 解答题 判断题 计算题 附加题 总分 得分 评卷人 得分 DB2qjyjyp第 1 题 If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database? A 4 B 8 C 16 D 32第 2 题 Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used? A ALTER TABLE sales ADD COLUMN item CHAR(40); B ALTER TABLE sales ALTER COLUMN item CHAR(40); C ALTER TABLE sales MODIFY COLUMN item CHAR(40); D ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);第 3 题 Which DB2 object can be used to improve the execution performance of qualified SELECT statements? A Trigger B SQL Procedure C Sequence Object D Materialized Query Table第 4 题 When is it appropriate to use a sequence? A When you want to control the order in which triggers are fired. B When you want to control the order in which stored procedures can be invoked. C When you want to automatically generate a numeric value that is not tied to any specific column ortable. D When you want to automatically generate a numeric value for each row that is added to a specifictable.第 5 题 Which clause should be included in a ALTER TABLE statement to update a table definition with a newcolumn? A ADD COLUMN B ALTER COLUMN C APPEND COLUMN D RENAME COLUMN第 6 题 Which object is a stored procedure defined into? A Table B Schema C Package D Database第 7 题 Which action needs to be performed in order to complete the definition of an application-period temporaltable? A A transaction-start-id column must be defined for the table. B A history table must be defined and associated with the base table. C A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table. D A unique