What DB2 command when issued displays what migration mode the catalog is in?
A. DISPLAY DATABASE (DSNDB06)
B. DSNC DISPLAY
C. MODIFY irlmproc,STATUS
D. DISPLAY GROUP
正解:D
質問 2:
What should be implemented in order to audit all the activity of the install SYSADM?
A. A DB2 audit policy should be established, identifying the SYSADM ID to be audited.
B. Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.
C. The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID.
D. DATA CAPTURE CHANGES should be set on all tables.
正解:A
質問 3:
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 the different page sizes?
A. DSN1PRNT
B. DIAGNOSE
C. DSN1COMP
D. DSN1LOGP
正解:C
質問 4:
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 update the view EMPD on joined tables DEPT and EMP?
A. No, only a clone of the view EMPD can be updated via an UPDATE statement.
B. Yes, an UPDATE statement against the EMPD view is allowed if an INSTEAD OF trigger is defined on the view.
C. Yes, the view EMPD can be updateddirectly via an UPDATE statement.
D. No, an UPDATE statement against the EMPD view is not allowed at all.
正解:B
質問 5:
When converting a multiple table segmented table space to partition-by-growth table spaces, which statement is correct?
A. DSMAX may have to be increased.
B. The dynamic statement cache should be increased to handle the additional SQL statements.
C. Storage requirements for some applications will increase.
D. Storage requirements for EDMDBDC will decrease.
正解:A
質問 6:
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?
A. Perform a DISPLAY DATABASE (LOCKS ) command often.
B. Always have a performance trace running.
C. Turn on a monitortrace.
D. Always have statistics classes 1,3, and 4 and accounting classes 1 and 3 running.
正解:D
質問 7:
If SEGSIZE 64 and MAXPARTITIONS 10 are specified in a CREATE TABLESPACE statement, what type of table space is created?
A. Range-partitioned tablespace.
B. Segmented table space.
C. LOB table space.
D. Partition-by-growth table space.
正解:D
質問 8:
What is a potential consideration when using triggers?
A. RI and check constraints are evaluated prior to any trigger invocation.
B. They are not invoked by the LOAD REPLACE utility.
C. When using views, the underlying tables cannot have a trigger defined.
D. They run in a WLM managed address space, so invoking them frequently (e.g. when using a row level trigger) can be costly.
正解:B
質問 9:
What is the DSNZPARM thatdetermines the maximum amount of temporary storage in the work file data base for a single user at any given time?
A. MAXDBAT
B. MAXTEMPS
C. MAXKEEPD
D. MAXRBLK
正解:B