During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?
Answer : B
In order to retain an access path across a rebind which of the following commands could be used?
Answer : D
Which ALTER TABLE statement will generate a new table space version?
Answer : B
Which stored procedures need to be set up properly in order to register an XML schema?
Answer : B
Which trace gives information about frequent log space shortages?
Answer : B
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. SECADM authority.
B. ACCESSCTRL authority.
C. DATAACCESS authority.
D. SYSADM authority when SEPARATE_SECURITY=NO.
E. The owner of the object as he/she has that authority implicitly.
Answer : A,D Topic 2, Volume B
Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?
Answer : B
A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?
Answer : B
What is the one significant difference between sequenceobjects and identity columns?
Answer : B
Altering the DSSIZE is allowed for what type of table space?
Answer : B
What WLM action will establish performance objectives for DDF threadsand their related address space?
Answer : D
When determining what page size will be best for index compression, which utility can be used to provide information on space saved and potential buffer space wasted for each of the different page sizes?
Answer : B
Click on the exhibit to view properly coded XML data. Some employees have been assigned assistants. Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of employees who are not assistants?
Answer : D
DB2 workfiles are critical to performance of applications. Which of the following will NOT assist withachieving best performance for workfile usage?
Answer : D
When is changing an index from non-clustering to clustering NOT allowed?
Answer : C