IBM IBM Certified Database Administrator C2090-612 Questions & Answers

• Question 21:

  Altering the DSSIZE is allowed for what type of table space?

  A. XML table space.

  B. Universal table space.

  C. Segmented table space.

  D. DSSIZE cannot be altered.

  Correct Answer: B

• Question 22:

  What is the one significant difference between sequence objects and identity columns?

  A. Identity columns can cache values and sequence objects cannot.

  B. Identity columns can be defined on tables and sequence objects cannot.

  C. Sequence objects can have a character data type and identity columns cannot.

  D. Sequence object values can be used as primary keys and identity column values cannot.

  Correct Answer: B

• Question 23:

  Click on the exhibit to view properly coded XML data. Some employees have been assigned assistants. Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of employees who are not assistants?

  A. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);

  B. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/phone' as sql varchar(20);

  C. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info)

  GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);

  D. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/employee/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/employee/phone' as sql varchar(20);

  Correct Answer: D

• Question 24:

  Which of the following tasks cannot be done via a single ALTER TABLE statement?

  A. Add a new partition to the table space.

  B. Change the VALIDPROC attribute of the table.

  C. Change a table check constraint on the table.

  D. Change the DATA CAPTURE attribute of the table.

  Correct Answer: C

• Question 25:

  Which of the following types of table spaces allow multiple tables?

  A. Segmented

  B. LOB table space

  C. Partition-by-range

  D. Partition-by-growth

  Correct Answer: A

• Question 26:

  Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?

  A. Issue ALTER TABLESPACE with a valid SEGSIZE > 0

  B. Make the table space table-partitioned, then issue ALTER TABLESPACE with a valid SEGSIZE > 0

  C. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, then issue ALTER TABLESPACE with a valid SEGSIZE > 0

  D. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, create a partitioned index and issue ALTER TABLESPACE with a valid SEGSIZE > 0

  Correct Answer: B

• Question 27:

  For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?

  A. Catalog tables

  B. Directory tables

  C. Auxiliary tables

  D. Declared global temporary tables

  Correct Answer: A

• Question 28:

  In which situation does adding a referential constraint place a table space containing data into check-pending status?

  A. When a primary key is defined on a table with no unique index.

  B. When a foreign key is defined on a table with the ENFORCED option.

  C. When a foreign key is defined on a table and a corresponding primary key has not been defined.

  D. When a foreign key is defined on a table with NOT ENFORCED option and a unique index has not been defined.

  Correct Answer: B

• Question 29:

  Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3, BUSINESS_TIME WITHOUT_OVERLAPS);

  A. The index must be partitioned.

  B. The index must use page size > 4K.

  C. The index must be defined as UNIQUE.

  D. The index must be defined as CLUSTER.

  Correct Answer: C

• Question 30:

  Which statement about encoding schemes is correct?

  A. A view can have columns with different encoding schemes.

  B. A table can have columns with different encoding schemes.

  C. A table space can have tables with different encoding schemes.

  D. All objects in the subsystem must use the same encoding schemes.

  Correct Answer: A