IBM C2090-312 - IBM DB2 11 DBA for z/OS Exam
Page: 3 / 14
Total 67 questions
Question #11 (Topic: )
You want to create a table space without actually creating the underlying data sets until
rows are inserted into the corresponding table.
Which CREATE TABLESPACE statement option and value should you use?
rows are inserted into the corresponding table.
Which CREATE TABLESPACE statement option and value should you use?
A. PRIQTYO
B. PRIQTY-1
C. DEFINE NO
D. DEFER YES
Answer: C
Question #12 (Topic: )
DB2 AUDIT policies are defined by inserting rows into what DB2 Catalog table?
A. SYSIBM.SYSDBAUTH
B. SYSIBM.SYSAUTOALERTS
C. SYSIBM.SYSAUDITPOLICIES
D. SYSIBM.SYSTABLESPROFILES
Answer: C
Question #13 (Topic: )
Which command populates the EXPLAIN tables but does not create a package?
A. REBINDCOPY
B. REBINDEXPLAIN(NO)
C. REBINDEXPLAIN(YES)
D. REBIND EXPLAIN(ONLY)
Answer: D
Question #14 (Topic: )
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?
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 #15 (Topic: )
What can you accomplish with the stored procedure ADMIN_UTL_MONITOR?
A. This stored procedure helps you monitor currently running threads.
B. You can create a detailed report of currently running and stopped utilities.
C. This stored procedure materializes SYSIBM.SYSSTATFEEDBACK for the page sets you specify as input parameter.
D. You can create RUNSTATS profiles and RUNSTATS recommendations for DB2 tables in your DB2 subsystem.
Answer: D
