DB2 9 for z/OS Database Administrator braindumps free download

Free 000-732 Demo Download

Just4cert offers free demo for IBM DB2 000-732 (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.

000-732 exam Exam Description

It is well known that 000-732 test is the hot exam of IBM certification. just4cert 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!

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

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

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

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

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

Why choose just4cert000-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.

Just4cert 000-732 Exam Features