IBM C2090-612 : DB2 10 DBA for z/OS

IBM DB2 10 DBA for z/OS 준비에 필요한 모든 것을 ITDumpsKR에서 한 번에 해결하실 수 있습니다. C2090-612 연습문제 134문항부터 무료 샘플, 365일 무료 업데이트, 환불 보장까지 제공합니다. 지금 바로 합격을 향한 첫걸음을 내디뎌 보십시오.

IBM C2090-612 시험 개요:

IBM C2090-612 시험 요강 주제:

IBM C2090-612 응시 전 알아두어야 할 질문들

최신 DB2 C2090-612 무료샘플문제

문제 #1

What trace class will show deadlock information?

A. Statistic class 3.
B. Audit class 3.
C. Performance class 8.
D. Accounting class 1.

문제 #2

Which option allows the UNLOAD utility to unload LOBs into output files together with non- LOB data?

A. DELIMITED
B. DSNTYPE LIBRARY or PDS on the TEMPLATE
C. DSNTYPE HFS on the TEMPLATE
D. SPANNED YES

문제 #3

When these two commands are issued in sequence, one after the other: STOP FUNCTION SPECIFIC(A.B) ACTION(REJECT) STOP FUNCTION SPECIFIC(A.B) ACTION(QUEUE) What will occur?

A. Function A.B is stopped and rejects all access until we start the function or run out of installation timeout.
B. Function A.B is stopped and rejects all access.
C. Function A.B is stopped and queues all access until we start the function or run out of installation timeout.
D. Function A.B is stopped and queues all access.

문제 #4

The new billing application is seeing Class 2 Elapsed Time being made up of mainly Class
3 Synchronous database I/O time. All of the DB2 objects for thenew billing application are in BP5. What command can be used to research the details behind the database I/O time associated with the new billing application?

A. START TRACE(AUDIT)
B. DISPLAY BUFFERPOOL(BP5)LSTATS(ACTIVE) DETAIL
C. DISPLAY DDF DETAIL
D. DISPLAY BUFFERPOOL(*)

문제 #5

Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?

A. ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS
SECURITY LABEL;
B. ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;
C. ALTER TABLE TB1 ADD COLUMN COLC DATE;
D. ALTER TABLE TB1 AUDIT CHANGES;

질문과 대답: