By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,018 Members | 901 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,018 IT Pros & Developers. It's quick & easy.

DB2 Sample Test Question? Which is the correct answer?

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.