C2090_612 questions • Exam prepare

Exam contains 131 questions

Page 17 of 22

Question 97 🔥

Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?

Which database solution meets these requirements?

A. Copy the index.

B. REBUILD the index.

C. Compress the tablespace.

D. ALTER the index to use a page size larger than 4K.

Discussion of the question

Question 98 🔥

Which of the following does NOT make a view a read-only view?

Which database solution meets these requirements?

A. The outer fullselect contains a GROUP BY clause.

B. The first SELECT clause specifies the keyword DISTINCT.

C. The only table referenced is a system maintained temporal table and a period-specification is specified.

D. Any FROM clause, after the first, identifies more than one table or view, or identifies a table function, a nested table expression, or a common table expression.

Discussion of the question

Question 99 🔥

A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?

Which database solution meets these requirements?

A. Specify the column names to be hashed.

B. Create a unique index on the hash columns.

C. Create a clustering index on the hash columns.

D. Create a unique clustering index on the hash columns.

Discussion of the question

Question 100 🔥

When modeling data to provide for a physical design, which of the following defines the data types for the columns in the DB2 physical table?

Which database solution meets these requirements?

A. Domain

B. Entities

C. Attributes

D. Primary Key

Discussion of the question

Question 101 🔥

A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?

Which database solution meets these requirements?

A. The data is only stored in the auxiliary table.

B. The data is only stored in the base table.

C. The complete data is stored both in auxiliary and in base table.

D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.

Discussion of the question

Question 102 🔥

Which statement about encoding schemes is correct?

Which database solution meets these requirements?

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.

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_612

Exam contains 131 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us