Technology Mock Test C

Technology Mock Test C
Part A
ICT - Theory
1)Finish the forms
a)
Software licenses
Type Description
● Allow use for trial period

● (Allow/not allow) make copies and distribute
● Only machine at a time
● Download from _______ for free

● (Can/ cannot) sell
● Allow use at a specific location

b)
Protection against unauthorized access
Ways Description
● (Should/ should not) be personal data

● Should consist _________________________________
___________________________________________(4)
● We need to regularly ____________________________

_____________________________________________
● The process of ______________________________ into

_______________________
● Exclude some types of data

● Implemented in ________________________________
2)What are copyrights?
_____________________________________________________________________
3)What are some examples of personal data? (4)
_____________________________________________________________________
4)What are some common types of hacking? (3)
_____________________________________________________________________
_____________________________________________________________________
5)Computer viruses are ______________________________, (some/ all) are harmful.
________________ is an example, it can __________________________.
6)What is cookies?
_____________________________________________________________________
Part B
Python - theory
1)What is the value of A and a respectively? A:_____ a:______
2)Arrange not, or, and in ascending order of priority __________________________
3)Fill in the form
Input to Python
Multiplication Divison
Find the remainder To the power of (2)
Square root Integer division
Make positive Return to integer
Round to n decimal Return to random

place from x to y
Make space Equal
Not equal to Less than or equal to
Continue line Next line

4)Write down the output of the following
Program Output
a) k=1
j=2
while k<=30:
print ('k is',k)
j=j+2
k=j+k
b) for b in range (-3,2):

print(b)
print(b+1)
c) for x in range (1,5+1):
for y in range (1,x+1):
print('*', end='')
print()
for i in range(5,1,-1):
for k in range (i,1,-1):
print('*', end='')
print()
5)Write down the output for the followings, consider each of them has the format of
print(question)
a) ‘Technology’ b) ‘%15s’%‘Technology’ c) ‘%15.4s’%‘Technology’ d) 104.5
e) ‘%f’%104.5 f) ‘%10.3f’%104.5 g) ‘%10.0f’%104.6 h) ‘%d’%104.5 i)
‘%2d’%104.5 j) ‘%10d’%104.5 k) round(2.5) l) round(2.51) m) round(2.25,1)
a)
b)
c)
d)
e)
f)
g)
h)
i)
j)
k) l) m)
6)Determine whether the following holds True or False value (T/F)
a)8>9___ b)8!=9___ c) ‘A’ < ‘a’ ___ d) ‘A’ > ‘B’ ___ e) ‘Apple’ < ‘APPLE’ ___
f) not(7>8) and ‘APPLE’ > ‘A’ ___
Part C
Python - practical
1)Write a program to generate 1 random number from 7,15,23,31,39,47,55,63,71,79
_____________________________________________________________________
_____________________________________________________________________
2)Write the program for the following output
Output Program
a) ***** _________________________________________
**** _________________________________________
*** _________________________________________
_________________________________________
_________________________________________
b) {1.1} {1.2} {1.3} {1.4} _________________________________________

{2.1} {2.2} {2.3} {2.4} _________________________________________
{3.1} {3.2} {3.3} {3.4} _________________________________________
{4.1} {4.2} {4.3} {4.4} _________________________________________
_________________________________________
3)Write a program for this output (use %) (The number after colon are users input)
Input two numbers: 3, 6
The difference of 3 and 6 is 3
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
4)Write the program of HW 7.2 (Refer to Book p.65)
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
7)
for loop while loop
a) for a in range (3,7): ______________________________________

for b in range (1, a+1): ______________________________________
print(“*”, end= “”) ______________________________________
print( ) ______________________________________
______________________________________
______________________________________
______________________________________
______________________________________
______________________________________
b) ________________________ c = 4
________________________ while c>0:
________________________ print(c*3)
________________________ c = c-1
c) ________________________ d = 1
________________________ while d < 4:
________________________ e=1
________________________ while e <= d:
________________________ print(e, end = “” )
________________________ e = e+1
________________________ print( )
d = d+1
Part D
Access - Answer the question with reference to the following data base
1)How many fields are there? _____

2) Fill in the form
______ Class Class_NO HKID Name SEX Pass Captial
Data type
Input
Validation rule:
mask/ /
Format
3)List the Class_NO, Name, Pass for all students of 1X or 2C
a)Using query design
Field
Table
Sort
Show 口口口口
Criteria
or
b)Using SQL language

_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
4)List the Class_No, Name, Capital for all female students that pass in descending
order of Capital with SQL language.
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
5)List the Class, Class_NO, Name, Capital for all male students that fail with SQL
language.
_____________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________

Technology Mock Test C

Uploaded by

Copyright:

Available Formats

Technology Mock Test C

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Technology Mock Test C

Uploaded by

Copyright:

Available Formats

Technology Mock Test C

● Allow use for trial period

● Only machine at a time

● Download from _______ for free

● Allow use at a specific location

● (Should/ should not) be personal data

● We need to regularly ____________________________

● The process of ______________________________ into

● Exclude some types of data

Find the remainder To the power of (2)

Square root Integer division

Make positive Return to integer

Round to n decimal Return to random

Make space Equal

Not equal to Less than or equal to

Continue line Next line

b) for b in range (-3,2):

b) {1.1} {1.2} {1.3} {1.4} _________________________________________

a) for a in range (3,7): ______________________________________

1)How many fields are there? _____

b)Using SQL language

You might also like