《IBM DB2 97 Database Administrator for Linux UNIX or Windows Upgrade 000-546题库》.pdf

IBM 000-546 DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Practice Test Version: 14.20 买题库 QQ:860424807 IBM 000-546: Practice Exam QUESTION NO: 1 Click on the Exhibit button Given the following DDL statements: If COL2 contains XML documents similar to the one shown in the scenario, what is the end result of the CREATE INDEX statement? A. An error will be returned because it is not possible to create an index for an XML column like COL2. B. TBSP11 and TBSP12 will each contain one local index for XML_INDEX since the local indexes will physically reside in the same table space as the related data. C. An error will be returned because it is not possible to include more than one column as part of the CREATE INDEX statement when one of the columns is of type XML. D. A non-partitioned index will be created in table space TBSP21 since the INDEX IN clause of the table definition is ignored and XML_INDEX will automatically be created within the first index partition listed in the create table statement. 买题库 QQ:860424807 2 IBM 000-546: Practice Exam Answer: C Explanation: QUESTION NO: 2 When storing XML data in a DB2 database, which statement is valid? A. A table with an XML column can be defined in a non-Unicode database. B. A table with an XML column can only be defined in a Unicode database. C. A table with an XML column can be defined in a non-Unicode database but the table containing the XML column will be stored in Unicode. D. A table with an XML column can be defined in a non-Unicode database but the database must be converted to Unicode before the XML columns can be used. Answer: A Explanation: QUESTION NO: 3 If table TAB_A is created as follows: Assuming the cardinalit