Worldwide:

000-732, IBM DB2 000-732 Exam

Home >> IBM >> DB2 >> 000-732

000-732 Exam

IBM 000-732 exam
  • Questions and Answers
  • 146 Q&As
  • Update time
  • March 12th,2010
  • Software Price
  • $145 $100

loading loading

Product Description

Exam Number/Code: 000-732

Exam name: DB2 9 for z/OS Database Administrator

000-732 test is the important of IBM certifaction. Only you pass the 000-732 exam you could have the chance to get IBM certifaction. To help examinee, Exambible publish the Questions and Answers about 000-732 exam. And the 146 simulation exam are all designed by expert from Exambible. Examinees could have an enough prepare by these simulation exercises and pass the 000-732 test successfully.
Exambible also provide free 000-732 Demo, examinees can download and use before buying 000-732 Q&As, then decide if they need to purchase.

More IBM DB2 Resources

Recommended IBM exams

  • IBM 000-750 exam: ibm certified specialist retail store solution sales
  • IBM COG-105 exam: IBM Cognos 8 BI Technical Specialist
  • IBM 000-M62 exam: IBM Lotus Protector Technical Sales Mastery Test v1
  • IBM 000-298 exam: ibm websphere bus.integ.message broker v5.system admin
  • IBM 000-887 exam: IBM Tivoli Monitoring Express V6.1
  • IBM 000-439 exam: Fundamentals of Enterprise Solut.Using IBM Tivoli Strg 2008
  • IBM 000-703 exam: db2 udb v8.1 familu application development
  • IBM 000-019 exam: IBM Tivoli Network Manager IP Edition V3.8 Implementation
  • IBM 000-257 exam: test 257,ent apdevwwibm rtnl apdev for wbsph software v6.0
  • IBM 000-025 exam: IBM Tivoli Storage Manager V6.1 Implementation
  • IBM 000-648 exam: Rational Portfolio Manager
  • IBM 000-706 exam: db2 v8.1 for linux,unix and windows db admin upgrade

IBM DB2 000-732 Web Demo

This webdemo is just a demo data, only for reference and learning, there is no other purposes.

1. 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


2.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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

Exambible materials do not contain actual questions and answers from Microsoft's Certification Exams.