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-12
000-730 Price: $ 98.00
You can familiarize yourself with the question format for the exam by doing the online practice questions such as for those offered by us. Any other practice exam, IBM product practice test, and Download IBM 000-730 exam Study Guides And IBM 000-730 exam Training Tools can also be useful.
Section 4 – Working with DB2 Data using SQL (23.5%)
Given a DML SQL
statement, knowledge to identify results
Ability to use SQL to SELECT data
from tables
Ability to use SQL to SORT or GROUP data
Ability to use SQL to
UPDATE, DELETE, or INSERT data
Knowledge of transactions (i.e.,
commit/rollback and transaction boundaries)
Ability to call a procedure or
invoke a user defined function
Given an XQuery statement, knowledge to
identify results
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
6. A UDT is a data type which _____.
A. must contain unique values.
B.
cannot be CAST to other data types.
C. is created using the CREATE TYPE
command.
D. contains a value that was automatically calculated from values in
other columns.
Answer: C
With so many high quality IBM 000-730 exam study materials, you could pass the IBM 000-730 exam and get your IBM certification on the first try as long as you make efficient use of the practice exams. If by any chance you fail IBM 000-730 exam demo, you could get back all the money for purchasing products no matter what the reason is.
Testinside Cisco certification is so confident on the quality of its products that they promise you to pass the IBM 000-730 exam on the first try. If by any chance that you failed in IBM 000-730 exam exam, you can get back all the money for purchasing products regardless of the cause.
