C2090-312

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 and value should you use?A .  PRIQTYOB .  PRIQTY-1C .  DEFINE NOD .  DEFER YESView AnswerAnswer: C

Given this statement: RUNSTATS TABLESPACE DB1 TS1 RESET ACCESSPATH HISTORY ACCESSPATH Which statement is FALSE?A .  It resets all real-time statistics (RTS) for DB1TS1.B .  It resets all access path statistics for DB1TS1 in the catalog.C .  It invalidates the dynamic statement cache for table space DB1TS1.D .  It externalizes...

Which statement is true for data in columns defined with data type XML?A .  Data stored in XML columns cannot be indexed.B .  It is possible to define the XML column with an INLINEC . ENGTE .  You can partially UPDATE, DELETE from, and INSERT into an XML document.F ....

Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?A .  The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Local Dynamic Statement Cache.B .  The PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic Statement...

Prefetch l/Os are executed under a service request block in which address space?A .  IRLMB .  DBM1C .  MSTRD .  User address spaceView AnswerAnswer: B

What is a general recommendation for when to rebind?A .  After a backup is taken.B .  After a subsystem restart.C .  Before maintenance is applied.D .  After a major change in data volume.View AnswerAnswer: B

Which component is NOT shared between DB2 data sharing members?A .  SCAB .  IRLMC .  DB2 catalogD .  DB2 directoryView AnswerAnswer: C

As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by performing what action?A .  Issue the ACCESS command with appropriate keywords.B .  Issue the ARCHIVE command with the appropriate keywords.C...

Which global variables statement is true?A .  A global variable is a synonym for special registers.B .  Like for special registers, the access to global variables cannot be granted or revoked.C .  A global variable is a created DB2 object, which can be instantiated and used by applications.D .  Global...

You want to determine which objects of your database DB1 are in LPL. What command should be used?A .  -DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(')B .  -DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(')C .  -DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(") SCOPE(GROUP)D .  -DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(') SCOPE(GROUP)View AnswerAnswer: B