Testking ibm db2 000-515 Exam
- Monday, August 4, 2008, 23:00
- Study Guide
- 56 views
- Add a comment
db2 udb database administration for os/390 : 000-516 ExamIBM: 000-516 Exam
Questions & Answers 000-516 – Questions & Answers
Interactive Testing Engine Included!
118 Questions
Updated : 03/11/2008
Price : $87.99 $79.99
Add to Cart
IBM 000-516 Exam
Q1.
Which of the following grants privileges on all packages in the collection SVL and the
CREATE IN privilege on that collection to USERA, who can also grant those privileges to
others?
A. GRANT CREATE ON COLLECTION svl TO usera
B. GRANT PACKADM ON COLLECTION svl TO usera
C. GRANT CREATE ON COLLECTION svl TO usera WITH GRANT OPTION
D. GRANT PACKADM ON COLLECTION svl TO usera WITH GRANT OPTION
Answer: D.
Q2.
In order to reset the auxiliary warning status (AUXW) and ensure data integrity, which of the
following utilities should be run?
A. REPAIR
B. CHECK LOB
C. CHECK DATA
D. CHECK INDEX
Answer: B.
Q3.
Which of the following CANNOT be produced by DCLGEN?
A. Indicator variable array
B. SQL DECLARE TABLE statement
C. SQL INCLUDE SQLCA statement
D. Host language variable declarations for a table
Answer: C.
Q4.
Which of the following sets of LOAD options allow data to be added to a table while other
processes continue to access existing data in the same table?
A. REUSE YES LOG YES SHRLEVEL CHANGE
B. RESUME YES LOG NO SHRLEVEL CHANGE
C. RESUME YES LOG YES SHRLEVEL CHANGE
D. REUSE YES LOG YES SHRLEVEL REFERENCE
Answer: C.
Q5.
Which TWO of the following conditions indicate that a table space should be reorganized?
(Select two.)
A. The CLUSTERRATIOF column of SYSIBM.SYSINDEXES for a clustering index is
85%
B. The table space is in check pending mode
C. DBD continues to grow after tables are continually dropped and recreated within a
table space
D. LEAFDIST = 100
E. FAROFFPOSF / CARDF = 0
Answer: A, C.
Q6.
A reorg job abended in the RELOAD phase. The SYSREC DD statement specifies DISP=( ,
DELETE,CATLG).
Which of the following action sequences will successfully restart the utility?
Donwload Free PassGuide Braindumps-The Most Realistic Practice Questions and Answers,Help You Pass any ExamsA. Change the UTPROC parameter to RESTART(PHASE), rerun the job
B. Issue a TERM UTILITY command, change the UTPROC parameter to
RESTART(PHASE), rerun the job
C. Change the UTPROC parameter to RESTART(PHASE), change the SYSREC DD
statement to DISP=(MOD,DELETE,CATLG), rerun the job
D. REPAIR the RECP flag for the affected tablespace, change the UTPROC parameter to
RESTART(PHASE), delete the SYSREC dataset, rerun the job
Answer: C.
Q7.
A segmented table space with referential constraints is currently in RW mode. Which of the
following conditions exist after executing a successful REORG TABLESPACE utility with
SHRLEVEL NONE LOG NO?
A. The table space is put in Read-Only mode.
B. The table space is put in Check Pending mode.
C. Indexes for the table space are put in Recover Pending mode.
D. Previous image copies may not be candidates for use during certain recoveries.
Answer: D.
Q8.
DSN1PRNT provides which of the following information?
A. Hexadecimal dumps of DB2 data sets and databases
B. Collection of DB2 messages sent to the MVS console for a specified date and time
period
C. LOB table spaces associated with a base table space
D. Amount of space allocated for STOGROUPs and related table spaces and indexes
Answer: A.
Q9.
Which of the following CANNOT be performed by the UNLOAD utility?
A. Join tables
B. Unload rows from an image copy
C. Change the data type of a selected column
D. Use sampling to get a cross section of the data
Answer: A.
Q10.
Which of the following commands will allow the use of table space TS1 in database DB1 for
update or insert that is currently in COPY pending status?
A. -START DB(db1) SPACENAM(ts1)
B. -START TABLESPACE (db1.ts1) ACCESS(RW)
C. -START DB(db1) SPACENAM(ts1) ACCESS(RW)
D. -START DB(db1) SPACE(ts1) ACCESS(FORCE)
Answer: D.
Free down:Testking ibm db2 000-516 Exam
Free down:Pass4sure ibm db2 000-516 v2.73
Freee down:Latest ibm 000-516 exam
password:www.certbible.org
|
Type |
Exam Bible | New Questions & Answers |
Latest Updated |
Download link |
| All Certbible 's Exam Dumps |
597 |
1 days ago | Available |
PassGuide Training Materials & Practice Tests
About the Author
Free Certification Exam Download has written 10018 stories on this site.
If you have any doubts about legality of content or you have another suspicions, feel free to contact us:CertGuard@Gmail.com
Write a Comment
Gravatars are small images that can show your personality. You can get your gravatar for free today!
