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月 15, 2010
星期日, 11月 14, 2010
星期六, 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
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 >
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)
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
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
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
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
訂閱:
文章 (Atom)