C2090-312 Exam Questions

Which statement is true?

You must be able to process recoveries for DB2 objects to any point in time between now and two weeks ago. What is the recommended amount of recovery data needed?

Which type of stored procedures do NOT require a WLM-managed stored procedure address space?

When we use multilevel-security using a security label column, which sentence is true?

Arrays are based on a built-in data type. On which built-in data type can an array NOT be based?

Index versions are created when certain schema changes are committed. Which schema change results in a new index version being created?

Which statement is true if a table space is created using the "FOR UPDATE nn" (where nn is a number) clause?

The data of a critical table space seems inconsistent. It is suspected that someone has accidentally issued a DB2 command to start the object with MODE(FORCE). Where can this be ve...

Given this statement: RUNSTATS TABLESPACE DB1 TS1 RESET ACCESSPATH HISTORY ACCESSPATH Which statement is FALSE?

What is the least disruptive way of externalizing real-time statistics for table space DB1TS1 ?

Which statement is true for data in columns defined with data type XML?

Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?

When performing several inserts into a table defined with an identity column, which attribute could be ALTERed to help with the performance?

Which DB2 Client command can be used to identify the Client's version?

What is the minimum buffer pool page size for a compressed index?

What can you accomplish with the stored procedure ADMIN_UTL_MONITOR?

Which DB2 subsystem parameter is used to control the number of concurrent inbound DDF connections?

As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalize...

Prefetch l/Os are executed under a service request block in which address space?

A hotel prices its rooms differently at different times of the year. For example, Room 101 rents for $100 per night January through March, $150 per night April through September, a...

If the OPTHINTS subsystem parameter is set to YES, and you issue the following DB2 command relating to optimization parameter hints: BIND QUERY LOOKUP (YES) what is the result of t...

What is necessary in order to enable optimization hints?

Which command populates the EXPLAIN tables but does not create a package?

The TCP/IP Already Verified (TCPALVER) DB2 system parameter controls whether DB2 accepts a TCP/IP connection requests. Which statement is NOT a valid value?

Which global variables statement is true?

Which DB2 subsystem parameter limits the number of concurrent active TSO requests?

Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?

An Audit report shows that data on the CUSTOMER table was successfully updated by an unknown USERID. What other DB2 supplied information could be reviewed to learn more about the u...

You want to create a table space without actually creating the underlying data sets until rows are inserted into the corresponding table. Which CREATE TABLESPACE statement option a...

Which component is NOT shared between DB2 data sharing members?

You are having problems accessing SYSIBM.SYSTABLES in your data sharing environment and you want to know who is using the table space DSNDB06.SYSTSTAB. How would you find this info...

When would DB2 NOT use list prefetch?

Which DB2-supplied stored procedure captures statistics and DDL for DB2 objects, extracts subsystem parameters and explain information for queries and applications, and returns the...

What is required before you begin your installation of DB2 11 ?

Which SQL statement can be used to create a data type that will represent possible speed limit values, with valid values not greater than 99, and to create a table that contains ro...

When defining a check constraint on a populated table and the value of the special register CURRENT RULES is 'DB2'. What is the result of executing the DDL statement?

Which is NOT a valid privilege/authority for executing CREATE TYPE (array)?

You want to determine which objects of your database DB1 are in LPL. What command should be used?

An application receives an 00C90110 reason code. See the following manual explanation of the code. " 00C90110Explanation:The data manager detected an inconsistent data condition. T...

Which type of column can be dropped from a table via the ALTER TABLE ... DROP COLUMN ... SQL statement?

Which address space should be classified with the highest priority WLM service class?