56.
Which of the following commands can be used to force all users and applications from all databases?
- A.FORCE ALL
- B.FORCE USERS ALL
- C.FORCE APPLICATION ALL
- D.FORCE USERS, APPLICATION ALL
- Answer
- Report
Answer : [C]
57.
Which of the following would prevent an application from waiting indefinitely to obtain a lock on table
T1?
- A.Alter table T1 locksize table
- B.Update db cfg for sample using lock_wait 10000
- C.Update db cfg for sample using locktimeout 10000
- D.Update db cfg for sample using lock_wait automatic
- Answer
- Report
Answer : [C]
58.
Which of the following settings would allow 20 sorts with a maximum of 10MB each to run concurrently
on a 64-bit instance?
- A.Set the DB SHEAPTHRES to 50000 and the DB SORTHEAP to 2500.
- B.Set the DBM SHEAPTHRES to 50000 and the DB SORTHEAP to 2500.
- C.Set the DBM SHEAPTHRES to 50000 and the DBM SORTHEAP to 2500
- D.Set the DBM SHEAPTHRES_SHR to 50000 and the DBM SHEAPTHRES to 2500.
- Answer
- Report
Answer : [B]
59.
Based on the following database manager configuration parameter values :
MAXAGENTS 400
MAX_COORDAGENTS200
MAXAGENTS 100
NUM_POOLAGENTS200
NUM_INITAGENTS 50
What is the maximum number of applications that can be executing concurrently in the instance?
MAXAGENTS 400
MAX_COORDAGENTS200
MAXAGENTS 100
NUM_POOLAGENTS200
NUM_INITAGENTS 50
What is the maximum number of applications that can be executing concurrently in the instance?
- A.50
- B.100
- C.200
- D.400
- Answer
- Report
Answer : [B]
60.
Which of the following authorities should a user have in order to QUIESCE the DB2 instance?
- A.DBADM
- B.SECADM
- C.SYSMON
- D.SYSMAINT
- Answer
- Report
Answer : [D]
|
|
||||||||||||||||||||||||||||
