DB2302认证考题真题及参考答案 全.docx

1、DB2302认证考题真题及参考答案 全1. Which of the following options best describes a domain found in the table below?从下表中，哪一选项正确的描述了domain CREATE TABLE EMPLOYEE (ID INTEGER NOT NULL,NAME VARCHAR(30) NOT NULL,EXTENSION INTEGER NOT NULL,MANAGER VARCHAR(30) NOT NULL PRIMARY KEY (ID); TERMINATE; ID NAME EXTENSION MANA

2、GER1 John S 53412 Y2 Susan P 54123 N3 Jennifer L 51234 NA. Manager Domain = (N)B. Name Domain = (Set of all Possible Names)C. Extension Doman = (53412)D. ID Domain = (1, 2, 3)答案：B2. Which of the following statements best describes the XML Regions Index in DB2?下列哪个陈述最好的描述了DB2中的XML区域索引?A. The Regions

3、Index is a descriptor for referencing large objects in the LOB storage area.B. The Regions Index is a new type of XML index available in DB2 9.7.C. The Regions Index facilitates access to document regions in the XML data area.区域索引，有助于文档区域中的XML数据区的访问D. The Regions Index can be compressed by issuing a

4、n offline reorg operation on the table.答案：C3. What is the purpose of a DB2 Access Plan?什么是一个DB2访问计划的目的?A. SQL developers can define Access Plans to tell DB2 the best way to retrieve the data from a SQL queryB. Describes the order of operations to access data necessary to execute a SQL or XQuery stat

5、ement 描述运算次序，访问必要的数据 去执行 SQL或者XQuery的语句C. To replicate data between a DB2 database and relational databases from other vendorsD. To visually construct complex DML statements and examine the results of their execution答案：B4. Given the following UPDATE statement:UPDATE employees SET workdept = (SELECT

6、deptno FROM department WHERE deptno = A01) WHERE workdept IS NULL Which of the following describes the result if this statement is executed?如果上面的语句被执行，下面哪一个选项是正确的？A. The statement will fail because an UPDATE statement cannot contain a subqueryB. The statement will only succeed if the data retrieved

7、by the subquery does not contain multiple records 语句可能成功如果数据恢复在子查询不能容纳过多的记录那之前C. The statement will succeed; if the data retrieved by the subquery contains multiple records, only the first record will be used to perform the updateD. The statement will only succeed if every record in the EMPLOYEES ta

8、ble has a null value in the WORKDEPT column答案：B5. Given the following two tables: NAMES-NAME NUMBER- -Wayne Gretzky 99Jaromir Jagr 68Bobby Orr 4Bobby Hull 23Mario Lemieux 66 POINTS-NAME POINTS- -Wayne Gretzky 244Bobby Orr 129Brett Hull 121Mario Lemieux 189Joe Sakic 94 How many rows would be returned

9、 using the following statement? 在下面这个语句中有多少行会被返回? SELECT * FROM names, pointsA. 0B. 5C. 10D. 25答案：D6. What is SQL/XML? 什么是SQL/XML？A. SQL/XML is a communication protocol for DB2 databases.B. A.SQL/XML is part of the XQuery standard and provides various publishing functions to transform XML data into

10、relational form and vice versa.C. SQL/XML is a language that provides various publishing functions to transform XML data into relational form and vice versa.D. SQL/XML is an extension to SQL standard and provides various publishing functions to transform XML data into relational form and vice versa.

11、SQL/XML 是延伸 SQL 标准和提供各种功能来转换 XML 数据相关性，反之亦然答案：D7. Which of the following is NOT part of the XQuery FLOWR expression?下面那个选项不是部分 XQuery FLOWR 的表述?A. FOR clauseB. LET clauseC. ORDER BY clauseD. WITH clause答案：D8. Given the following table: 根据下面的表： TAB1-COL1 COL2- -A 10B 20C 30A 10D 40C 30 Assuming the f

12、ollowing results are desired: 假设需要以下结果: TAB1-COL1 COL2- -A 10B 20C 30D 40 Which of the following statements will produce the desired results?下面的语句将产生预期的效果吗？A. SELECT UNIQUE * FROM tab1B. SELECT DISTINCT * FROM tab1C. SELECT UNIQUE(*) FROM tab1D. SELECT DISTINCT(*) FROM tab1答案：B9. Considering the SQL

13、 statement below, which option best describes what APP.TAX is:考虑下面的SQL语句，最能说明APP.TAX的选项是：SELECT APP.TAX(SALARY) FROM EMPLOYEEA. User Defined Function 自定义函数B. Stored ProcedureC. TriggerD. User Defined Type答案：A10. Which of the following is NOT true about the Information Model?以下不正确的信息模型是?A. Abstract m

14、anagement of objects at a conceptual level.B. Defines relationships between managed objects.C. Group of descriptions explaining objects of a data model.组的描述信息说明的数据模型对象。D. Data models can be used to map an Information Model to a software implementation.答案：C11. Consider the following XML document: 考虑下

15、面的XML文档: John Smith Fourth Calgary Alberta M1T 2A9 963-289-4136 Consider the following UPDATE expression:update xmlcustomerset info = xmlquery( transform copy $new := $i modify ( do insert 777-555-3333 after $new/customerinfo/addr, for $j in $new/customerinfo/addr/phone return do rename $j as teleph

16、one ) return $new passing info as i)where cid = 1000; Which of the following represents the XML document after the TRANSFORM expression has been executed: 下列哪个代表了XML在文档转换表达式之前已经被执行:A. John Smith Fourth Calgary Alberta M1T 2A9 777-555-3333 963-289-4136 B. John Smith Fourth Calgary Alberta M1T 2A9 777

17、-555-3333 963-289-4136 C. John Smith Fourth Calgary Alberta M1T 2A9 777-555-3333 963-289-4136 D. John Smith Fourth Calgary Alberta M1T 2A9 777-555-3333 963-289-4136 答案：A12. Which of the following properties is related to the fact that a committed transaction guarantees that all of the operations are

18、 completed and in a roll backed transaction the effect of all operations are reverted?下列哪个属性是关系到一个提交的事务保证所有的操作都完成了,在一个事务回滚的影响的操作都是恢复?A. ConsistencyB. Atomicity 原子性C. IsolationD. Durability答案：B13. Which of the following is the lowest cost DB2 product that can be legally installed on a windows server

19、that has 4 CPUs capable of performing row compression?下列哪项是的成本最低的，DB2产品可以合法地安装在有四个CPU的Windows服务器上能够执行压缩？A. DB2 Express EditionB. DB2 Workgroup EditionC. DB2 Express-C EditionD. DB2 Enterprise Edition答案：A14. Application B wants to read a subset of rows from table EMPLOYEE multiple times inside the sa

20、me transaction.Which isolation level should be used in order to guarantee that every time the same set of rows is returned?应用程序B想多次读取表EMPLOYEE其中的一个子集中的几行数据。应该使用隔离级别，以保证每次返回的结果都是一样的？A. Currently CommittedB. Read StabilityC. Repeatable Read 可重复读D. Uncommitted Read答案：C15. How does automatic storage wor

21、k in DB2?在DB2中如何进行自动存储工作？A. Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data, and where the database manager allocates space for various uses.在允许指定存储路径中自动存储简化了存储管理, 数据库管理器可以放置表空间数据同时数据库管理器为各种用途分配空间。B. Autom

22、atic storage is an option which is set when you create a DB2 database. It allows transactions that are written to the database to be automatically committed.C. Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule.D. Automatic Storage can be used t

23、o automatically reorganize the data on the physical media in order to improve performance.答案：A16. Which of the following DB2 client/driver packages is NOT suitable for developing ODBC applications?下列哪个DB2客户机/驱动程序包是不适合开发ODBC应用程序?A. IBM Data Server ClientB. IBM Data Server Driver for ODBC and CLIC. IB

24、M Data Server Runtime Client IBM数据服务器运行时客户端D. IBM Data Server Driver Package答案：C17. In embedded SQL code, which of the following is true about delimiters?在嵌入式SQL代码,关于分隔符哪项是正确的?A. Used by the OS to delimit system variable declaration.B. Used by the database to indicate the end of a column.C. Used by

25、compiler to indicate the end of the program.D. Used by PRECOMPILER to identify SQL statements to be translated.使用预编译程序来识别被翻译的SQL语句答案：D18. What is a Trusted Context?什么是受信任上下文？A. It is a special area in a buffer pool that can be written only by a selected set of users.B. It is a DB2 capability that al

26、lows applications to change users without breaking the connection to the database.这是一个DB2功能,允许应用程序改变用户在没有打破了到数据库的连接。C. It is a DB2 capability that allows users to establish a connection to the database without providing user name or password.D. It is a type of container in a table space that allows

27、faster I/O operations.答案：B19. Given the options below, which of the following statements can add records to a table?在下面的选项中，哪个语句可以将记录添加到表中？A. ADDRECB. ADDRECORDC. INSERTD. ADD答案：C20. You were assigned the task of importing a large amount of data into a DB2 database. Considering you must have logged information about the rows imported and that you want to perform the load as fast as possible, which of the tools would you be the best choice for the job?你被分配的任务