CHIU LUT SAU MEMORIAL SECONDARY SCHOOL 2010 2011 S.4 Information and Communication Technology Second Term Test 1

typoweheeElectronics - Devices

Nov 8, 2013 (3 years and 9 months ago)

62 views

1011
/CLSMSS/S
4
/
Test2
-
1


P.
1
(
4
)


CHIU LUT SAU MEMORIAL SECONDARY SCHOOL

20
10


20
11

S.4 Information and Communication Technology

Second
Term
Test 1


Name:



Mark: __________ / 40

Class:

( )


Date:



Time allowed: 45 mins


Section A: Multiple Choice Questions (15 marks)

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15


















1.

Which of the following is a main application of a
super computer?


A.

Word Processing

B.

Weather forecast

C.

Database management

D.

Web site hosting



2.

Arrange the following computers
in descending
order

of average compu
tational power.

(I)

Desktop Computer

(II)

Super Computer

(III)

Notebook Computer

(IV)

Handheld Computer


A.

(IV) > (III) > (I) > (II)

B.

(II) > (I) > (III) > (IV)

C.

(III) > (IV) > (I) > (II)

D.

(II) > (I) > (IV) > (III)



3.

Which of the following is NOT real
-
time system?


A.

Video conferenci
ng system

B.

Point of Sale (POS) system

C.

Automatic Teller Machine (ATM)

D.

Payroll System



4.

Which of the following storage media supports
sequential access?

(I)

Hard Disk

(II)

Magnetic Tape

(III)

USB Drive


A.

(II) Only

B.

(I) amd (III) only

C.

(II) and (III) only

D.

(I), (II) and (III)



5.

Which of the following devices have
microprocessor inside?

(I)

Netbook computer

(II)

Personal Digital Assistant (PDA)

(III)

Smartphone


A.

(I) and (II) only

B.

(II) and (III) only

C.

(I) and (III) only

D.

(I), (II) and (III)



6.

Which of the following should NOT be a feature of
a main
frame computer?


A.

Huge storage space

B.

Multiple processors

C.

High 3D computing power

D.

Large physical size



7.

Which of the following are applications of a
parallel computer
?

(I)

Running multiple independent tasks at the
same time

(II)

Running a process on multiple computer
s

(III)

Running a process with high degree of
pipelining


A.

(I) and (II) only

B.

(II) and (III) only

C.

(I) and (III) only

D.

(I), (II) and (III)



8.

A network computer



A.


is more powerful than a workstation.

B.


can process only a single task at a time.

C.


is able to access netw
ork resources.

D.


has high mobility.


1011
/CLSMSS/S
4
/
Test2
-
1


P.
2
(
4
)


9.

Which of the following is NOT a function of a
database management system?


A.

Query of Data

B.

Sorting of Records

C.

Creating Charts

D.

Generating Reports



10.

Arrange the following levels of data
hierarchy

in
ascending order
:

(I)

Database

(II)

Field

(III)

Record

(IV)

Table


A.

(III) < (II) < (IV) < (I)

B.

(I) < (IV) < (III) < (II)

C.

(II) < (III) < (IV) < (I)

D.

(II) < (I) < (III) < (IV)


11.

Suppose
odd

parity check is used, which of the
following data is
valid
?

(I)

0111 1110 1

(II)

1010 0111 0

(III)

0100 0100 0


A.

(I) and (II) only

B.

(II
) and (III) only

C.

(I) and (III) only

D.

(I), (II) and (III)


12.

Double entry is



A.

a verification check

B.

a validation check

C.

a transcription error

D.

a transposition error

13.

Mr. Leung
is entering the ages of some students
into an information system.

The following are
7
entries:

500 10.5 qw 12 9+ 1e 7


If the validation rule for age is

an integer greater
than or equal to 8

, how many entries above will be
accepted

by the system?


A.

2

B.

3

C.

4

D.

5




Refer to the table below to answer question 14
-
15


Table
:
Customers

Custo
merID

Name

Sex

Phone

0932410

Alice Wong

F

24567890

1103425

Felix Choi

M

24152635

0841166

Joanne Sze

F

24785236


14.

Which of the following is a
suitable data type

for
the field

N
ame”
?


A.

Boolean

B.

Text / Character

C.

Number / Integer

D.

Date


15.

How many
records

are t
here in the table?


A.

1

B.

3

C.

4

D.

12





Section B: Long Questions (25 marks)

1.

Henry is moving to a hostel and he wants to buy a new computer to use in his room.

a)

Give TWO advantages of
desktop computer

over
notebook computer
. Explain briefly.
(4 marks)











1011
/CLSMSS/S
4
/
Test2
-
1


P.
3
(
4
)


b)

Henry wants to buy a
notebook computer

so that he can use the computer in the lesson. Ida
suggests that a
tablet computer

may be a better choice for him.







Which one do you suggest Henry to buy? Give TWO reasons to support your choice.

(2 marks)











c)

Is online air ticket reservation system a batch processing system or a real
-
time system? Explain
briefly.

(2 marks)







d)

Briefly describe what a
distributed processing system

is.

(2 marks)








2.

Miss Tsang is running a tutorial school, and she use
s an information system to store and process data
of her students. The database contains a table to store students


particulars. The structure of the
table is shown below:

Field Name

Data Type

Field Length

Remarks

Student_ID

???

???

Key Field

Name

Char
acter

30


Sex

Character

1


Age

Integer

---


Phone_No

Character

8


a)

Give two requirements of the value in key field.

(2 marks)







(A Tablet Computer)

(A Notebook Computer)

1011
/CLSMSS/S
4
/
Test2
-
1


P.
4
(
4
)


b)

Which data type,
Character

or
Integer
, is more suitable to store the value of

Student_ID

?
Give TWO reasons to support
your choice.

(3 marks)









c)

It is suggested that
Age

should not be stored in the table, because everyone

s age changes every
year. Suggest another
piece

of personal information to replace
Age
.

(1 mark)




Data input to the information system must be va
lidated and verified before storing into the database.

d)

What is data validation? Describe briefly.

(2 marks)









e)

State THREE validation checks. Also give an example for each check.

(6 marks)













f)

What kind of error CANNOT be checked by validati
on and verification?

(1 mark)




~ END OF PAPER ~