Home > IBM > DB2 > 000-732

000-732 Exam

DB2 9 for z/OS Database Administrator

Exam Number/Code : 000-732
Exam Name : DB2 9 for z/OS Database Administrator
Questions and Answers : 146 Q&As
Update Time: 2011-09-21
Price: ~~$ 119.00~~ $ 69.00

000-732

Free 000-732 Demo Download

Test4pass offers free demo for DB2 000-732 exam (DB2 9 for z/OS Database Administrator). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.

Exam Description

It is well known that 000-732 exam test is the hot exam of IBM certification. Test4pass offer you all the Q&A of the 000-732 real test . It is the examination of the perfect combination and it will help you pass 000-732 exam at the first time!

Why choose Test4pass 000-732 braindumps

Quality and Value for the 000-732 Exam
100% Guarantee to Pass Your 000-732 Exam
Downloadable, Interactive 000-732 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.

IBM DB2 000-732 exam braindumps questions and answers

��
��
Exam : IBM 000-732
Title : DB2 9 for z/OS Database Administrator

1. If an object is created statically by a role within a trusted context and the ROLE AS OBJECT OWNER clause is specified, who becomes the object owner when executing the package?
A. The role
B. The schema name
C. The owner keyword
D. The current SQLID (if set)
Answer: A

2. Which of the following is the correct configuration in a two way DB2 datasharing group?
A. MVSA (DB2A, active log A, workfile A)
MVSB (DB2B, active log B, workfile B)
Shared BSDS and catalog and directory
Coupling facility one
Sysplex timer one
B. MVSA (DB2A, BSDS A, active log A, workfile A)
MVSB (DB2B, BSDS B, active Log B, workfile B)
Shared catalog and directory
Coupling facility one
Sysplex timer one
C. MVSA (DB2A, BSDS A, active log A, workfile A, catalog & directory A)
MVSB (DB2B, BSDS B, active log A, workfile A, catalog & directory B)
Coupling facility one
Sysplex timer one
D. MVSA (DB2A, BSDS A, active log A, workfile A, catalog & directory A)
MVSB (DB2B, BSDS B, active log B, workfile B, catalog & directory B)
Coupling facility one
Sysplex timer one
Answer: B

3. Which of the following buffer pool thresholds CANNOT be changed by the DBA?
A. Deferred write threshold (DWQT)
B. Immediate write threshold (IWTH)
C. Vertical deferred write threshold (VDWQT)
D. Virtual buffer pool assisting parallel sequential threshold (VPXPSEQT)
Answer: B

4. A DBA has been required by a new company policy to implement a new DB2 security method. The company would like to separate the authorization IDs that can execute plans and packages from the authorization IDs that can create new plans and packages. Which of the following explicit system privileges allows the user to create new plans and packages without being able to also execute them?
A. BINDADD
B. CREATEIN
C. BINDAGENT
D. CREATEDBA
Answer: C

5. Which of the following RACF profiles would be used to allow IMS to access DB2 DSN1?
A. DSN1.IMS
B. DSNR.IMS
C. DSN1.MASS
D. DSN1.SASS
Answer: C

6. What is the purpose of the following catalog health query?
SELECT BNAME, BCREATOR, BTYPE, DNAME
FROM SYSIBM.SYSPLANDEP PD
WHERE BTYPE IN ('T', 'V', 'A')
AND NOT EXISTS
(SELECT *
FROM SYSIBM.SYSTABLES
WHERE CREATOR = PD.BCREATOR
AND NAME = PD.BNAME
AND TYPE = PD.BTYPE);
A. For every row in SYSTABLES that indicates a dependency upon a table, view, or alias, there should be a corresponding row in SYSPLANDEP.
B. For every row in SYSPLANDEP that indicates a dependency upon a table, view, or alias, there should be a corresponding row in SYSTABLES.
C. For every row in SYSPLANDEP that indicates a dependency upon a table space, view, or a table that has been altered, there should be a corresponding row in SYSTABLES.
D. For every row in SYSPLANDEP that indicates a dependency upon a table space, a table with a VARCHAR column, or alias, there should be a corresponding row in SYSTABLES.
Answer: B

7. An audit trace shows that TSO user TSOID1, with DBADM authority, is continually attempting to update a table in DB2 subsystem DSN1 that is not supposed to be updated. Which of the following will prevent access to the DB2 subsystem?
A. REVOKE DBADM FROM TSOID1
B. Change TSOID1's access to DSNR resource class DSN1.TSO to NONE
C. Change TSOID1's access to DSNR resource class DSN1.BATCH to READ
D. Change TSOID1's access to DSNR resource class DSN1.BATCH to NONE
Answer: D

8. Which of the following DSNZPARMs is necessary to influence access path selection for certain queries?
A. STDSQL
B. OPTHINTS
C. PARTKEYU
D. DESCSTAT
Answer: B

9. A DBA wishes to audit all access to the non-audited table OWNER.EMPLOYEE. Assuming no audit traces are started, which of the following steps are needed to audit access to this table?
A. -START TRACE AUDIT CLASS (5)
B. -START TRACE AUDIT CLASS (4, 5)
C. -START TRACE AUDIT CLASS (4, 5) and ALTER TABLE OWNER.EMPLOYEE AUDIT ALL
D. -START TRACE AUDIT CLASS (4, 5) and ALTER TABLE OWNER.EMPLOYEE DATA CAPTURE CHANGES
Answer: C

10. A company uses TRUSTED CONTEXT "ERP1" and ROLE "ERP_ROLE" as a security mechanism to limit security exposure for an application. All the DB2 objects (databases, table spaces, tables, indexes, views, plans and packages) have been created by that ROLE. The ROLE "ERP_ROLE" has been assigned to User ID "DBA01" in order to perform DBA related tasks. When the user "DBA01" leaves the company, the authorization ID is removed. Which of the following statements are correct? (Select two answers)
A. None of these DB2 objects need to be recreated to re-grant the privileges.
B. The related plans and packages have to be recreated and the privileges re-granted.
C. When removing user "DBA01" privileges, none of these DB2 objects need to be dropped.
D. Only the related databases, table spaces, tables, indexes and views need to be recreated and the privileges re-granted.
E. To remove the privileges of user "DBA01" on these related plans and packages, they have to be dropped and as a result all associated privileges are revoked.
Answer: AC

11. Which parameter in WLM Application Environment controls the # of concurrent stored procedures that can run in that particular environment?
A. NUMSRB
B. NUMTHR
C. NUMCTK
D. NUMTCB
Answer: D

12. A DBA needs to use the DSN command processor to delete DB2 packages that are no longer needed. Which of the following choices is correct for the DBA to use?
A. SPUFI or QMF with the DROP statement
B. FREE Package (<collid>.<name of package>.<version id>)
C. DROP Package (<collid>.<name of package>.<version id>)
D. DROP PLAN (<plan name>) PKLIST (<collid>.<name of a particular package>.<version id>)
Answer: B

13. A DB2 V9 system that is in New Function Mode:
A. cannot fall back.
B. can fall back to Compatibility Mode.
C. can fall back to New Function Mode*.
D. can fall back to Compatibility Mode*.
Answer: D

14. At which of the following times is the access control authorization routine (DSNX@XAC) invoked?
A. At DB2 startup.
B. When executing a DB2 GRANT statement.
C. When DB2 has cached authorization information.
D. During any authorization check if NO was specified in the USE PROTECTION field of the DSNTIPP panel.
Answer: A

Click Online chat to talk with us , get more informations about IBM DB2 000-732 practice exam study guides questions and answers

Test4pass 000-732 Exam Features

Quality and Value for the 000-732 Exam

Test4pass Practice Exams for IBM 000-732 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 000-732 Exam

If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the DB2 000-732 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

IBM 000-732 Downloadable, Printable Exams (in PDF format)

Our Exam 000-732 Preparation Material provides you everything you will need to take your 000-732 Exam. The 000-732 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

000-732 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our IBM 000-732 Exam will provide you with free 000-732 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 000-732 Exam:100% Guarantee to Pass Your DB2 exam and get your DB2 Certification.

Test4pass 000-732 exam
Test4pass 000-732 pdf exam
Test4pass 000-732 braindumps
Test4pass 000-732 study guides
Test4pass 000-732 trainning materials
Test4pass 000-732 simulations
Test4pass 000-732 testing engine
Test4pass 000-732 vce
Test4pass 000-732 torrent
Test4pass 000-732 dumps
free download 000-732
Test4pass 000-732 practice exam
Test4pass 000-732 preparation files
Test4pass 000-732 questions
Test4pass 000-732 answers

http://www.test4pass.com/000-732-exam.html The safer.easier way to get DB2 Certification .