EMT Practice Test

1. Question Content...

---

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

Question2: 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?

Question3: An application receives an 00C90110 reason code. See the following manual explanation of the code.
" 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?

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

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

Question6: Which component is NOT shared between DB2 data sharing members?

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

Question8: 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?

Question9: 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?

Question10: 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 updated data?

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

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

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

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

Question15: 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 19855
TSO T * 3 KSTTEST KSTTEST 0135 20172
A51OTEST N* 13 CICSTEST 0125 19625
You receive a call that user KSTTEST is holding resources and needs to be canceled.
Which command should be issued?

Question16: 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?

Question17: 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?

Question18: 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?

Question19: Which statement is true?

Question20: When would DB2 NOT use list prefetch?

Question21: What can you accomplish with the stored procedure ADMIN_UTL_MONITOR?

Question22: 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?

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

Question24: Which global variables statement is true?

Question25: 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.
The Employees and Projects entity is considered what kind of relationship?

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

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

Question28: 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 information?

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

Question30: Which statement regarding triggers is true?

Question31: 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 number of short prepares?

Question32: 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 this new array type as follows:
CREATE VARIABLERECENT_CALLS PHONENUMBERS:
Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS?

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

Question34: 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 allowed?

Question35: 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?

Question36: 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?

Question37: What is a general recommendation for when to rebind?

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