IBM C2090-612 Actual Free Exam Questions & Community Discussion
When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure,what value must the SECURITY clause specify?
Correct Answer: C
Vote an answer
Unnecessary REORGs of indexes may be avoided by which of the following?
Correct Answer: C
Vote an answer
Which two of the following DB2 performance features will ignore clustering in favor of faster insert performance? (Choose two.)
Correct Answer: B,D
Vote an answer
The new billing application is seeing Class 2 Elapsed Time being made up of mainly Class
3 Synchronous database I/O time. All of the DB2 objects for thenew billing application are in BP5. What command can be used to research the details behind the database I/O time associated with the new billing application?
3 Synchronous database I/O time. All of the DB2 objects for thenew billing application are in BP5. What command can be used to research the details behind the database I/O time associated with the new billing application?
Correct Answer: A
Vote an answer
In determining whether a REORG on an index space would improve performance, which two of the following columns would NOT be needed? (Choose two.)
Correct Answer: B,E
Vote an answer
If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be done?
Correct Answer: B
Vote an answer
If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated?
Correct Answer: D
Vote an answer
Which trace gives information about frequent log space shortages?
Correct Answer: A
Vote an answer
A table space is in AREO*. What does this status mean?
Correct Answer: A
Vote an answer
0
0
0
10