2018 DSE 资讯及通讯科技-ICT 真题 答案 详解

---

答案(中文)

卷一（甲部）

题號 答案 题号 答案
1. C(68%) 21. A(70%) 2. B(67%) 22. A(47%) 3. A(62%) 23. D(80%) 4. D(55%) 24. C(65%) 5. B(81%) 25. B(88%) 6. A(88%) 26. D(81%) 7. A(48%) 27. B(73%) 8. D(79%) 28. B(33%) 9. B(61%) 29. C(87%) 10. D(56%) 30. A(66%)

1. C(38%) 31. C(73%)
2. D(24%) 32. C(80%)
3. C(65%) 33. B(79%)
4. C(45%) 34. D(67%)

5. B(64%) 35. C(49%)

6. A(47%) 36. A(83%)

7. C(89%) 37. D(93%)
8. A(86%) 38. B(72%)
9. D(60%) 39. B(81%)

10. B(81%) 40.

11. 本試題被刪去

注：括號內數字為答對百分率。

關於「刪除試題」的說明

每年考試，香港考試及評核局如果認為多項選擇題試卷中某些試題欠理想，通常都會把這些試題的量刪去。根據過往經驗，上述決定基於不同的理由；最常見的是由於試題的難易程度不同而影響了考生分辦出來，換言之，大多數考生答题只顧應付度·保留這類试题，恐會降低測試效能，所以不得不把它刪去。這類试题雖經决定在考试中删去不用，但仍刊登在報章内，並予以標明，而當年的考試報告或會提出討論。

Provided by dse.life

答案(英文)

Paper 1 (Section A)

Question No. Key Question No. Key

1. C (68%) 21. A (70%)

2. B (67%) 22. A (47%)

3. A (62%) 23. D (80%)

4. D (55%) 24. C (65%)

5. B (81%) 25. B (88%)

6. A (88%) 26. D (81%)

7. A (48%) 27. B (73%)

8. D (79%) 28. B (33%)

9. B (61%) 29. C (87%)

10. D (56%) 30. A (66%)

11. C (38%) 31. C (73%)

12. D (24%) 32. C (80%)

13. C (65%) 33. B (79%)

14. C (45%) 34. D (67%)

15. B (64%) 35. C (49%)

16. A (47%) 36. A (83%)

17. C (89%) 37. D (93%)

18. A (86%) 38. B (72%)

19. D (60%) 39. B (81%)

20. B (81%) 40.

This item was deleted.

Note: Figures in brackets indicate the percentages of candidates choosing the correct answers.

General note on item deletion

It is normal for the HKAEA to delete a small number of items from its multiple-choice question papers if they prove unsatisfactory. In practice, there are a number of reasons why this is considered necessary. By far the most common reason for deleting an item is that the item fails to discriminate between weak and able candidates - in other words, the ability of the candidates involved had to rely on guesswork in answering that question. If such an item is retained, the measurement process is rendered less effective. Where items have been deleted in the live papers, they are still included in series of publications. They are indicated as deleted items. Such items may be discussed in the corresponding mination reports.

Provided by dse.life

真题 Paper 1(中文)

本试卷共有 40 题·請選擇最合適的答案。

1. 志明在試算表內建立了圖表 1·他想修改圖表 1 使它成為面表 2 他須修改哪項圖表設定?

A. 圖例
B. 資料來源
C. 座標軸
D. 圖表類型

2013 2014 2015 2016 2017

圖表 1

9200 9600 9800 10000

2013 2014 2015 2016 2017

圖表 2

1. 數據庫表 PROD 包含七筆記錄 如下所示:

NAME	WEIGHT	PSTAT
SALT	1	A
SUGAR	1	P
SHAMPOO	1	P
TOOTHPASTE	3	P
ORANGE	4	S
CHARCOAL	5	P
NOODLES	6	S

執行下列 SQL 指令會輸出什麼?

SELECT MAX(WEIGHT) FROM PROD WHERE PSTAT <> 'S'

A. 1
B. 5
C. 6
D. 11

1. 下列哪項是改變學校內專線帳戶密碼時的一個數據驗證例子?

A. 輸入新密碼兩次
B. 輸入新密碼和確認電話號碼
C. 輸入最少包含一個特別符字的密碼
D. 輸入舊密碼和新密碼

2018-DSE-ICT 1A-2

真题 Paper 1(英文)

There are 40 questions in this paper. Choose the most suitable answers.

1. Peter creates Chart 1 in a spreadsheet file. He wants to modify Chart 1 so that it becomes Chart 2. Which chart setting should he change? A. Legend B. Data source C. Axis D. Chart type

Chart 1 12000 10000 8000 6000 4000 2000 2013 2014 2015 2016 2017

Chart 2 10000 9800 9600 9400 9200 2013 2014 2015 2016 2017

A database table PROD has seven records, as shown below:

PNAME	WEIGHT	PSTAT
SALT	1	A
SUGAR	1	P
SHAMPOO	1	P
TOOTHPASTE	3	P
ORANGE	4	S
CHARCOAL	5	P
NOODLES	6	S

What would be the output after executing the following SQL command?

SELECT MAX(WEIGHT) FROM PROD WHERE PSTAT <> 'S'

A. 1 B. 5 C. 6 D. 11

When changing the password of a school Intranet account, which of the following is an example of data verification?

A. Input a new password twice. B. Input a new password and a mobile phone number. C. Input a new password that consists of at least one special character. D. Input the old password and a new password.

Provided by dse.life

真题 Paper 2a(中文)

本试卷全部试题均须回答。

1. 李小姐現正編輯一個辯論比賽·她使用一個數據庫表 DEBATE 來儲存比赛中各場辯論的資料。

DEBATE | 標名 | 描述 | |------|----------------| | MID | 此場辯論的識別碼 | | PROID| 正方（贊成辯題）隊伍的識別碼 | | PRONAME| 正方隊伍名稱 | | PROM | 正方隊伍分數 | | CONID| 反方（反對辯題）隊伍的識別碼 | | CONNAME| 反方隊伍名稱 | | CONM | 反方隊伍分數 | | DD | 此場辯論的舉行日期 | | TD | 辯題 |

一些記錄樣本如下所示：

MID	PROID	PRONAME	PROM	CONID	CONNAME	CONM	DD	TD
M01	T01	老虎	80	T02	火箭	92	10-3-18	應取消所有家課
M03	T03	飛龍	95	T02	火箭	60	17-3-18	香港應不設税項
M08	T04	幸運	90	T03	飛龍	99	24-3-18	金錢能買到快樂
M10	T06	開心	88	T05	紅獅	90	17-3-18	香港應不設税項
M11	T09	野兔	85	T07	红苹果	70	24-3-18	电視比書本優勝
M12	T12	天使	83	T05	红獅	80	24-3-18	电視比書本優勝

寫於邊界以外的答案，將不予評閱。

(a)(i) CONNAME與哪一個標位相關？____ (1 分)

(ii)舉出一個例子來展示 DEBATE 內的數據冗餘問題。_____ (1 分)

Provided by dse.life

真题 Paper 2b(中文)

本试卷全部试题均须回答。

1. 某石油公司有一個通訊網絡，連接其在世界主要城市的辦公室和在陸上及海上的油井。

(a) 该網絡主要使用光纖作為傳輸媒介。

(i) 署出该網絡中使用光纖的兩個好處。

(2 分)

(ii) 建議另一種合適的傳輸媒介來建立辦公室與海上油井的通訊連接，並舉出一個支持這個建議的理由。

(2 分)

(b) (i) 该通訊網絡同時支援單向和雙向的通訊模式。這兩種模式之間的分別是什麼？

(2 分)

(ii) 署出在该石油公司內使用每種通訊模式的一個應用。

單向通訊模式：

雙向通訊模式：

(2 分)

Provided by dse.life

真题 Paper 2c(中文)

本试卷全部试题均须回答。

1. 家健建構下列網頁教授數學：

動畫橫幅
視像
播放 停止 快速向前 暂停 快速倒退
數學公式
∑ k(N-k+1) k=1

(a) 家健使用 GIF 格式而非 SWF 格式來製作此網頁內的動畫橫幅。舉出兩個原因。

(2 分)

(b) 此網頁內視像的規格是

帧速率：30 fps
色深：12 位元
帧大小：4096 × 2160
持續時間：30 分鐘

(i) 估算此視像未被壓縮時的檔案大小，並以 GB 表示。展示你的計算。

(2 分)

界以外的答案，將不予評閱。

Provided by dse.life

真题 Paper 2d(中文)

本试卷全部试题均须回答。

1. 家健编寫子程式 F1 來處理一個全程整數陣列 A，其大小為 n 。F1 的偽代碼是：

子程式 F1
isStop ← FALSE
pos ← n - 1
當 isStop ≠ TRUE 時
如果 A[pos] = 1 则
A[pos] ← 0
否則 pos ← pos - 1
A[pos] ← 1
isStop ← TRUE

假設 n = 8 。
(a) (i) 假設 A 的初始內容是十進制數值 1 的二進制表示：
A:
0 1 2 3 4 5 6 7
0 0 0 0 0 0 0 1

執行 F1 後 A 的內容是什麼？
A:
(1 分)

(ii) 假設 A 的初始內容是十進制數值 7 的二進制表示：
A:
0 1 2 3 4 5 6 7
0 0 0 0 0 1 1 1

執行 F1 後 A 的內容是什麼？
A:
(1 分)

(iii) F1 的目的是什麼？
(2 分)

66

真题 Paper 2a(英文)

Answer all questions.

1. Ms Lee is organising a debating competition. She uses a database table DEBATE to store information on debates in the competition.

DEBATE

Field name	Description
MID	Identity code of the debate
PROID	Identity code of the pro team (argue in favour)
PRONAME	Name of the pro team
PROM	Mark of the pro team
CONID	Identity code of the con team (argue in opposition)
CONNAME	Name of the con team
CONM	Mark of the con team
DD	Date of the debate
TD	Topic of the debate

Some sample records are shown below:

MID	PROID	PRONAME	PROM	CONID	CONNAME	CONM	DD	TD
M01	T01	Tiger	80	T02	Rockets	92	10-3-18	Homework should be banned.
M03	T03	Dragon	95	T02	Rockets	60	17-3-18	Hong Kong should have no tax.
M08	T04	Lucky	90	T03	Dragon	99	24-3-18	Money can buy you happiness.
M10	T06	Happy	88	T05	Red lion	90	17-3-18	Hong Kong should have no tax.
M11	T09	Rabbit	85	T07	Red apple	70	24-3-18	TV is better than books.
M12	T12	Angels	83	T05	Red lion	80	24-3-18	TV is better than books.

(a) (i) Which field does CONNAME depend on? _ (1 mark)

(ii) Give an example to illustrate the data redundancy problem in DEBATE. _______ (1 mark)

Provided by dse.life

真题 Paper 2b(英文)

Answer all questions.

1. An oil company has a communication network connecting its offices in major cities around the world with oil wells on land and in the ocean. (a) The network mainly uses fibre optics as the transmission medium. (i) Give two benefits of using fibre optics in the network. (2 marks)

(ii) Suggest another appropriate transmission medium for establishing a communication link between offices and oil wells in the ocean. Give a reason for your suggestion. (2 marks)

(b) (i) The communication network supports both simplex and duplex communication modes. What are the differences between these two modes? (2 marks)

(ii) Give an application of each communication mode used in the oil company. Simplex communication mode: Duplex communication mode: (2 marks)

Answers written in the margins will not be marked. Provided by dse.life

真题 Paper 2c(英文)

Answer all questions.

Tom constructs the following web page for teaching mathematics:

1.

Animated banner

Video

Play Pause Stop Fast forward Fast rewind Mathematical formula

Learning Mathematics

N Σ k(N-k+1)

k = 1

(a) Tom creates the animated banner on the web page in GIF format instead of in SWF format. Give two reasons for this.

(2 marks)

(b) The specifications of the video on the web page are

Frame rate: 30 fps

Colour depth: 12 bits

Frame size: 4096 × 2160

Duration: 30 minutes

(i) Estimate the file size of the video without compression in GB. Show your calculation.

(2 marks)

Provided by dse.life

真题 Paper 2d(英文)

Answer all questions.

Tom writes a subprogram F1 to process a global integer array, A, of size n. The pseudocode for F1 is:

Subprogram F1 isStop ← FALSE pos ← n - 1 while isStop ≠ TRUE do if A[pos] = 1 then A[pos] ← 0 else A[pos] ← 1 isStop ← TRUE

Suppose that n = 8.

(a) (i) Suppose that the initial content of A is the binary representation of the decimal value 1: A: 00000001 What is the content of A after executing F1? A: ___ (1 mark)

(ii) Suppose that the initial content of A is the binary representation of the decimal value 7: A: 00000111 What is the content of A after executing F1? A: ___ (1 mark)

(iii) What is the purpose of F1?

---

(2 marks)

Provided by dse.life