Q: 當使用 Office 來列印文件時,除了原先要列印的文件外, Office 會自動列印出一張文件資訊頁。為何會自動列印多了一頁?

例如：
===========================


檔名: xxxx.doc
目錄：C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\.....
範本：C:\Documents and Settings\Administrator\Application Data\Microsoft\Templates\Normal.dot
標題：XXX
主旨：
作者：wfh0804
關鍵字：hot news
註解：
建檔日期：d/m/yyyy h:mm
修訂版編號：1
前次更新日期：d/m/yyyy h:mm
前次存檔人員：wfh0804
編修總時間：15分鐘
最後列印在：d/m/yyyy h:mm
最後列印的字數
　　頁數：x
　　字數：x(約)
　　字元數：x(約)

===========================


A: 這是因為閣下在 Ms Office 設定了「附帶印出摘要資訊」。

步驟一： 在任何應用軟體中(如 Microsoft Word) 按下「列印」=> 「選項」

步驟二 ： 取消選擇「摘要資訊」即可

p.s. 如果打印文件時未能正常顯示頁碼，只能打印 {PAGE}，可嘗試剔除「功能變數代碼」。

Lotus Notes 的 Home Page 不是 Workspace 板面

新安裝 Lotus Notes 時，預設開啟時不是 Workspace 頁面的。
如果希望下次 execute LN 時 default 跳至 Workspace，設定如下：

     鼠標移到 Databases -> 單擊左鍵
-> 鼠標移到 Workspace -> 單擊右鍵
-> 鼠標移到 Set Bookamrk as Home Page -> 單擊左鍵

Access Point of HKIT CSW Campus

香港科技專上書院九龍校舍無線接入點
WIFI information of HONG KONG INSTITUTE OF TECHNOLOGY



地點: 九龍長沙灣長沙灣道638號



SSID: HKIT-CSW
KEY: wireless4hkit


Country: HONG KONG
Region: HONG KONG (SAR)
City: HONG KONG
Latitude: 22.24786
Longitude: 114.203384
Time Zone: +08:00
Net Speed: DSL
ISP: PACNET
Domain: CITA.COM.HK
IDD Code: 852


無線區域網路介面卡 Wireless:

連線特定 DNS 尾碼 . . . . . . . . : hkit.edu.hk
DHCP 已啟用 . . . . . . . . . . . : 是
自動設定啟用 . . . . . . . . . . .: 是
子網路遮罩 . . . . . . . . . . . .: 255.255.255.0
預設閘道 . . . . . . . . . . . . .: 192.168.2.5
DHCP 伺服器 . . . . . . . . . . . : 192.168.2.5
DNS 伺服器 . . . . . . . . . . . .: 192.168.2.5
NetBIOS over Tcpip . . . . . . . .: 啟用



IPcop 1.4.21
Configuration page:
http://cswgateway.hkit.edu.hk:81/
https://192.168.2.5:445/cgi-bin/index.cgi

The DB2 database creation process

1. What can you conclude about a database that is physically stored in the path segment \BROCDB\NODE0000\SQL00004\?

It is the fourth database created within this path
The database is not partitioned
The instance name is BROC
The tablespaces are SMS


2. Suppose you've created a nonpartitioned database on the E drive called BROCDB. What will the path name be?

Local Disk (E:)/BROCDB/NODE0000
Local Disk (E:)/BROCDB/NODE0001
Local Disk (E:)/NODE0000/BROCDB
Local Disk (E:)/NODE0001/BROCDB




3. You are in the process of creating a database, and the database configuration file has just been initialized. Which tasks will complete the creation of the database?

Binding certain utility programs to the database
Cataloging the database
Creating system tablespaces
Granting authorities and privileges to the appropriate users




4. Which database recovery file stores information about the buffer pool?

SQLBP.1
SQLDBCON
SQLINSLK
SQLSPCS.1




5. What is the function of SYSCATSPACE1?

To provide temporary storage for reorganizing tables
To store system views and catalog tables
To store user-defined objects




6. You're creating a database, and the buffer pool has just been created. Which of these tasks have been completed at this stage of the process?

All the files needed for database recovery have been created
Authorities and privileges have been granted to the appropriate users
Four default schemas have been created
The database has been cataloged in the system and local database directory

Tablespaces in DB2 UDB databases

1. Suppose you want to create a very large temporary tablespace that will store the global temporary tables where the application data is stored for brief periods of time. Which type of tablespace should you create?

Large
Regular
System temporary
User temporary



2. During the execution of certain operations, internal application-specific data is generated, along with declared global temporary tables. You want to create a tablespace to store this data. Which tablespace should you choose?

Large
Regular
Temporary



3. Suppose you want to create a tablespace where the storage space needs to be set at a certain size, and where additional containers can be added as required. Which type of tablespace should you create?

DMS
SMS
Temporary




4. What allocates storage space in an SMS tablespace?

DB2 Database Manager
Domain Controller
File manager of the operating system
Group Policy




5. What does a tablespace hold?

Boot records
Data
Pointers to data
Registry settings





6. What can a regular tablespace contain?

Declared global temporary tables
Index data
Long field data
Regular data

Working with SMS and DMS tablespaces in DB2

1. Suppose you want to obtain basic information about the containers that are associated with the BRODB database, which has an internal ID of 1. Which command should you execute to obtain the results?

LIST TABLESPACE
LIST TABLESPACE CONTAINERS FOR 1
LIST TABLESPACE CONTAINERS FOR BRODB
LIST TABLESPACE SHOW DETAIL



2. Which of the following commands will add the file STG.TSF, located on the root of C, which is 1000 MB in size, as a storage file to the tablespace MYTABLESPACE?

ALTER TABLESPACE MYTABLESPACE ADD (FILE 'C:\STG.TSF', 1000)
ALTER TABLESPACE MYTABLESPACE ADD (FILE 'C:\STG.TSF', 1000 M)
ALTER TABLESPACE MYTABLESPACE DROP (FILE 'C:\STG.TSF')
ALTER TABLESPACE MYTABLESPACE EXTEND (FILE 'C:\STG.TSF' 1000 M)




3. What type of tablespace will be created by this statement?
CREATE REGULAR TABLESPACE TEMPSTAFF
PAGESIZE 8K
MANAGED BY DATABASE USING

A large SMS tablespace
A regular DMS tablespace
A system temporary tablespace
A user temporary tablespace



4. Which of the following parameters are common to both DMS and SMS tablespace commands?

The name of the buffer pool used by the tablespace
The name that will be assigned to the tablespace
The number of pages to be stored in the tablespace container
The size of each space used by the tablespace







5. What parameters of an SMS tablespace can you modify?

Buffer pool associated with a tablespace
Container size
Prefetch pages
Prefetch size





6. What type of information is returned by executing the LIST TABLESPACE command?

The current state of the tablespace
The internal ID of the tablespace
The name of the tablespace
The number of empty pages

Buffer pools in DB2 UDB

1. When you configure a buffer pool from the Control Center, what must you do to configure the Create Buffer Pool dialog box so that the buffer pool is only created when all connections to the database are closed?

Configure the dialog box to create the buffer pool immediately
Configure the dialog box to create the buffer pool when the database restarts
Configure the dialog box to store pages in extended memory



2. Suppose you want to change the page size of a buffer pool called CLIENT_BP to 550. Which command do you execute to change the page size of the buffer pool?

ALTER BUFFERPOOL CLIENT_BP 550;
ALTER BUFFERPOOL CLIENT_BP PAGESIZE 550;
ALTER BUFFERPOOL CLIENT_BP SIZE 550;




3. Suppose you want to create a buffer pool - SALES_BP - that contains 350 pages and services tablespaces that use a page size of 8192 bytes.
Which code do you need to execute to create this buffer pool?

CREATE BUFFERPOOL SALES_BP SIZE 8 PAGESIZE 350K;
CREATE BUFFERPOOL SALES_BP SIZE 350 PAGESIZE 8192K;
CREATE BUFFERPOOL SALES_BP SIZE 350 PAGESIZE 8K;
CREATE BUFFERPOOL SALES_BP SIZE 8192 PAGESIZE 350K;




4. What is the function of the buffer pool?

Cache data pages
Free up memory space
Improve database system performance
Write dirty pages to the hard drive