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

---

答案(中文)

卷一（甲部）

题號 答案 题号 答案
1. B(44%) 21. D(69%) 2. B(71%) 22. A(61%) 3. C(54%) 23. C(49%) 4. A(75%) 24. D(56%) 5. C(79%) 25. 6. B(49%) 26. C(55%) 7. D(33%) 27. A(82%) 8. A(87%) 28. A(41%) 9. B(70%) 29. D(81%) 10. D(70%) 30. 11. C(87%) 31. C(50%) 12. B(59%) 32. B(66%) 13. D(52%) 33. D(69%) 14. C(84%) 34. C(80%) 15. A(52%) 35. C(94%) 16. A(85%) 36. D(87%) 17. A(38%) 37. B(67%) 18. D(30%) 38. B(81%) 19. A(38%) 39. B(83%) 20. B(44%) 40. C(88%)

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

Provided by dse.life

答案(英文)

Paper 1 (Section A)

Question No. Key Question No. Key

1. B (44%) 21. D (69%)

2. B (71%) 22. B (73%)

3. C (54%) 23. A (61%)

4. A (75%) 24. C (49%)

5. C (79%) 25. D (56%)

6. B (49%) 26. C (55%)

7. D (33%) 27. A (82%)

8. A (87%) 28. A (54%)

9. B (70%) 29. A (41%)

10. D (70%) 30. D (81%)

11. C (87%) 31. C (50%)

12. B (59%) 32. B (66%)

13. D (52%) 33. D (69%)

14. C (84%) 34. C (80%)

15. A (52%) 35. C (94%)

16. A (85%) 36. D (87%)

17. A (38%) 37. B (67%)

18. D (30%) 38. B (81%)

19. A (38%) 39. B (83%)

20. B (44%) 40. C (88%)

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

Provided by dse.life

真题 Paper 1(中文)

2019-DSE 資訊及 通訊科技 卷一 (甲部)

香港考試及評核局 2019年香港中學文憑考試

資訊及通訊科技 試卷一

本試卷必須用中文作答 兩小時完卷（上午八時三十分至上午十時三十分）

考生须知 (一) 本卷分甲、乙兩部。 (二) 甲部為多項選擇題，見於本試卷內；乙部的試題另見於試題答题簿內。 (三) 甲部的答案須填在多項選擇題的答题紙上，而乙部的答案則須寫在試題答题簿中预留的空位內。考試完畢，甲部的答题纸與乙部的试题答题薄须分别缴交。

甲部的考生须知（多项选择题） (一) 細讀答题纸上的指示。宣布開考後，考生須首先於適當位置貼上電腦條碼及填上各项所需资料。宣布停筆後，考生不會獲得額外時間貼上電腦條碼。 (二) 試場主任宣布開卷後，考生须检查试题有否缺漏，最後一题之后應有「甲部完」字樣。 (三) 本试卷各题估分相等。 (四) 本试卷全部试题均须回答。為便於修正答案，考生宜用 HB 铅笔把答案填在答题纸上。錯误答案可用潔淨膠擦將筆痕徹底擦去。考生须清楚填答案，否则會因答案未能被辨認而失分。 (五) 每题只可填一个答案，若填多个答案，则该题不给分。 (六) 答案错误，不另扣分。

考试结束前不可将试卷带离考场

Provided by dse.life

真题 Paper 1(英文)

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

1. Which of the following statements about two's complement is/are correct? (1) Overflow errors will not occur in arithmetic operations. (2) The maximum value for an 8-bit number is 0111 1111. (3) The minimum value for an 8-bit number is 1111 1111. A. (1) only B. (2) only C. (1) and (3) only D. (2) and (3) only

2. Peter creates a school newsletter and posts it on a web page. The newsletter is in portable document format (PDF) instead of word document format because (1) hyperlinks can be included. (2) the newsletter will be displayed in the same way on any device. (3) the resolution of images in the newsletter will be higher. A. (1) only B. (2) only C. (1) and (3) only D. (2) and (3) only

3. In order for a factory manager to decide on the number of machines to be bought to produce pencils, he needs to consider time and cost constraints. What spreadsheet feature should he use to do this? A. Pivot table B. Multiple worksheets C. 'What-if' analysis D. Sorting data using multiple criteria

4. Mary uses a text editor to enter the following 5 traditional Chinese characters and saves them in a text file. The file size is 10 bytes.

世上無難事

Which of the following statements about the text file is/are correct? (1) Each Chinese character occupies 2 bytes. (2) ASCII code is used to represent the characters. (3) The text file does not support Big-5 code. A. (1) only B. (2) only C. (1) and (3) only D. (2) and (3) only

2019-DSE-ICT IA-2

真题 Paper 2a(中文)

2019-DSE 資訊及 通訊科技 卷二(A)

香港考試及評核局 2019年香港中學文憑考試

資訊及通訊科技 試卷二（A） 數據庫 試題答題簿

本試卷必須用中文作答 一小時三十分鐘完卷 (上午十一時十五分至下午十二時四十五分)

考生须知 (一) 宣布開考後，考生須首先在第1頁之適當位置填寫考生編號，並在第1、3、5及7頁之適當位置貼上電腦條碼。

(二) 本試卷全部試題均須回答。答案須寫在本試題答题薄中预留的位置内。不可在各頁邊界以外位置寫寫。於邊界以外的答案，將不予評閱。

(三) 如有需要，可要求派發補充答题纸。每一張紙張均須填寫考生編號、填寫试题编号方格、贴上電腦條碼，並用绳綁於膠內。

(四) 試場主任宣布停筆後，考生不得携得和外時間貼上電腦條碼及填寫试题编号方格。

(五) 本试题答题薄末页附有SQL指令及實驗關係圖所採用的符號以供參考。

請在此貼上電腦條碼

考生编號

Provided by dse.life

真题 Paper 2b(中文)

2019-DSE 資訊及 通訊科技 卷二(B)

香港考試及評核局 2019年香港中學文憑考試

資訊及通訊科技 試卷二（B） 數據通訊及建網 試題答題簿

本試卷必須用中文作答 一小時三十分鐘完卷 (上午十一時十五分至下午十二時四十五分)

考生须知 (一) 宣布開考後，考生須首先在第1頁之適當位置填寫考生編號，並在第1、3及5頁之適當位置貼上電腦條碼。

(二) 本試卷全部試題均須回答。答案須寫在本試題答题薄中预留的空位內。不可在各頁邊界以外位置書寫。寫於邊界以外的答案，將不予評閱。

(三) 如有需要，可要求派發補充答题紙。每一張張均須填寫考生編號、填寫試題編號方格、貼上電腦條碼，並用繩綁於膠內。

(四) 試場主任宣布停筆後，考生不會獲得額外時間貼上電腦條碼及填寫試題編號方格。

請在此貼上電腦條碼

考生編號

Provided by dse.life

真题 Paper 2c(中文)

2019-DSE 資訊及通訊科技 卷二（C） 香港考試及評核局 2019年香港中學文憑考試

資訊及通訊科技 試卷二（C） 多媒體製作及網站建構 試題答題簿

本試卷必須用中文作答 一小時三十分鐘完卷 (上午十一時十五分至下午十二時四十五分)

考生须知 (一) 宣布開考後，考生須首先在第1頁之適當位置填寫考生編號，並在第1、3、5及7頁之適當位置貼上電腦條碼。 (二) 本試卷全部試題均須回答。答案須寫在本試題答题簿中预留的空位內。不可在各頁邊界以外位置書寫。寫於邊界以外的答案，將不予評閱。 (三) 如有需要，可要求派發補充答題紙。每一張張均須填寫考生編號、填畫試題編號方格、貼上電腦條碼，並用繩綁於簿內。 (四) 試場主任宣布停筆後，考生不會獲得額外時間貼上電腦條碼及填畫試題編號方格。

請在此貼上電腦條碼 考生編號

Provided by dse.life

真题 Paper 2d(中文)

2019-DSE 資訊及 通訊科技 卷二(D)

香港考試及評核局 2019年香港中學文憑考試

資訊及通訊科技 試卷二（D） 設計開發 試題答題簿

本試卷必須用中文作答 一小時三十分鐘完卷 (上午十一時十五分至下午十二時四十五分)

考生须知 (一) 宣布開考後，考生須首先在第1頁之適當位置填寫考生編號，並在第1、3、5及7頁之適當位置貼上電腦條碼。

(二) 本試卷全部試題均須回答。答案須寫在本試題答題簿中預留的空位內。不可在各頁邊界以外位置書寫。寫於邊界以外的答案，將不予評閱。

(三) 如有需要，可要求派發補充答題紙。每一張報均須填寫考生編號、填畫試題編號方格、貼上電腦條碼，並用縛綿於屬內。

(四) 試場主任宣布停筆後，考生不會獲得額外時間貼上電腦條碼及填畫試題編號方格。

2019-DSE-ICT 2D-1 63 * A200C02D Provided by dse.life

真题 Paper 2a(英文)

Answer all questions.

A park hires an IT project team to develop a system to monitor plants in the park. Members of the team include Mary, Peter and Eva. They are involved in various stages of the database application development lifecycle for the project.

(a) Mary is a database administrator, Peter is a database developer and Eva is a data entry operator. Identify the person-in-charge of each of the following stages.

Stage of the development lifecycle	Person-in-charge
Application and database design
Data migration
Operational maintenance

(3 marks)

(b) (i) Suggest a deliverable for each of the following stages. Application and database design stage: _________ Prototyping stage: _________ Testing stage: ___________ (3 marks)

(ii) In what situation will data migration be carried out? ____ (1 mark)

(iii) Give another stage that should be carried out before the 'Database Management System (DBMS) selection', other than the stages in (a). (1 mark)

Answer within the box.

真题 Paper 2b(英文)

Answer all questions.

1. A school plans to build a computer network so that students can access learning materials on the campus. Part of the layout of a floor is shown below. X and Y are a switch and an access point (AP) respectively.

Internet router Server room 3 Classrooms

(a) (i) Briefly explain why X should be a switch instead of a hub. (1 mark)

(ii) Y is used to connect the devices in classrooms to the network. Give two technical reasons why Y should be an AP instead of a switch. (2 marks)

(b) The network bandwidth is 10 Gbps and the specifications of the AP are

Frequency: 2.4 GHz / 5 GHz Number of connections: 100 Throughput: 1.2 Gbps

(i) Give one advantage of using each frequency. 2.4 GHz: 5 GHz:

(2 marks)

(ii) There are 32 mobile devices in each classroom and all mobile devices are connected to the AP. Estimate the average bandwidth of each connection. Show your calculation. (2 marks)

Provided by dse.life

真题 Paper 2c(英文)

Answer all questions.

1. Peter is a musician who can play different instruments. (a) He stores the music he plays as a MIDI file because it has a small file size and is easily edited. (i) Give another reason to support Peter's choice. (1 mark)

(ii) Explain briefly why a MIDI file can be easily edited. (2 marks)

Peter creates a web page and uploads the videos of his music performance for visitors to watch, as follows:

Peter's Blog My latest music Show on 1.3.2017 Show on 5.8.2018 Show on 24.12.2018 Click on the thumbnails to watch my shows.

(b) Peter wants blind people to be able to select the shows from the thumbnails easily. What web design feature should he apply to enable this? Describe how the design feature is used. (2 marks)

Provided by dse.life

真题 Paper 2d(英文)

Answer all questions.

1. Peter uses stacks to manage boxes. Each box stores some apples. In the following example, a stack contains 3 boxes with 10, 20 and 30 apples.

Below are the operations on the stacks:

Operation Description Push(S, k) Push a box with k apples into stack S. Pop(S) Remove a box from stack S and return the number of apples in the box. Empty(S) Return TRUE if stack S has no boxes in it; otherwise, return FALSE.

(a) (i) Initially there is an empty stack A. Write down the final content of A after executing the following pseudocode.

Push(A, 10) Push(A, 20) TMP ← Pop(A) if Empty(A) then Push(A, 30)

Bottom of A

(ii) Initially there is an empty stack B. Write down the final content of B after executing the following pseudocode.

Push(B, 10) Push(B, 20) Push(B, 30) Push(B, Pop(B)+Pop(B))

Bottom of B

(2 marks each)

Answers written by me or my teacher