C2090-312 Exam Questions

The available window to reorganize table spaces is being reduced. What data can provide information to allow for a priority list of candidate table spaces for reorganization based...

Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?

What is a consideration when specifying DATA CAPTURE CHANGES?

What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?

What START TRACE command provides detailed lock suspend and lock contention trace information?

When converting a multiple table segmented table space to partition-by-growth table spaces, which statement is correct?

What would be a reason for altering the clustering index of a table?

What is the DSNZPARM that determines the maximum amount of temporary storage in the work file data base for a single user at any given time?

In the CFRM policy, what is the purpose of the PREFLIST?

What DB2 command when issued displays what migration mode the catalog is in?

Which authority level allows a user to run utilities that change the data in an application database?

Which trace gives information about frequent log space shortages?

When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure, what value must the SECURITY clause specif...

Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

Which connection type can exploit trusted connections?

What should be implemented in order to audit all the activity of the install SYSADM?

Which attribute(s) determine the absolute maximum number of partitions for a partition-by-growth table space?

Which ALTER TABLE statement will generate a new table space version?

Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Wh...

When defining a foreign key on a table, which statement is true?

If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?

On what type of index would an ALTER INDEX ADD COLUMN be allowed?

In a normalized design, in third normal form, the entity defined in the logical design is often transformed in the physical design to which of the following?

If SEGSIZE 64 and MAXPARTITIONS 10 are specified in a CREATE TABLESPACE statement, what type of table space is created?

A single table should allow for up to 100 Terabytes of application data. How do you design your table space?

When a table space defined as both partitioned-by-growth (PBG) and MEMBER CLUSTER YES is altered to MEMBER CLUSTER NO by the ALTER TABLESPACE command. Which statement is correct?

Given the following statements have been run successfully and the buffer pools BP1 and BP2 both have the same page size: CREATE TABLESPACE TS1 IN DB1 DEFINE YES BUFFERPOOL BP1 MAXP...

The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received: 1111 AAAA Which statement is true?

The following DDL statements are executed to create the following objects: CREATE TABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1 INTEGER, COL2 VARCHAR(10) ) IN...

A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal acc...

Which stored procedures need to be set up properly in order to register an XML schema?

You have to design a table and application layout, in which automatic number generation is used. The application also wants to assign database generated numbers in an SQL UPDATE st...

Given the following view definition: CREATE VIEW EMPD AS (SELECT D.DEPTNAME, E.LASTNAME FROM DEPT D INNER JOIN EMP E ON D.DEPTNO = E.WORKDEPT); Can an UPDATE statement be used to u...

Which statement is true about table check constraints?

You have to design a numeric column, which is also the primary key. The column should cover large (i.e., 123456789012345678) numbers. Which column data definition covers the requir...

The threads initiated by the distributed transactions are no longer active in DB2, however this situation has caused -904 resource unavailable condition for the other executing thr...

Which DB2 online utility job output provides you with information about the BACKUP SYSTEM history?

Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following actions removes the copy pending state AND creates an entry in SYSIBM.SYSCOPY?

During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?

When planning for backup/recovery (including disaster recovery), which statement is correct?

You take image copies of your table spaces every night. Since you cannot afford any data outage, you use the SHRLEVEL CHANGE option on your COPY utility control statement. Assume t...

How can you find out which external and native stored procedures are active in the system?

DB2 does not take system checkpoints in which circumstance?

What is the result of the command -RECOVER POSTPONED CANCEL if the postponed-abort thread that you cancel was in the middle of a series of updates when DB2 abended?

The UNLOAD utility can be used to do which of the following functions?

Which of the following results in improving performance of a load job to load data into an indexed partitioned table space with multiple indexes?

A table space is in AREO*. What does this status mean?

Which statement is NOT true?

The performance of BP5 is being evaluated. The Page residency time is being used to see if VPSIZE should be changed. The statistics that are available are VPSIZE of 90,000 and VPSE...

What WLM action will establish performance objectives for DDF threads and their related address space?