IBM Certified Database Administrator - DB2 10 for z/OS - 000-612 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

The available window to reorganize table spaces is being reduced. What data can provide information to allow for a priority list of candidate table spaces for reorganization based on recentactivity with no recent RUNSTATS execution?

A. SYSIBM.SYSINDEXES B. SYSIBM.SYSTABLES C. SYSIBM.SYSTABLESPACESTATS D. SYSIBM.SYSCOPY

Discussion 0

Correct Answer: C Vote an answer

Question 2

For monitoring space growth over time, which statistics should NOT be considered?

A. SYSIBM.SYSTABLEPART_HIST
CARDF, SPACEF
SYSIBM.SYSINDEXPART_HIST
CARDF, SPACEF B. SYSIBM.SYSTABLESPACESTATS
SPACE
SYSIBM.SYSINDEXSPACESTATS
SPACE C. SYSIBM.SYSTABLEPART
CARDF, SPACEF
SYSIBM.SYSINDEXPART
CARDF, SPACEF D. SYSIBM.SYSTABLESPACE
DSSIZE, AVGROWLEN
SYSIBM.SYSINDEXES
PIECESIZE, AVGKEYLEN

Discussion 0

Correct Answer: D Vote an answer

Question 3

Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

A. DATAACCESS authority. B. ACCESSCTRL authority. C. The owner of the object as he/she has that authority implicitly. D. SECADM authority. E. SYSADM authority when SEPARATE_SECURITY=NO.

Discussion 0

Correct Answer: D,E Vote an answer

Question 4

What is the result of the command -RECOVER POSTPONEDCANCEL if the postponed- abort thread that you cancel was in the middle of a series of updates when DB2 abended?

A. The underlying page sets are placed in REFP restrictive state. B. No restrictive state is set. It is your responsibility to ensure data consistency. C. The underlying page sets are stopped. D. The underlying page sets are placed in REORP restrictive state.

Discussion 0

Correct Answer: A Vote an answer

Question 5

You have been asked to find packages that use isolation level UR in dynamic SQL. Which trace will be utilized?

A. Monitor trace class(6) B. Performance trace class(3) C. Audit trace class(4) D. Accounting trace class(1,2,3,7,8)

Discussion 0

Correct Answer: B Vote an answer

Question 6

Which authoritylevel allows a user to run utilities that change the data in an application database?

A. INSTALL SYSOPR B. DBMAINT C. SYSOPR D. DBCTRL

Discussion 0

Correct Answer: D Vote an answer

Question 7

What START TRACE command provides detailed lock suspend and lock contention trace information?

A. START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF) B. START TRACE(PERFM) CLASS(30) IFCID(44,45) C. START TRACE(STATS) CLASS(1) D. START TRACE(AUDIT)

Discussion 0

Correct Answer: B Vote an answer

Question 8

What kind of information is stored in SYSIBM.SYSCOPY?

A. Only information about objects which are currently in copy pending. B. Only information about existing image copies. C. Information about currently runningand stopped copy jobs. D. General information needed for recovery.

Discussion 0

Correct Answer: D Vote an answer

Question 9

The application will be handling a large volume of input data that will need to be added to or update 4 differenttables. On average, there will be 50 million input records daily. To ensure that the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level of availability to the tables involved in this application process, what is a key component of the application coding?

A. Provide an effective commit / restart process. B. Run a QUIESCE utility before the process starts. C. Execute the SQL INSERT before the SQL UPDATE. D. Issue a LOCK TABLE for all 4 tables.

Discussion 0

Correct Answer: A Vote an answer