최신 IBM Certified Database Administrator C2090-312 무료샘플문제:
1. In order to use a literal replacement for a dynamic SQL caching statement what must be true about the statement?
A) It cannot have both literals and parameter markers.
B) It must include more than one literal.
C) The authids do not have to match.
D) It cannot be a join.
2. Which component is NOT shared between DB2 data sharing members?
A) DB2 catalog
B) SCA
C) DB2 directory
D) IRLM
3. What is the minimum buffer pool page size for a compressed index?
A) 4K
B) 8K
C) 16K
D) 32K
4. What is the least disruptive way of externalizing real-time statistics for table space DB1TS1?
A) RUNSTATS TABLESPACE DB1TS1
B) -DISPLAY DB(DB1)SPACENAM(TS1)
C) -ACCESS DB(DB1) SPACENAM(TSI) MODE(STATS)
D) -SET LOG LOGLOAD(O)
5. Which DB2 subsystem parameter is used to control the number of concurrent inbound DDF connections?
A) MAXDBAT
B) CONDBAT
C) CONTSTOR
D) CTHREAD
질문과 대답:
질문 # 1 정답: A | 질문 # 2 정답: A | 질문 # 3 정답: A | 질문 # 4 정답: A | 질문 # 5 정답: B |