ibm db2 udb v8.1 family fundametals : 000-700 Exam
Test Information:
• Number of questions: 54
• Time allowed in minutes: 75
• Required passing score: 61%
Related certifications:
• IBM Certified Database Associate — DB2 Universal Database V8.1 Family
• IBM Certified Database Administrator — DB2 Universal Database V8.1 for Linux UNIX and Windows
• IBM Certified Application Developer — DB2 Universal Database V8.1 Family
• IBM Certified Solution Designer — DB2 Business Intelligence V8
• IBM Certified Database Administrator — DB2 Universal Database V8.1 for zOS
• IBM Certified Database Administrator — DB2 9 DBA for Linux UNIX and Windows
• IBM Certified Database Administrator – DB2 9 DBA for z/OS
• IBM Certified Application Developer – DB2 9
• IBM Certified Advanced Database Administrator – DB2 9 for Linux UNIX and Windows
Exam Topics Include:
• Planning
• Security
• Accessing DB2 UDB Data
• Working with DB2 UDB Data
• Working with DB2 UDB Objects
• Data Concurrency
Product Description
Exam Number/Code: 000-700
Exam Name:ibm db2 udb v8.1 family fundametals
“ibm db2 udb v8.1 family fundametals”, also known as 000-700 exam, is a IBM certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 108 questions to your 000-700 Exam preparation. In the 000-700 exam resources, you will cover every field and category in DB2 helping to ready you for your successful IBM Certification.
Exam Details
Job Role Description / Target Audience This Database Associate is an entry level DBA or a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 Universal Database V8 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how DB2 Universal Database V8.1 is packaged and installed, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation. Please note this certification is also applicable for DB2 UDB for iSeries V5R2. To attain the IBM Certified Database Associate
QUESTION 1
At a minimum, which of the following products must be installed to provide a single point of control through the Control Center for local and remote DB2 data sources?
A. DB2 Administration Client
B. DB2 Runtime Client
C. DB2 Connect Enterprise Edition
D. DB2 Enterprise Server Edition
Answer: A
QUESTION 2
Assuming the proper privileges, which two of the following would allow access to data in
a table T1 using the name A1?
A. CREATE INDEX a1 ON t1 (col1) B. CREATE ALIAS a1 FOR t1
C. CREATE TRIGGER trig1 AFTER INSERT ON t1 FOR EACH ROW MODE DB2SQL INSERT INTO a1
D. CREATE TABLE a1 LIKE t1
E. CREATE VIEW a1 AS SELECT * FROM t1
Answer: B,E
QUESTION 3
Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
A. TIMESTAMP B. VARCHAR
C. TIME D. CLOB
Answer: C
QUESTION 4
Which of the following occurs if an application ends abnormally during an active unit of work?
A. The unit of work moves to pending state
B. The unit of work moves to CHECK_PENDING C. The unit of work is rolled back
D. The unit of work remains active
Answer: C
QUESTION 5
To set up a client that can access DB2 UDB through DB2 Connect Enterprise Edition, which of the following is the minimum software client that must be installed?
A. DB2 Personal Edition
B. DB2 Application Development Client
C. DB2 Runtime Client
D. DB2 Administration Client
Answer: C
QUESTION 6
Given the statement: CREATE TABLE t1
( c1 CHAR(3) CONSTRAINT c1
CHECK (c1 IN (‘A01′,’B01′,’C01′)) )
DB2 verifies that the table check constraint is met during which of the following actions?
A. Updating any row in the table.
B. Adding an insert trigger to the table. C. Reorganizing the table.
D. Creating a unique index for the table. Answer: A
QUESTION 7
A stored procedure has been created with the following statement:
CREATE PROCEDURE P1(IN VAR1 VARCHAR(10), INOUT VAR2 VARCHAR(10), OUT VAR3 INT)…
From the command line processor (CLP), which of the following is the correct way to call this procedure?
A. Call P1(“DB2″,?,?) B. Call P1(?,?,?)
C. Call P1(‘DB2′,’DB2′,?)
D. Call P1(“DB2″,”DB2″,?) Answer: C
QUESTION 8
Given the two following tables: Tablename: NAMES
Name Number
Wayne Gretzky 99
Jaromir Jagr 68
Bobby Orr 4
Bobby Hull 23
Brett Hull 16
Mario Lemieux 66
Steve Yzerman 19
Claude Lemieux 19
Mark Messier 11
Mats Sundin 13
Tablename: POINTS Name Points
Wayne Gretzky 244
Jaromir Jagr 168
Bobby Orr 129
Bobby Hull 93
Brett Hull 121
Mario Lemieux 189
Joe Sakic 94
Which of the following statements will display the player’s name, number and points for all players with an entry in both tables?
A. SELECT names.name, names.number, points.points
FROM names RIGHT OUTER JOIN points ON names.name=points.name
B. SELECT names.name, names.number, points.points
FROM names INNER JOIN points ON names.name=points.name
C. SELECT names.name, names.number, points.points
FROM names LEFT OUTER JOIN points ON names.name=points.name
D. SELECT names.name, names.number, points.points
FROM names FULL OUTER JOIN points ON names.name=points.name
Answer: B
QUESTION 9
Assuming the database has no distinct types, which of the following is an invalid data type on CREATE TABLE?
A. CLOB
B. DATETIME C. NUMERIC D. DOUBLE
Answer: B
QUESTION 10
To catalog a TCP/IP database connection to a remote DB2 server, which of the following pieces of information is needed?
* pass4sure ibm 000-700 Questions and Answers : 108 questions
* Updated: October 4th , 2008
* Price: $159.99 $99.99
Free down:Testking ibm 000-700
Free down:Pass4sure ibm 000-700
| IBM Free Downloads |
|
Type |
Exam Bible | New Questions & Answers |
Latest Updated |
Download link |
 |
All Ibm 's Exam Pack |
767 |
1 days ago | Download |
If you would like to make a comment, please fill out the form below.
[...] Database Administrator: Database Administrator pass4sure 000-700 Exam : IBM DB2 UDB V8.1 Family Fundamentals pass4sure 000-701 Exam : IBM DB2 UDB V8.1 for Linux, [...]
[...] Database Administrator: Database Administrator pass4sure 000-700 Exam : IBM DB2 UDB V8.1 Family Fundamentals pass4sure 000-701 Exam : IBM DB2 UDB V8.1 for Linux, [...]
[...] Pass4sure 000-700 Testking 000-700 Actualtest 000-700 [...]