최신 DB2 C2090-612 무료샘플문제:
1. The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?
A) Number of columns used in an index.
B) Number of times anSQL statement is executed.
C) Stage 1 and stage 2 information.
D) Filter factor information.
2. In a normalized design, in third normal form, the entity defined in the logical design is often transformed in the physical design to which of the following?
A) Table
B) Schema
C) Database
D) Index
3. Which statement about encoding schemes is correct?
A) All objects in the subsystem must use the same encoding schemes.
B) A table can have columns with different encoding schemes.
C) A view can have columns with different encoding schemes.
D) A table space can have tables with different encoding schemes.
4. What IBM provided stored procedure will access DB2 real time statistics tables?
A) DSNACCOX
B) DSNAIMS
C) DSNLEUSR
D) DSNAEXP
5. A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?
A) The first part of the data is stored in the base table and second part is stored in the auxiliary table.
B) The data is only stored in the base table.
C) The data is only stored in the auxiliary table.
D) The complete data is storedboth in auxiliary and in base table.
질문과 대답:
질문 # 1 정답: B | 질문 # 2 정답: A | 질문 # 3 정답: C | 질문 # 4 정답: A | 질문 # 5 정답: B |