Whether you're trying to fit certification into the last few weeks of this year or looking ahead to certify in 2009, take a spin through these sample questions. Each set of questions (and the detailed answers) will help you prepare for DB2 9 DBA testing. Once you've mastered these, browse past questionshere . Be sure to browse the comments section for additional tips and clarification.
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 schema name
B.The role
C.The owner keyword
D.The current SQLID (if set)
Correct:B
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 regrant the privileges.
B.The related plans and packages have to be recreated and the privileges regranted.
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 regranted.
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.
Correct:A C
More IT exam certifications ns0-101 ns0-102 000-223 0b0-410 hp0-s14 hp0-s11
