IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade 認定 C2090-546 試験問題:

1. Click on the Exhibit button Given the following DDL statements:


If COL2 contains XML documents similar to 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) A non-partitioned index will be created in the INDEX_TS table space for XML_INDEX.
C) 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 willautomatically be created within the first index partition listed in the create table statement.
D) TBSP11 and TBSP12 will each contain one local index for XML_INDEX since the local indexes will physically reside in the same table spaceas the related data.

2. Given the following DDL statements:

What is the end result of the CREATE UNIQUE INDEX statement?

A) TBSP21 will contain one index because NEW_IDX is not partitioned and will automatically go into the first index partition listed in the create table statement.
B) TBSP11 and TBSP12 will each contain one local index since the local indexes will physically reside in the same table space as the related data.
C) TBSP21 and TBSP22 will each contain one local index.
D) INDEX_TS will contain one non-partitioned index.

3. The SALES database was created without AUTOMATIC STORAGE. If the following command is executed: ALTER DATABASE sales ADD STORAGE ON '/db2fs1', '/db2fs2' What is the expected result?

A) The SALES database and all its table spaces are converted to AUTOMATIC STORAGE.
B) The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, existing table spaces need to be dropped and recreated.
C) The SALES database is converted to AUTOMATIC STORAGE and all its existing DMS table spaces are in rebalance pending state.
D) The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, ALTER TABLESPACE statement is needed to convert existing table spaces.

4. Which function/stored procedure CANNOT be used to view audit facility data?

A) SYSPROAUDIT_LIST_LOGS
B) SYSPROC.AUDIT_AUTH
C) SYSPROC.AUDIT_ARCHIVE
D) SYSPROC.AUDIT_DELIM_EXTRACT

5. You are creating a table with 1 LOB column. The size of the LOB column is less than the size of the LOB descriptor. When creating this table you did not specify an INLINE LENGTH. Which option is correct?

A) The ALTER TABLE .. INLINE LENGTH .. command is required so the LOB data can be included in the base table.
B) Only the LOB descriptor will be stored in base table and the LOB data will be stored in the LOB storage object.
C) Both the LOB descriptor and the LOB data will be stored in the base table.
D) Only the LOB data will be stored in the base table.

質問と回答：