최신 DB2 000-730 무료샘플문제:
1. A declared temporary table is used for which of the following purposes?
A) Staging area for load operations
B) Backup purposes
C) Storing intermediate results
D) Sharing result data sets between applications
2. If table TAB1 is created using the following statement:
CREATE TABLE tab1 (col1 INTEGER NOT NULL,
col2 CHAR(5),
CONSTRAINT cst1 CHECK (col1 in (1, 2, 3)))
Which of the following statements will successfully insert a record into table TAB1?
A) INSERT INTO tab1 VALUES (NULL, 'abc')
B) INSERT INTO tab1 VALUES (ABS(2), 'abc')
C) INSERT INTO tab1 VALUES (0, 'abc')
D) INSERT INTO tab1 VALUES (DEFAULT, 'abc')
3. Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?
A) Hierarchically
B) Rows and columns
C) CLOB
D) BLOB
4. Given the following table:
EMPLOYEE
EMPID NAME INSTRUMENT
1 Jagger, Mick 01
2 Richards, Keith 02
3 Wood, Ronnie 02
4 Watts, Charlie 03
5 Jones, Darryl 04
6 Leavell, Chuck 05
If the following query is executed:
SELECT name,
CASE WHEN instrument = '01' THEN 'HARMONICA'
WHEN instrument = '02' THEN 'GUITAR'
WHEN instrument = '03' THEN 'DRUMS'
ELSE 'UNKNOWN'
END AS instrument
FROM employee
What will be the results?
A) NAME INSTRUMENT
Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl 04 Leavell, Chuck 05
B) NAME INSTRUMENT
Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl ERROR Leavell, Chuck ERROR
C) NAME INSTRUMENT
Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl UNKNOWN Leavell, Chuck UNKNOWN
D) NAME INSTRUMENT
Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl -Leavell, Chuck
5. A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?
A) CATALOG TCPIP NODEmyhost REMOTE db2srv SERVER 446
B) CATALOG TCPIP NODEmyhost REMOTE db2srv SERVER 192.168.10.1
C) CATALOG TCPIP NODE mydb2srv REMOTEmyhost SERVER 446
D) CATALOG TCPIP NODE mydb2srv REMOTEmyhost SERVER 192.168.10.1
질문과 대답:
| 질문 # 1 정답: C | 질문 # 2 정답: B | 질문 # 3 정답: A | 질문 # 4 정답: C | 질문 # 5 정답: C |
0 개 고객 리뷰
품질과 가치ITCertKR 의 높은 정확도를 보장하는 최고품질의 덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.
테스트 및 승인ITCertKR 의 덤프는 모두 엘리트한 전문가들이 실제시험문제를 분석하여 답을 작성한 만큼 시험문제의 적중률은 아주 높습니다.
쉽게 시험패스ITCertKR의 테스트 엔진을 사용하여 시험을 준비한다는것은 첫 번째 시도에서 인증시험 패스성공을 의미합니다.
주문하기전 체험ITCertKR의 각 제품은 무료 데모를 제공합니다. 구입하기로 결정하기 전에 덤프샘플문제로 덤프품질과 실용성을 검증할수 있습니다.
