467,199 Members | 987 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

DB2 Sample Test Question? Which is the correct answer?

4) If the following commands are executed:
UPDATE DBM CFG USING DFT_MON_LOCK OFF
UPDATE MONITOR SWITCHES USING lock ON
And the DB2 instance is stopped and restarted, the monitor switch for
the lock monitor will be?
a. ON b. OFF
what's the correct answer?

5) If the following statements are executed:
CONNECT TO mydb
GET SNAPSHOT FOR ALL APPLICATIONS

An application snapshot will be taken for?
a. all applications currently connected to the database mydb
b. all applications currently connected to the instance
which is the correct answer?

Thank you.

Mike

Feb 27 '06 #1
  • viewed: 1276
Share:
2 Replies
Ian
mike_li wrote:
4) If the following commands are executed:
UPDATE DBM CFG USING DFT_MON_LOCK OFF
UPDATE MONITOR SWITCHES USING lock ON
And the DB2 instance is stopped and restarted, the monitor switch for
the lock monitor will be?
a. ON b. OFF
what's the correct answer?

5) If the following statements are executed:
CONNECT TO mydb
GET SNAPSHOT FOR ALL APPLICATIONS

An application snapshot will be taken for?
a. all applications currently connected to the database mydb
b. all applications currently connected to the instance
which is the correct answer?

Thank you.

Mike

4) B
5) B
Feb 27 '06 #2
Thanks for your reply, Ian.

Could you please give me some explanation, especially for the second
question.
When you connect to a db, and get snapshot for applications, I thought
it will only get
db level applications info.

Ian wrote:
mike_li wrote:
4) If the following commands are executed:
UPDATE DBM CFG USING DFT_MON_LOCK OFF
UPDATE MONITOR SWITCHES USING lock ON
And the DB2 instance is stopped and restarted, the monitor switch for
the lock monitor will be?
a. ON b. OFF
what's the correct answer?

5) If the following statements are executed:
CONNECT TO mydb
GET SNAPSHOT FOR ALL APPLICATIONS

An application snapshot will be taken for?
a. all applications currently connected to the database mydb
b. all applications currently connected to the instance
which is the correct answer?

Thank you.

Mike

4) B
5) B


Feb 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

31 posts views Thread by AlexeiOst | last post: by
34 posts views Thread by Mark Kamoski | last post: by
9 posts views Thread by Steve Sargent | last post: by
16 posts views Thread by Heinrich Pumpernickel | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.