IBM C2090-312  DB2 11 DBA for z/OS Exam Certification Exam Sample Questions and answers.

QUESTION NO: 1
Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL
statement?
A. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in
the Local Dynamic Statement Cache.
B. The PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic
Statement Cache.
C. The PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic
Statement Cache.
D. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in
the Global Dynamic Statement Cache.
Answer: D

QUESTION NO: 2
Which table characteristic is a good attribute for the exploitation of hash access?
A. At least 20 rows fit on a data page.
B . DB2 uses range scans to access rows in the table.
C. The size of individual rows in the table vary greatly.
D. DB2 uses sequential lookups to access data in the table.
Answer: D

QUESTION NO: 3
Which group of DB2 ACCOUNTING trace CLASSES must be started to collect
accounting information for PLANS and PACKAGES?
A . CLASS(2,7,8)
B . CLASS(1,2,3)
C . CLASS(1,5,10)
D. CLASS(1, 2,3,7,8)
Answer: D

QUESTION NO: 4
Consider a logical data model that includes an Employees entity and a Projects entity. In this
model, employees work on many projects and projects are worked on by many employees.
The Employees and Projects entity is considered what kind of relationship?
A. A one-to-one relationship.
B . A one-to-many relationship.
C . A many-to-one relationship.
D. A many-to-many relationship.
Answer: D

QUESTION NO: 5
You must be able to process recoveries for DB2 objects to any point in time between now and two
weeks ago.
What is the recommended amount of recovery data needed?
A. One set of SHRLEVEL(CHANGE) full image copies every two weeks that are kept for at
l east two weeks.
B. One set of SHRLEVEL(CHANGE) full image copy at least every week that are kept for at least
three weeks as well as the active/archive logs during that time.
C. One set of SHRLEVEL(CHANGE) full images copies at least every week that are kept for at
least two weeks as well as the active/archive logs during that time.
D. One set of SHRLEVEL(CHANGE) full images copies during week#1 and one set of
SHRLEVEL(REFERENCE) incremental images copies during week #2, all are kept for at least two
weeks.
Answer: D
Reference:http://www.gsebelux.com/system/files/GSE%20backup%20and%20recovery%20%20at
%20KBC.pdf(page 10)


Buy C2090-312 Exam Dumps

Be the first to comment

Leave a Reply

Your email address will not be published.


*