C2090-312 Exam Questions

To monitor the storage used above and below the 2GB bar, what must occur?

The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired. T...

When specifying "A" for the acceptance option in the column SECURITY_IN in the SYSIBM.LUNAMES catalog table, which statement is correct?

What is the maximum levels of backup that DB2 plan stability can support?

The access path chosen for a query shows a table space scan, when it appears that there is an index available that would provide a more efficient access path. What situation could...

What must be in place for the support of index compression?

You have been asked to find packages that use isolation level UR in dynamic SQL. Which trace will be utilized?

Which of the following techniques CANNOT be used to implement DB2 based row level authorization in a read-only environment for a specific table?

Which privilege allows the execution of the EXPLAIN STMTCACHE ALL SQL statement?

What must be done in order to audit read access to a table?

Which minimum system privilege allows you to create a trusted context?

If security administration is separated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?

Which DSNZPARM parameter controls the number of locks that may be acquired on a table space?

DB2 10 is in enabling-new-function mode* after migrating from Version 8, which statement is correct?

In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution from one DB2 member to another, which coupling facility structure is used?

The billing application has a DB2 referential integrity set of three tables. TABA, TABB and TABC. Daily, Full Image copies are done for the three table spaces related to the three...

Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?

In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)

Poorly tuned memory can affect application performance, such as having sequential prefetch turned off. Which statistic should you monitor from the statistics report to be sure this...

In order to properly monitor locks on a continual basis, which action should be performed but will avoid using excessive CPU resources to gather the information?

The I/O patterns for objects in database NEWBILL need to be reviewed in detail. All of the NEWBILL work runs under a single plan, NEWBILLPL. What START TRACE command should be used...

Which of the items listed below is NOT a prerequisite for using CURRENT EXPLAIN MODE?

When determining what page size will be best for index compression, which utility can be used to provide information on space saved and potential buffer space wasted for each of th...

Which DB2 performance feature is designed specifically to reduce the number of indexes that need to be created?

A table space is successfully recovered by using RECOVER TABLESPACE db.ts TOLASTFULLCOPY. This table space is referenced by an index. Which statement is true?

What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G?

Which statement regarding triggers is true?

What is a general recommendation for when to rebind?

A statement-level access path hint can be applied to which type of SQL statement?

What does the UNLOAD utility allow you to unload?

Which statement about an array data type is true?

The degree of parallelism can vary for the REBUILD INDEX utility. What action should be taken to limit the use of real memory using the REBUILD INDEX utility?

Which is NOT a valid value for the KEYWORDS column in the DSN_PROFILES_ATTRIBUTES table?

What keyword establishes the maximum partition size of a partition-by-growth universal table space?

Which table characteristic is a good attribute for the exploitation of hash access?

What subsystem parameter in DDF specifies the maximum number of inactive or new connections queued that can be waiting for a DBAT to process the request?

From where does the cross-loader function allow you to load data?

Which technique can be utilized for the reporting of real-time statistics?

You are trying to reduce the transaction CPU cost by using KEEPDYNAMIC(YES). Which subsystem parameter would you increase to improve Local Dynamic Cache Hit Ratio and reduce the nu...

DB2 will not allow certain processing to occur when the soft limit of RBA TFF800000000'x is reached and an object's RBA remains in basic 6-byte format. What processing is NEVER all...

You have defined the array type PHONENUMBERS using the following DDL: CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50]; You also defined a variable named RECENT_CALLS based on t...

Which group of DB2 ACCOUNTING trace CLASSES must be started to collect accounting information for PLANS and PACKAGES?

What catalog table provides the information about missing or conflicting catalog statistics for SQL statements?

In order to use a literal replacement for a dynamic SQL caching statement what must be true about the statement?

Consider a logical data model that includes an Employees entity and a Projects entity. In this model, employees work on many projects and projects are worked on by many employees....

Given the following output: DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS - DSNV402I _DB2D ACTIVE THREADS - NAME ST A REQ ID AUTHID PLAN ASID TOKEN DB2CALL T 17039 BBISS BBISS 00AF...

DB2 AUDIT policies are defined by inserting rows into what DB2 Catalog table?

You analyze an accounting report. You see a high "NOT ACCOUNTED" time. Which two events can contribute to this high value?

You want to convert a segmented table space into a partition-by-growth table space. You execute the following ALTER statement: ALTER TABLESPACE DB1TS1 MAXPARTITIONS 5; What should...

Which statement is true regarding table-controlled partitioned table spaces without a MAXVALUE specified?