C2090-312 Sample Questions Answers

A list of queries that are in error is produced.

Updated values are placed in SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.

New values are inserted into the SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.

Messages containing only the status of rows in catalog tables SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN.

Static SQL statements only.

Dynamic SQL statements only.

Both static and dynamic SQL statements.

Statements included in a CREATE PROCEDURE statement only.

At least 20 rows fit on a data page.

DB2 uses range scans to access rows in the table.

The size of individual rows in the table vary greatly.

DB2 uses sequential lookups to access data in the table.

External stored procedures.

Native SQL stored procedure.

External SQL stored procedures.

DB2 supplied stored procedures.

SYSIBM.SYSGUERYSEL

SYSIBM.SYSTATFEEDBACK

SYSIBM.SYSVARIABLES_TEXT

SYSIBM.SYSOUERYPREDICATE

IDTHTOIN

MAXDBAT

CONDBAT

MAXCONQN

Issue the ALTER INDEX REGENERATE statement.

Use the ALTER INDEX statement to add a column to an index that was built with DEFINE NO.

Add a new column to both a table and an index in the same commit operation when the table is in a partition-by-growth table space and the index is built with DEFINE YES.

When you extend the length of a varying-length character (VARCHAR data type) or varying-length graphic (VARGRAPHIC data type) column that is contained in one or more indexes that are defined with the NOT PADDED option.