IBM DB2 11 DBA for z/OS v7.0 (C2090-312)

Page:    1 / 5   
Total 67 questions

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 current access paths statistics for DB1 TS1 to HIST catalog tables.


Answer : C

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

  • A. It cannot be a join.
  • B. The authids do not have to match.
  • C. It must include more than one literal.
  • D. It cannot have both literals and parameter markers.


Answer : D

When would DB2 NOT use list prefetch?

  • A. Fast log apply operations.
  • B. Reading leaf pages of a disorganized index.
  • C. RUNSTATS TABLESPACE without table sampling.
  • D. Incremental image copies of a table space defined with TRACKMOD YES.


Answer : B

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 be your next step?

  • A. COPY the table space.
  • B. REORG the table space.
  • C. REBUILD all of the indexes.
  • D. DROP the segmented table space.


Answer : D

An application receives an 00C90110 reason code. See the following manual explanation of the code.



Answer : D

" 00C90110Explanation:The data manager detected an inconsistent data condition. This may be caused by an inconsistency in either the DB2P' catalog or the DB2 directory. In this case, the OBD for the requested OBID cannot be located in the database descriptor (DBD).
The DBD in storage may be inconsistent. Specifically, the OBDDMAP(OBID) array element should contain an offset into the DBD where the OBD should be located. However, in this case the OBD expected was not at the indicated offset.To prevent further damage and possible loss of data, the inconsistency must be corrected before any further SQL access is attempted to this database."
Even though the problem cannot be recreated, you still want to find out what caused this and you want to collect additional information for the IBM support team.
Which utilities and service aids CANNOT help to provide useful additional info to diagnose the problem?

A. REPAIR -

B. REPORT -

C. DIAGNOSE -

D. DSN1LOGP -

Answer: C -

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

  • A. At least 20 rows fit on a data page.
  • B. DB2 uses range scans to access rows in the table.
  • C. The size of individual rows in the table vary greatly.
  • D. DB2 uses sequential lookups to access data in the table.


Answer : D

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

  • A. A unique constraint is allowed on a security label column.
  • B. A check constraint is not allowed on a security label column.
  • C. A referential constraint is not allowed on a security label column.
  • D. Multilevel security with row-level checking is enforced when DB2 checks a referential constraint.


Answer : C

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 verified?

  • A. In the DSN1PRNT job output of the header page.
  • B. In the DB2 MSTR address space joblog as all DB2 commands are shown there.
  • C. In the DB2 recovery log as all DB2 commands are written to the DB2 recovery log.
  • D. In the z/OS system log (SYSLOG), as all commands including DB2 commands are written to the z/OS system log.


Answer : B

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 route numbers and the maximum speed limit for each route?

  • A. CREATE TYPE SPEEDJJMIT AS SMALLINT; CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT, MAX_SPEED SPEEDJJMIT);
  • B. CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEEDJJMIT);
  • C. CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. SPEED_LIMIT);
  • D. CREATE TYPE SPEEDJJMIT USING DECIMAL(2.0); CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEED_LIMIT);


Answer : B

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?

  • A. TCPALVER=NO
  • B. TCPALVER=YES
  • C. TCPALVER=SERVER_SECURE
  • D. TCPALVER=SERVERENCRYPT


Answer : B

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?

  • A. IDTHTOIN
  • B. MAXDBAT
  • C. CONDBAT
  • D. MAXCONQN


Answer : D

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

  • A. DIST
  • B. IRLM
  • C. DBM1
  • D. MSTR


Answer : B

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

  • A. -SET LOG LOGLOAD(O)
  • B. -DISPLAY DB(DB1)SPACENAM(TS1)
  • C. RUNSTATS TABLESPACE DB1TS1
  • D. -ACCESS DB(DB1) SPACENAM(TSI) MODE(STATS)


Answer : 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 variables can only be used in native SQL stored procedures and user-defined functions.


Answer : B

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 results in a data set or as a result set?

  • A. ADMIN_INFO_SQL
  • B. ADMIN_JOB_QUERY
  • C. ADMIN_INFO_SYSPARM
  • D. ADMIN UPDATESYSPARM


Answer : C

Reference:
http://www.redbooks.ibm.com/redbooks/pdfs/sg248151.pdf (page 72, see the table)

Page:    1 / 5   
Total 67 questions