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 >

Security in a DB2 UDB

Q1,
If the client authentication type is KERBEROS and the server authentication type is KRB_SERVER_ENCRYPT, what authentication type does the system use?

Choose an option.

CLIENT
KERBEROS < Correct >
KRB_SERVER_ENCRYPT
SERVER
SERVER_ENCRYPT



Q2,
Which privileges are object privileges?

Choose more than one option.

BIND < Correct >
BINDADD
CONNECT
PASSTHRU < Correct >
REFERENCES < Correct >


Q3,
Suppose an administrator specified the WITH GRANT OPTION option when granting a user the SELECT table object privilege. What does this enable the user to do?

Choose an option.

Grant and revoke all table object privileges except for the CONTROL privilege
Grant the SELECT privilege but not revoke any privileges < Correct >
Revoke all privileges and grant the LOAD authority
Revoke the SELECT privilege and grant any privileges specified with the WITH GRANT OPTION option



Q4,
Suppose a user needs to be able to quiesce a database, adjust parameter values in the DB2 Database Manager configuration file for an instance, and configure authority levels for other users. What is the lowest authority you can assign to the user to provide the required privileges?

Choose an option.

Database Administration authority (DBADM)
Load authority (LOAD)
System Administration authority (SYSADM) < Correct >
System Control authority (SYSCTRL)
System Maintenance authority (SYSMAINT)

The DB2 client/server environment

What do configuration parameters control about the DB2 Discovery facility?

Choose more than one option.

Whether a client can initiate DB2 Discovery requests This was a correct option
Whether a server responds to known discovery requests only This was a correct option
Whether a server returns information about an instance in response to a discovery request This was a correct option
Whether a specific client is authorized to access a database This was not a correct option





Identify the situations in which you need to manually configure DB2 communication settings.

Choose more than one option.

When connecting a new client to a server This was not a correct option
When installing the Advanced Program-to-Program Communications (APPC) protocol This was a correct option
When reconfiguring the NetBIOS protocol This was a correct option
When starting DB2 for the first time This was not a correct option



Suppose a server hosts one instance - InterDB - with two databases - Marketing and Finance. You set the DISCOVER_DB parameter to DISABLE for Finance and to ENABLE for Marketing. In the DB2 Database Manager configuration file for InterDB, you set the DISCOVER_INST parameter to DISABLE. Identify the result of these settings.

Choose an option.

Both databases are hidden This was the correct option
InterDB returns information about the databases This was not the correct option
Only Finance and InterDB are hidden This was not the correct option
YThe server ignores discovery requests This was not the correct option



How can you configure DB2 communication settings manually?

Choose more than one option.

Configure the DB2 Discovery facility This was not a correct option
Edit the DB2 Database Manager configuration file This was a correct option
Run a SQL statement This was not a correct option
Set options in the Control Center This was a correct option

The DB2 system environment

Which profile registry stores environment variable settings for a workstation?

Choose an option.

DB2 Global Level Profile Registry This was the correct option
DB2 Instance Level Profile Registry This was not the correct option
DB2 Instance Node Level Profile Registry This was not the correct option




Suppose you want to check the contents of the DBM configuration file, enable the AUTORESTART parameter of the CLIENTS database, and then display the instances available on a system. Which commands do you use to do configure the DB2 environment in this way?

Choose more than one option.

DASLIST This was not a correct option

DB2SET -L This was a correct option

GET DBM CFG This was a correct option

UPDATE DB CFG USING CLIENTS AUTORESTART ON This was a correct option

Which command do you use to check which registry variables a system supports?

Choose an option.

DB2SET - ALL This was not the correct option
DB2SET -LR This was the correct option
DB2SET - U This was not the correct option
DB2SET - UR This was not the correct option



Which command resets the profile registry for the DB2 instance?

Choose an option.

DB2SET -G This was not the correct option
DB2SET -H This was not the correct option
DB2SET -I This was not the correct option
DB2SET - R This was the correct option





Suppose you want to disable sequential detection for a database called SALES. The change must take effect instantly. Which command do you run from the Command Center to do this?

Choose an option.

UPDATE DB CFG FOR SALES USING SEQDETECT NO DEFERRED This was not the correct option
UPDATE DB CFG FOR SALES USING SEQDETECT NO IMMEDIATE This was the correct option

UPDATE DBM CFG FOR SALES USING SEQDETECT NO This was not the correct option
UPDATE DBM CFG FOR SALES USING SEQDETECT NO IMMEDIATE This was not the correct option

Instance management in DB2

Which command lists the name of the DB2 Administration Server (DAS) tool on a Windows operating system?

Choose an option.

DASLIST This was not the correct option
DASCRT This was not the correct option
DB2ADMIN This was the correct option
GET ADMIN CFG This was not the correct option


Which command enables you to connect to the PAYROLL instance?

Choose an option.

ATTACH TO PAYROLL; This was the correct option
DB2IDROP PAYROLL; This was not the correct option
DB2ILIST PAYROLL; This was not the correct option
DB2START PAYROLL; This was not the correct option



Which command migrates the PAYROLL instance to a newer version of DB2?

Choose an option.

DB2ADMIN PAYROLL This was not the correct option
DB2ICRT PAYROLL This was not the correct option
DB2IMIGR PAYROLL This was the correct option
DB2IUPDT PAYROLL This was not the correct option



Which command creates an instance named "SALES"?

Choose an option.

DB2ICRT SALES This was the correct option
DB2IMGR SALES This was not the correct option
DB2IUPDT SALES This was not the correct option
DB2START SALES This was not the correct option



Which command do you use to display all instances available on a system?

Choose an option.

DB2IDROP This was not the correct option
DB2ILIST This was the correct option
DB2IUPDT This was not the correct option
DB2START This was not the correct option

Intranet Browser Compatibility Test Results

Intranet Browser Compatibility Test Results...

A series of quick tests were carried out on your browser when you viewed this page. These tests identify whether or not your browser is configured to ensure compatibility with our websites. You will see a tick beside those items that tested OK. Any crosses displayed indicate possible areas which may prevent you utilising the intranets fully. Details are provided about what you need to do. You can run the test multiple times. If you use different browsers, you should run the test on each browser that you use as you may have each of them set up differently.

JavaScript Cookies Java Your Java settings are optimal. You should not experience any Java-related problems.

Cover Letter Example

<My Address>

5th November, 2010

Ms Ann Chan
Personnel Manager
ABC International Company
GPO Box 1357
Hong Kong

Dear Ms Chan,

Application for the Post of Programmer



With reference to your advertisement in DEF Daily Newspaper on 5th
November, which looking a high calibre person to fill the post of Programmer,
I have no hesitation in offering myself as a candidate for the above post.



I am a computing graduate student in the Hong Kong Institute of Vocational
Education (Sha Tin). In school, I had finished some Cisco course such as
CCNA 4, FWL and ITE 2. In the summer of year one, I was a Temp Operator
of Kodak (Hong Kong) Limited. From lessons of school, course of Cisco and
the summer job, I earned many experience and learned many computer
knowledge.

When I was in Secondary one, I need to study computer in school until
finished Secondary five. In Secondary six and seven, I did not study computer
but I also learned some computer knowledge as I am a member of IT
Ambassador Team. As I love programming, I choose computing to study after
I had graduate in Secondary seven. When I continuous to study computing,
I find that I love programming more than before. This greatly stimulated my
interests in the field of programming, and I am keen to develop in as my future
career.



Enclosed please find my resume. Please give my application your serious
consideration. I will be available for an interview at your earlier convenience.
Thank you very much for your kind attention.



Yours sincerely,

 <My Name>