Testking ibm db2 000-513

Monday, August 4, 2008, 23:04
Cert Tests
4 views
1 comment

db2 udb v7.1 database administration for unix windows % os/2 : 000-513 ExamIBM: 000-513 Exam
Questions & Answers 000-513 - Questions & Answers
Interactive Testing Engine Included!
137 Questions
Updated : 03/12/2008
Price : $87.99 $79.99
Add to Cart
IBM 000-513 Exam

QUESTION NO: 1
Given the following DB2DIAG.LOG entry:

“Crash Recovery is needed.”

Which of the following is the most likely cause for this entry?

A. A LOAD failed
B. A restore failed
C. A hardware problem
D. A rollforward is required

Answer: C

QUESTION NO: 2
The following is seen in the DB2DIAG.LOG file:

1999-03-23-15.04.06.397000 Instance:DB2 Node:000
PID:147(db2syscs.exe) TID:203 Appid:0915106D.0805.980323200328
buffer_pool_services sqlbStartPools Probe:0
Database:SAMPLE
Starting the database.

Which of the following connection types is indicated by this entry?

A. Local attachment
B. Local connection
C. Remote attachment
D. Remote connection

Answer: D

QUESTION NO: 3
Which of the following is required to IMPORT data into a table?

A. SYSCTRL authority
B. LOAD authority on the table
C. ALTER privilege on the table
D. IMPORT authority on the table
E. INSERT privilege on the table

Answer: E

QUESTION NO: 4
Which of the following utilities affects the state of a table space?

A. LOAD
B. REORG
C. IMPORT
D. RUNSTATS

Answer: A

QUESTION NO: 5
Which of the following is NOT a characteristic of creating a table using the IXF import file
format?

Donwload Free Certbible, The Most Realistic Practice Questions and Answers,Help You Pass any Exams

A. Summary tables cannot be the target of the import command
B. Imported data is the same as that exported from another table
C. Foreign key definitions are not preserved when creating tables
D. Referential constraints are not preserved when creating tables
E. With SELECT * on export, primary key definitions are not preserved

Answer: E

QUESTION NO: 6
6. Which of the following DB2 utilities can create a table and place data into the table?

A. LOAD
B. EXPORT
C. IMPORT
D. UPLOAD
E. FORCEIN

Answer: C

Free down:Testking ibm db2 000-513 EXAM
Free down:Pass4sure ibm 000-513 v2.73
Free down:latest Testking ibm db2 000-513 exam
password:www.certbible.org