星期五, 11月 12, 2010

Manage DB2 database connections

Q1,
Which command do you use to list all applications currently connected to the STOCKDB2 instance?

Choose an option.

LIST APPLICATIONS FOR DATABASE STOCK
LIST APPLICATIONS FOR DATABASE STOCKDB2< It is a correct answer >
LIST APPLICATIONS FOR STOCKDB2
LIST DATABASE STOCKDB2



Q2,
What does the command QUIESCE INSTANCE MY_INST FOR USER SYSMAINT IMMEDIATE FORCE CONNECTIONS do?

Choose more than one option.

Enable only the user with SYSMAINT authority to access the MY_INST instance< It is a correct answer >
Force all connections to the MY_INST instance to terminate
Place the MY_INST instance in quiesce mode immediately< It is a correct answer >
Specify that the MY_INST instance cannot be taken out of quiesce mode




Q3,
What happens to running transactions that you haven't yet committed when you place a database in quiesce mode?

Choose an option.

They are committed
They are placed in quiesce mode
They are rolled back< It is a correct answer >





Q4,
Which of the following SQL commands forces the application with a handle of 5 to terminate its connection to the SALES database?

Choose an option.

FORCE (5)
FORCE ALL
FORCE APPLICATION (5)< It is a correct answer >
LIST APPLICATIONS FOR DATABASE SALES




Q5,
Suppose you run the FORCE APPLICATION command to kill all active database connections. What will continue to run?

Choose more than one option.

Applications currently creating or updating a database< It is a correct answer >
Idle applications
The DB2 Database Manager < It is a correct answer >