C2090-312 Exam Questions

The new billing application is seeing Class 2 Elapsed Time being made up of mainly Class 3 Synchronous database I/O time. All of the DB2 objects for the new billing application are...

Which of the following types of SQL statements are NOT eligible to be stored in the dynamic SQL statement cache?

Which clone table statement is correct?

What is a potential consideration when using triggers?

Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?

You want to ALTER a table space specifying MAXPARTITIONS 256. For which table space type does the ALTER fail?

Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1 (COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following a...

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

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

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?

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

Which statement about encoding schemes is correct?

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

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

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?

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

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

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...

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

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

An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?

When these two commands are issued in sequence, one after the other: STOP FUNCTION SPECIFIC(A.B) ACTION(REJECT) STOP FUNCTION SPECIFIC(A.B) ACTION(QUEUE) What will occur?

Your current backup strategy is to run COPY SHRLEVEL CHANGE for all your table spaces each night. You create FULL image copies once a week and INCREMENTAL copies during the rest of...

What is the appropriate action to maintain data consistency if your page set is in REFP restrictive state?

DB2 workfiles are critical to performance of applications. Which of the following will NOT assist with achieving best performance for workfile usage?

Unnecessary REORGs of indexes may be avoided by which of the following?

Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or directory in new function mode?

The -DIS UTIL(REORGON) command was entered for a REORG utility with SHRLEVEL CHANGE with utilid REORGON. Which statement is NOT true?

Using the -SET LOG command, what logging characteristics CANNOT be modified?

In a data sharing environment, how is the LRSN value created?

What kind of information is stored in SYSIBM.SYSCOPY?

What is one of the first key steps in preparing to use the BACKUP SYSTEM utility?

An object (table space, index space or a physical partition of a table space or index space) is in AREST or RESTP status. If backout activity is not already underway, what should o...

When planning for disaster recovery, which two items are NOT required to send to the remote site? (Choose two.)

Which two parameters would reduce the impact of availability from a REORG with SHRLEVEL CHANGE for a partitioned table space with 16 parts? (Choose two.)

The application will be handling a large volume of input data that will need to be added to or update 4 different tables. On average, there will be 50 million input records daily....

Which option allows the UNLOAD utility to unload LOBs into output files together with non-LOB data?

Which of the following statements is NOT correct?

Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed th...

If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?

What IBM provided stored procedure will access DB2 real time statistics tables?

The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?

Which two of the following DB2 performance features will ignore clustering in favor of faster insert performance? (Choose two.)

What trace class will show deadlock information?

Which DSNZPARM will define the number of RID Blocks in the RID Pool?

When DB2 detects at runtime requiring a large amount of data to be read, which prefetch method is used more often?

In order to retain an access path across a rebind which of the following commands could be used?

How do you enable parallelism in a dynamic SQL statement?

Which DB2 trace has potentially the highest level of overhead, and should typically be run in specific situations and only for short durations?

When is changing an index from non-clustering to clustering NOT allowed?