000-730 Exam
DB2 9 Fundamentals
Exam Number/Code : 000-730
Exam
Name : DB2 9 Fundamentals
Questions and Answers : 127 Q&As
Update
Time: 2010-05-24
Price: $ 125.00
4. Given the following two tables:
TAB1
C1 C2
__ __________
1
Antarctica
2 Africa
3 Asia
4 Australia
TAB2
CX CY
__
_____________
5 Europe
6 North America
7 South America
Which of the
following SQL statements will insert all rows found in table TAB2 into table
TAB1?
A. INSERT INTO tab1 SELECT cx, cy FROM tab2
B. INSERT INTO tab1
VALUES (tab2.cx, tab2.cy)
C. INSERT INTO tab1 VALUES (SELECT cx, cy FROM
tab2)
D. INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM
tab2)
Answer: A
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 19168.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 NODE myhost REMOTE db2srv SERVER 446
B. CATALOG TCPIP NODE mydb2srv
REMOTE myhost SERVER 446
C. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER
192.168.10.1
D. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER
192.168.10.1
Answer: B
Test 000-730 information:
Number of questions: 64
Time allowed in
minutes: 90
Required passing score: 59%
Passing IBM 000-730 exam not only
validate your skills but also prove your credentials and expertise to your
employers. The current IT industry demands a reliable 000-730 exam source, so
that you pass your 000-730 exam in minimum possible time and without wasting
much of your money and energies.
At Hiexam Certified IBM 000-730 training
study guide we provide you with Practice Questions and Answers, Practice Testing
Software, 000-730 Study Guide, Preparation Labs and Audio Learnings. Hiexam IT certification IBM 000-730
exam Training Tools are detailed and provide you with a real time
environment.
000-730 dumps for IBM certification are easily available on the internet. Now
you need not hanker after the study materials in the market. Hiexam IBM 000-730
dumps help materialize your dreams of success with minimum effort.
000-730 dumps are the choice of all IT professionals who aspire to obtain IBM
000-730 certification. Some of the websites on certifications provide free
000-730 dumps to help the IT professionals in their studies for IBM
certifications.