DB2 Sample Test Question? Which is the correct answer?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike_li - 27 Feb 2006 19:19 GMT

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

Reply to this Message

Ian - 27 Feb 2006 20:21 GMT

> 4) If the following commands are executed:
> UPDATE DBM CFG USING DFT_MON_LOCK OFF
[quoted text clipped - 16 lines]
>
> Mike

4) B
5) B

Reply to this Message

mike_li - 28 Feb 2006 14:56 GMT

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.

> > 4) If the following commands are executed:
> > UPDATE DBM CFG USING DFT_MON_LOCK OFF
[quoted text clipped - 19 lines]
> 4) B
> 5) B

Reply to this Message