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

---

答案(中文)

卷一（甲部）

题號 答案 题号 答案
1. A(40%) 21. D(37%) 2. D(42%) 22. C(76%) 3. C(51%) 23. A(89%) 4. B(75%) 24. D(88%) 5. B(74%) 25. D(35%) 6. C(50%) 26. D(59%) 7. A(80%) 27. A(57%) 8. A(74%) 28. A(69%) 9. B(79%) 29. D(52%) 10. D(59%) 30. B(48%) 11. A(52%) 31. D(85%) 12. C(55%) 32. A(54%) 13. D(28%) 33. C(84%) 14. D(36%) 34. D(68%) 15. B(71%) 35. C(50%) 16. C(88%) 36. B(66%) 17. B(72%) 37. A(78%) 18. C(80%) 38. A(71%) 19. C(62%) 39. B(94%) 20. A(87%) 40. B(65%)

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

84

Provided by dse.life

答案(英文)

Marking Schemes

This document was prepared for markers’ reference. It should not be regarded as a set of model answers. Candidates and teachers who were not involved in the marking process are advised to interpret its content with care.

General Notes on Marking

1. Teachers are strongly advised to conduct their own internal standardisation procedures using the marking scheme before the actual marking begins. After standardisation, teachers should adhere to the marking scheme to ensure a uniform standard of marking within the school.

2. The marking scheme may not exhaust all possible answers for each question. Teachers should exercise their professional discretion and judgment in accepting alternative answers that are not in the marking scheme, but are correct and well-reasoned.

3. The following symbols are used:

x This symbol indicates a wrong or unacceptable answer. Shaded words, figures or ideas are not essential for the candidate to be awarded the point. / A single slash indicates an acceptable alternative within an answer. + A plus sign indicates that there are two pieces of information and the second part will be awarded points only when the first part is correct.

1. In questions asking for a specified number of reasons or examples etc. and a candidate gives more than the required number, the extra answers should not be marked. For instance, in a question asking candidates to provide two examples, and if a candidate gives three answers, only the first two should be marked.

83 Provided by dse.life

真题 Paper 1(中文)

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

1. 下列哪項在文字處理軟件內可有效地格式化一份文件？ (1) 以最常用的字型和字體大小設定成預設值 (2) 標題可使用預先設定的樣式 (3) 善用自動校正功能 A. 只有 (1) 和 (2) B. 只有 (1) 和 (3) C. 只有 (2) 和 (3) D. (1)、(2) 和 (3)

2. 下列哪個以 8 位元二進制補碼表示數字的加法運算會引致上溢錯誤？ A. 0011 0110 + 0011 1100 B. 0100 0010 + 1000 0001 C. 1001 1100 + 1111 0110 D. 1011 0100 + 1100 0100

3. 字符「x」和「z」的 ASCII 編碼以十六进制表示，分別為 __ 和 5A。 A. 3A B. 3C C. 58 D. 59

4. 在數據庫軟件內建構數據庫表時，用戶通常應設定什麼？ (1) 每個欄的數據類型 (2) 最多的記錄數目 (3) 主鍵碼 A. 只有 (1) 和 (2) B. 只有 (1) 和 (3) C. 只有 (2) 和 (3) D. (1)、(2) 和 (3)

5. 小芬使用 WAV 格式而非 MP3 格式來錄製音樂表演。這樣有好處嗎？ (1) 音效檔的檔案大小較大 (2) 音質更佳 (3) 沒有跨平台問題 A. 只有 (1) B. 只有 (2) C. 只有 (1) 和 (3) D. 只有 (2) 和 (3)

2021-DSE-ICT IA-2

真题 Paper 1(英文)

2021-DSE TAPER 1 ECT A) HONG KONG EXAMINATIONS AND ASSESSMENT AUTHORITY HONG KONG DIPLOMA OF SECONDARY EDUCATION EXAMINATION 2021 INFORMATION AND COMMUNICATION TECHNOLOGY PAPER 1 8:30 am - 10:30 am (2 hours) This paper must be answered in English

GENERAL INSTRUCTIONS 1. There are two sections, A and B, in this Paper. 2. Section A consists of multiple-choice questions in this question paper. Section B contains conventional questions printed separately in the Question-Answer Book. 3. Answers to Section A should be marked on the Multiple-choice Answer Sheet. Answers to Section B should be written in the spaces provided in the Question-Answer Book. The Answer Sheet for Section A and the Question-Answer Book for Section B must be handed in separately at the end of the examination.

INSTRUCTIONS FOR SECTION A (MULTIPLE-CHOICE QUESTIONS) 1. Read carefully the instructions on the Answer Sheet. After the announcement of the start of the examination, you should first stick a barcode label and insert the information required in the spaces provided. No extra time will be given for sticking on the barcode label after the 'Time is up' announcement. 2. When told to open this book, you should check that all the questions are there. Look for the words ‘END OF SECTION A’ after the last question. 3. All questions carry equal marks. 4. ANSWER ALL QUESTIONS. You are advised to use an HB pencil to mark all the answers on the Answer Sheet, so that wrong marks can be completely erased with a clean rubber. You must mark the answers clearly; otherwise you will lose marks if the answers cannot be captured. 5. You should mark only ONE answer for each question. If you mark more than one answer, you will receive NO MARKS for that question. 6. No marks will be deducted for wrong answers.

Not to be taken away before the end of the examination session

2021-DSE-ICT 1A-1 4 Provided by dse.life

真题 Paper 2a(中文)

只须回答三题。

1.某機構每年舉辦校際編程比赛，它使用數據庫表 SCHOOL、PSTUD 及 MARK 來分别储存學校、参赛學生和學生分数的资料。比赛分為初級组和高级组，参赛学生均獲得一個分数。缺席比赛之學生不會在 MARK 內有記錄。

SCHOOL | 標名 | 類型 | 描述 | 例子 | |------|------|------------|----------| | SID | 字符 | 學校編碼 | S0013 | | SNAME| 字符 | 學校名稱 | 甲乙丙官立中學 |

PSTUD | 標名 | 類型 | 描述 | 例子 | |------|------|------------|----------| | SID | 字符 | 學校編碼 | S0013 | | PID | 字符 | 學生識别码 | P2020023 | | PNAME| 字符 | 學生姓名 | 陳小文 | | FIRST| 布關 | 學生首次報名參賽 | TRUE | | GP | 字符 | 初级组(J)或高级组(S)| J |

MARK | 標名 | 類型 | 描述 | 例子 | |------|------|------------|----------| | PID | 字符 | 學生識别码 | P2020023 | | SMARK| 整数 | 比赛得分 | 74 |

試為以下任務(a)至(c)寫出SQL語句。

(a) 列出來自學校編碼為「S0013」的學生姓名。

(2 分)

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

2021-DSE-ICT 2A-2

真题 Paper 2b(中文)

只需回答三题。

1. 張小姐建立其分公司的電腦網絡，並手動設定此網絡，如下所示：

總公司 檔案伺服器 12.34.5.6

互聯網 電話線 DNS伺服器 210.12.0.1

分公司 數據機 98.76.54.32/192.168.1.1 Y 網路打印機 192.168.1.2 網路儲存設備(NAS) 192.168.1.3 手提電腦 192.168.1.4

——有線連接 WiFi連接

(a) Y是由交換器、路由器和無線網絡接點(AP)組成。

(i) 在下面繪畫網絡連接，以展示Y內的三個設備與數據機是如何連接。

數據機 Y 98.76.54.32/192.168.1.1 路由器(2個界面) 交換器(8個埠) AP

(2 分)

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

Provided by dse.life

真题 Paper 2c(中文)

只需回答三题。

1. 贵老师使用网络摄像机拍摄他的课堂教学，并上载这些视频至互联网供学生观看。(a) 摄像头设定有以下两个选项，如下所示，指出这两个选项在视频质量方面的不同之处。

选项	解像度	帧速率
A	720p	15 fps
B	4K	30 fps

(2分)

(b) 黄老师录影了一段长40分钟的视频，他打算将视频档案大小限制在500MB以下。估算此视频可使用的最高位元率，并以kbps表示。展示你的计算过程。

(2分)

(c) 黄老师虽然在家中架设了网页服务器，但仍决定将他的视频在影片分享平台上发布。

(i) 指出需理由以支持他的决定。

(2分)

写于边界以外的答案，将不予评阅。

2021-DSE-ICT2C-2

57

Provided by dse.life

真题 Paper 2d(中文)

只须回答三题。

1. 在某火车站，火车在一天内的出发时间储存于大小为n的阵列P中，以时间顺序排列。志明编写程式F1(s,t)以找出由时间s至时间t出发的火车数目，包括首尾两個時間間。他假设在时间s和時間t均有火车出发。例如，根据以下P的内容，F1(12:20, 18:00)傳回3。

i	1	2	3	4	5	6	7
P[i]	06:05	07:10	11:25	12:20	14:25	18:00	19:30

(a)(i)参考以上P的内容，求下列的傳回值： (1) F1(07:10, 14:25)_____（1分） (2) F1(11:25, 11:25)_______（1分）

(ii) 完成以下F1的伪代码。 F1(s, t) count ← 0 设i由1至n執行 如果 _ AND _ 则 count ← __ 傳回 count (3 分)

志明用對分檢索编寫子程式BS，以找出在時間t 出發的火车的索引： BS(t) s ← 1 e ← n 當 s ≤ e 執行 m ← (s+e)/2 如果 p[m] = t 则 退出子程式及傳回 m 否则 如果 t > p[m] 则 s ← m + 1 否则 e ← m - 1 傳回 m

(b) 根据上述P的内容。 (i) BS(14:25) 的傳回值是什麼？_________（1分）

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

2021-DSE-ICT 2D-2 70

Provided by dse.life

真题 Paper 2a(英文)

2021-DSE ICT PAPER 2A

HONG KONG EXAMINATIONS AND ASSESSMENT AUTHORITY HONG KONG DIPLOMA OF SECONDARY EDUCATION EXAMINATION 2021

INFORMATION AND COMMUNICATION TECHNOLOGY PAPER 2A Databases Question-Answer Book

11:15 am – 12:45 pm (1 hour 30 minutes)

This paper must be answered in English

INSTRUCTIONS

(1) After the announcement of the start of the examination, you should first write your Candidate Number in the space provided on Page 1 and stick barcode labels in the spaces provided on Pages 1, 3, 5 and 7.

(2) Answer THREE out of four questions. Write your answers in the spaces provided in this Question-Answer book. Do not write in the margins. Answers written in the margins will not be marked.

(3) Supplementary answer sheets will be supplied on request. Write your candidate number, mark the question number box and stick a barcode label on each sheet, and fasten them with string INSIDE this book.

(4) No extra time will be given to candidates for sticking on the barcode labels or filling in the question number boxes after the 'Time is up' announcement.

(5) The last page of this Question-Answer book contains SQL commands and symbols used in entity-relationship diagrams which you may find useful.

2021-DSE-ICT 2A-1 27

• A 200 E 0 2 A *

Provided by dse.life

真题 Paper 2b(英文)

2021-DSE ICT PAPER 2B

HONG KONG EXAMINATIONS AND ASSESSMENT AUTHORITY HONG KONG DIPLOMA OF SECONDARY EDUCATION EXAMINATION 2021

INFORMATION AND COMMUNICATION TECHNOLOGY PAPER 2B Data Communications and Networking Question-Answer Book

11:15 am - 12:45 pm (1 hour 30 minutes)

This paper must be answered in English

INSTRUCTIONS

(1) After the announcement of the start of the examination, you should first write your Candidate Number in the space provided on Page 1 and stick barcode labels in the spaces provided on Pages 1, 3, 5 and 7.

(2) Answer THREE out of four questions. Write your answers in the spaces provided in this Question-Answer book. Do not write in the margins. Answers written in the margins will not be marked.

(3) Supplementary answer sheets will be supplied on request. Write your candidate number, mark the question number box and stick a barcode label on each sheet, and fasten them with string INSIDE this book.

(4) No extra time will be given to candidates for sticking on the barcode labels or filling in the question number boxes after the 'Time is up' announcement.

2021-DSE-ICT 2B-1 42

• A 200E 02 B *

Provided by dse.life

真题 Paper 2c(英文)

2021-DSE ICT PAPER 2C

HONG KONG EXAMINATIONS AND ASSESSMENT AUTHORITY HONG KONG DIPLOMA OF SECONDARY EDUCATION EXAMINATION 2021

INFORMATION AND COMMUNICATION TECHNOLOGY PAPER 2C Multimedia Production and Web Site Development Question-Answer Book

11:15 am - 12:45 pm (1 hour 30 minutes)

This paper must be answered in English

INSTRUCTIONS

(1) After the announcement of the start of the examination you should first write your Candidate Number in the space provided on Page 1 and stick barcode labels in the spaces provided on Pages 1, 3, 5 and 7.

(2) Answer THREE out of four questions. Write your answers in the spaces provided in this Question-Answer book. Do not write in the margins. Answers written in the margins will not be marked.

(3) Supplementary answer sheets will be supplied on request. Write your candidate number, mark the question number box and stick a barcode label on each sheet, and fasten them with string INSIDE this book.

(4) No extra time will be given to candidates for sticking on the barcode labels or filling in the question number boxes after the 'Time is up' announcement.

2021-DSE-ICT 2C-I 56

• A 200 E 02 C *

Please stick the barcode label here.

Candidate Number

真题 Paper 2d(英文)

2021-DSE ICT PAPER 2D

HONG KONG EXAMINATIONS AND ASSESSMENT AUTHORITY HONG KONG DIPLOMA OF SECONDARY EDUCATION EXAMINATION 2021

INFORMATION AND COMMUNICATION TECHNOLOGY PAPER 2D Software Development Question-Answer Book

11:15 am - 12:45 pm (1 hour 30 minutes)

This paper must be answered in English

INSTRUCTIONS

(1) After the announcement of the start of the examination, you should first write your Candidate Number in the space provided on Page 1 and stick barcode labels in the spaces provided on Pages 1, 3, 5 and 7.

(2) Answer THREE out of four questions. Write your answers in the spaces provided in this Question-Answer book. Do not write in the margins. Answers written in the margins will not be marked.

(3) Supplementary answer sheets will be supplied on request. Write your candidate number, mark the question number box and stick a barcode label on each sheet, and fasten them with string INSIDE this book.

(4) No extra time will be given to candidates for sticking on the barcode labels or filling in the question number boxes after the 'Time is up' announcement.

2021-DSE-ICT 2D-1 69

Please stick the barcode label here. Candidate Number

• A 200 E 02 D * Provided by dse.life