C2090-318 by IBM Valid Free Exam Practice Test

Question 1

Which of the following is an advantage of role-based security?

A. Roles are used to provide a more flexible technique than security group definitions or userids in assigning and controlling authorization B. If you DROP a role that owns objects, those objects will also be dropped C. Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any point in time D. If a role creates an object, a user requires no additional privileges to access the object if the access uses that role as the object owner in the SQL statement

Correct Answer: B

Question 2

Given the following scenario:
A table has been dropped accidentally and you need to restore the object. DSN1COPY will be used to restore the object but the PSID and the original OBID of the object is not known.
Which stand alone utility will allow you to retrieve that information?

A. DSN1LOGP B. DSNJLOGF C. DSN1PRNT D. DSN1SDMP

Correct Answer: C

Question 3

For a general application performance problem, which set of documentation would be most useful for diagnosis?

A. RMF Monitor B. DIAGNOSE MEPL utility C. SVC Dump D. SMF accounting and statistics traces

Correct Answer: B

Question 4

Which authority prevents unintended access to user data but allows installation or migration of a DB2 subsystem?

A. SYSADM B. SYSCTRL C. Installation SYSOPR D. Installation SYSADM

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

Which utility must be executed before and after running a REORG utility against a system catalog table space to support recovery?

A. RUNSTATS B. CHECK DATA C. MODIFY D. COPY

Correct Answer: D

Question 6

In planning to migrate your system to DB2 12. which actions can check for release dependencies and catalog integrity prior to migration?

A. Run job DSNTIJPM when at DB2 12 Function Level V12R1M100 B. Run job DSNTIJPC from the DB2 11 target libraries before migrating to DB2 12 C. While still at DB2 11 run the job DSNTIJPM from the DB2 11 target libraries D. Run DSNTIJPM and DSNTESQ at DB2 11 NFM from the DB2 12 target libraries

Correct Answer: B

IBM DB2 12 System Administrator for z/OS - C2090-318 Exam Practice Test