You encounter a wait situation while running a BACKUP SYSTEM utility. Which two processes might contribute to this wait situation? (Choose two.)
A. TRUNCATE TABLE TB1 DROP STORAGE
B. CREATE TABLESPACE TS1 NUMPARTS 25 SEGSIZE 4 IN DATABASE DB1
C. SET CURRENT DECFLOAT ROUNDING MODE=ROUND_CEILING
D. LOCK TABLE TB1 PARTITION 5 IN EXCLUSIVE MODE
E. SELECT * FROM TABLE TB1 WITH RR
正解:A,B
質問 2:
An external stored procedure, assigned to application environment AE1, should run in parallel to a maximum of 10 concurrent procedures. Which action will achieve this?
A. Specify NUMTCB=10 and allow 1 WLM managed stored procedure address space per sysplex for AE1.
B. Specify no limits for NUMTCB and AE1, but limit the degree by DSNZPARM PARAMDEG.
C. Specify NUMTCB=1 and allow 10 WLM managed stored procedure address spaces per sysplex for AE1.
D. Specify no limits for NUMTCB and AE1, but limit the degree by DSNZPARM CONDBAT.
正解:A
質問 3:
An accounting trace shows a high get page per SQL ratio for a query which retrieves just one row each time it is executed. Which two situations could account for the high ratio? (Choose two.)
A. Use of an index with high cardinality.
B. Use of an index with low cardinality.
C. Use of a matching unique index scan.
D. Use of a nonmatching index scan.
E. Use of a single column index that is a GENERATED ALWAYS identity column.
正解:B,D
質問 4:
Which two statements are correct in DB2 9? (Choose two.)
A. TEMP database is used for storing external (user-defined) declared global temporary tables.
B. WORKFILE database supports 4 KB, 8 KB, 12 KB or 32 KB page sizes.
C. WORKFILE database is used for processing SQL with materializing views, triggers, nested table expressions.
D. In a data sharing environment, all data sharing members use a single WORKFILE database.
E. WORKFILE database is used for storing DB2 global temporary tables.
正解:C,E
質問 5:
Which authority is required for the creation of a database role?
A. DBMAINT
B. SYSADM
C. SYSOPR
D. DBADM
正解:B
質問 6:
What does the IMS control region do when a write I/O error occurs on a HDAM database?
A. A batch image copy of the affected data base is immediately started by IMS.
B. The data base is immediately stopped until a recovery can be completed.
C. IMS copies the error buffer contents into a virtual buffer and continues.
D. The application which issued the call terminates with a U0731 abend.
正解:C
Maruyama -
私を合格させることに成功しました。優秀なC2090-549問題集です!合格になりました!友達もC2090-549問題集を勉強しています。