星期一, 11月 15, 2010

香港手提電話 3G 上網 Access point name (APN) 設定

PCCW
APN: pccw

3HK Mobile Plan
APN: mobile.three.com.hk

3HK Data Plan:
APN: ipc.three.com.hk

Smartone-Vodafone
APN: Smartone-Vodafone

Access Number: *99#

======

< 輸入 APN (看下表)>
PCCW = PCCW
one2free = hkcsl
1010 = hkcsl
SmarTone = SmarTone-Vodafone
3HK = mobile.three.com.hk
Peoples = peoples.net

one2free 要入PROXY
而且要加兩個APN

1. CSL internet
hkcsl
proxy: 192.168.59.51:8080

2. CSL Data
hkcsl
proxy: 192.168.59.51:9201

星期日, 11月 14, 2010

IQ方程式

1, 邊樣維他奶產品唔可以用黎蒸咩?

答案:麥精(勿蒸)荳奶


2, 邊座山個個都話白的?

答案:梁山伯(白)


3, 通常九點鐘出門口GE人會幾點返屋企? 請答埋a.m / p.m

答案:1 p.m (九出十三歸)


4, 咩文具最正義?

答案:見死不(筆)救


5, 咩生果唔打字?

答案:不打自招(字蕉)


6, 邊兩個英文字母最難教?

答案:EC 難教


7, 地球有26個字母。有一天,ABC到火星去了,地球只剩餘20個字母。為甚麼?

答案:因爲它們乘坐UFO去了。

星期六, 11月 13, 2010

Schedule and track tasks in DB2 UDB

Question 1

What information does the Task History feature provide?

Choose more than one option.

All messages issued from the Task Center
Details of tasks that have executed<= Correct Answer
Execution statistics for tasks that have executed<= Correct Answer
Task results <= Correct Answer



Question 2
What steps do you need to perform to convert a script into a task?

Choose more than one option.

Create an equivalent QUIESCE command
Define success and failure conditions<= Correct Answer
Schedule the date and time that the script will run<= Correct Answer
Specify notifications to be sent <= Correct Answer


Question 3
What do the following values in the entry header for a notification log entry specify generated the entry?

PID:3468(db2syscs.exe)
TID:3368 Appid:*LOCAL.DB2.00D305132415

Choose more than one option.

The process with ID 3468<= Correct Answer
The process with ID LOCAL.DB2.00D305132415
The transaction with ID 3368<= Correct Answer
The transaction with ID 3468


Question 4
What actions can you perform once a task completes?

Choose more than one option.

Create a FORCE APPLICATION command
Delete the completed task<= Correct Answer
Disable another task<= Correct Answer
Run another task <= Correct Answer


Question 5
Which tools enable you to view notification log information on a DB2 server running Windows 2003?

Choose more than one option.

Task Center
The Database History view of the Journal
The Notification Log view of the Journal<= Correct Answer
Windows Event Viewer <= Correct Answer



星期五, 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 >



星期四, 11月 11, 2010

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)

星期三, 11月 10, 2010

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

星期二, 11月 09, 2010

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

推薦此文