2425 F6 Mock P1A (Modified v1)

Front

1011 0110 is an 8-bit binary number using two’s complement representation. What is the equivalent decimal number?

Back

-74

Tags

difficult

Front

Which of the following 8-bit two’s complement calculations would result in an overflow error? 1000 1011 + 1011 1101, 1111 0000 + 0000 1111, 0101 0101 + 0010 1010, 1000 0001 + 0111 1111

Back

1000 1011 + 1011 1101

Front

A sender transmits the code to the receiver using even parity check. Which of the following codes is valid? A. 0100 0101, B. 1101 0000, C. 1111 1101, D. 0001 0001

Back

0001 0001

Front

Which scenario can be represented by the chart? Options: A. The temperature during different times in a day. B. The number of students in each class who passed the exam. C. The total number of students in the school. D. The Chinese and English test scores of different students in a class.

Back

The number of students in each class who passed the exam.

Front

The following formula is stored in cell D1 and copied to cell E2: =SUM($A1:B$3) What is the result in cell E2?

Back

194

Front

Which formula should be entered in cell C2 to mark students eligible for a mathematics contest (score of 80 or above) as “Y” and others as “N”?

Back

= IF(B2<80, “N”, “Y”)

Front

Which tool should Mr Chan use to organise the list so that those who are eligible are shown first? Options: AutoFill, Sorting, Filtering, Scenario manager.

Back

Sorting

Front

Result of the formula: =AVERAGE (XLOOKUP (A1, A1:A4, C1:C4) : XLOOKUP (A2, A1:A4, C1:C4))

Back

15

Front

Mandy is developing a database to store employee information, including record ID, employee names, HKID, age, and job titles. Which data types should Mandy use to store the relevant employee data?

Back

RecordID: AutoNumber, Employee Name: Text, HKID: Text, Age: Integer, Job Title: Text

Front

In a shared database environment, which action should be restricted by the database management system? (1) If Alice is updating a record, Bob should not delete the same record. (2) If Alice is viewing a report, Bob should not view a different report. (3) If Alice is inserting a new record, Bob should not update a different record.

Back

If Alice is updating a record, Bob should not delete the same record.

Tags

difficult