HKACE-ICT MOCK EXAM 2025-1A

Which of the following is a lossless file format?

(1) PNG

(2) JPG

(3) BMP

• (1) only

• (2) only

• (1) and (3) only

• (2) and (3) only

Tags

difficult

Which of the following is not vector image file format?

• TIF

• AI

• WMF

• SVG

Tags

difficult

Which of the following is the upper bound of the positive representation and the lower bound of the negative number representation in 8-bit two's complement?

• A. 0000 0000 and 1111 1111

• B. 0000 0001 and 1111 1110

• C. 0111 1111 and 1000 0000

• D. 0111 1111 and 1111 1111

Which SQL statement should be used to retrieve all orders placed on July 2, 2024?

• SELECT * FROM meal_orders WHERE order_date > '2024-07-02';

• SELECT * FROM meal_orders WHERE order_date LIKE '2024-07-0_';

• SELECT * FROM meal_orders WHERE order_date = 02/07/2024;

• SELECT * FROM meal_orders WHERE order_date = '2024-07-02';

When designing a database input form, which of the following can improve the user experience?

1. (1) Increasing the aesthetic appeal of the form.

2. (2) Adding detailed explanatory text.

3. (3) Providing real-time error feedback.

• (1) and (2) only

• (1) and (3) only

• (2) and (3) only

• (1), (2) and (3)

In the database, P, Q, and R are used for storing data, inputting data and displaying data. What would they be?

• P: database form

  Q: database table

  R: database report

• P: database table

  Q: database form

  R: database report

• P: database form

  Q: database report

  R: database table

• P: database report

  Q: database table

  R: database form

Which of the following statements about information processing is correct?

• A. Online booking involves data collection process.

• B. Hosting a virtual meeting is a data organization process.

• C. Digital ID application involves data presentation process.

• D. Completion of an online payment is a data analysis process.

John wants to send a text file in traditional Chinese to his French friend Sam. Sam used the ASCII character set to read the file. What should Sam do to get the highest chance to read the text file properly?

• Ask John to resend the message in ASCII format.

• Change his character encoding setting to UTF-8.

• Convert the message to binary format.

• Use file recovery software to fix the file.

Mrs Yeung uses the spreadsheet above to store the movie ticket sales records. Which of the following actions could list the records by the nearest date?

• What-if Analysis

• Searching

• Sorting

• XLOOKUP

She wants to create a pivot table to find the number of tickets sold for each movie. In which of the following areas should the field ‘Quantity’ be put?

• FILTERS

• COLUMNS

• ROWS

• VALUES

Tags

difficult