SLC Supplementary 2071
1. Answer the following questions.
a) What is computer network? List any two
advantages of computer network.
Ans: A group of interconnected computers through transmission media in order to
communicate and share resources like hardware,
data and software.
Any two advantages of computer network are as
follows:
i) The computers on a network can share
hardware devices like printer, hard disk, scanner
etc.
ii) File can be transferred from one computer to
another in a network.
b) What is antivirus? Name any two examples of
antivirus software
Ans: Antivirus software is software designed to
detect and remove virus from computer system o ensure virus free environment.
Any two examples of antivirus software are:
i) Kaspersky ii) NOD32
c) What is hardware security? Name any two
software security measures.
Ans: The security given to the various hardware
tools or equipment from being lost or damaged
due to accidental or intention is known as
hardware security.
Any two software security measures are:
i) Password
ii) Backup
d) Give the importance of MODEM to the
computer network.
Ans: The importance of MODEM to the computer
network is that it transfers data from one
computer to another through telephone line and
access internet as well as performs modulation
and demodulation process.
e) What is internet?
Ans: Internet is an interconnection of several
thousands of computers of different types
belonging to the various networks all over the
world.
2a. Convert as instructed
i) (74)₈ to decimal
Solⁿ :
=7×8¹ + 4×8¹
=7×8 + 4×1
=56 + 4
= 60
(74)₈ = (60)₁₀
ii) (FAC)₁₆ into binary
Solⁿ :
Converting hexadecimal to binary,
F = 1111
A = 1010
C = 1100
(FAC)₁₆ =(111110101100)₂
b. Perform the binary calculations.
i) 111×11
1 1 1
× 1 1
_____
1 1 1
+1 1 1 ×
_________
1 0 1 0 1
111×11 = 10101
ii) 1 0 1 – 1 1
1 0 1
- 1 1
_____
1 0
101-11 = 10
3. Match the following.
Group A Group B
a) Node i) Workstation
b) Server ii) HTTP
c) Coaxial cable iii) Repeater
d) Protocol iv) Main computer
v) communication media
Answers:
Group A Group B
a) Node 👉 i) Workstation
b) Server 👉 ii) Main computer
c) Coaxial cable 👉 iii) communication media
d) Protocol 👉 iv) HTTP
4. Select the correct answer.
a) Which refers to the communication media?
i) UTP cable ii) Fiber optic iii)
Microwave iv)✓ All of the above
b) Which one is not a type of virus?
i) Message carrying virus ii) Boot
Sector virus iii) System Infector
iv)✓ Special purpose application infector
c) E-commerce
i)✓ is a type of business ii) is a type of virus iii) Both (i) and (ii) iv) None of the above
d) Which one is an example of unbound media?
i) UTP cable ii)✓Microwave transmission iii) Fiber optic cable iv) All of the above
5. Give appropriate technical terms for the
following:
a) Physical layout of LAN. Topology
b) A card through which a computer is connected to the network. NIC (Network Interface Card)
c) Network of networks. Internet
d) The moral principles that control cyber crime.
Computer ethics
6. Write the full form of:
a) SMTP : Simple Mail Transfer Protocol
b) NOS : Network Operating System
c) ISP : Internet Service Provider
d) ICT : Information and Communication Technology
Group B [Database Management]
7. Answer the following questions:
a) What is database?
Ans: Database is a collection of related and
organized information that can be used for
different purpose.
b) What is report? Write its importance.
Ans: Report is an object of database which
displays the output in an effective way to present the data in a printed format.
The importance of report is that it prints
documents according to user’s specifications of
the summarized information through query or
table.
c) What is Primary key?
Ans: Primary key is a field that uniquely
identifies the record which neither accepts
duplicate values nor null values.
8. Match the following.
a) MS-Access i) Data entry and editing interface.
b) Query ii) Electronic spreadsheet
c) Record iii) Tool to retrieve data
from one or more than one tables
d) Form iv) Database management
software
v) Collection of related
fields
Answers
a) MS-Access 👉 i) Database management
software
b) Query 👉 ii) Tool to retrieve data
from one or more than one tables
c) Record 👉 iii) Collection of related fields
d) Form 👉 iv) Data entry and editing interface.
9. Write whether the following statements are
true or false.
a) Table is not the data type of MS-Access. True
b) MS-Access is not a spreadsheet software. True
c) Index increases the speed of query and sort
operations. True
d) Primary key accepts null value. False
Group C [Programming]
10a) Define variable
Ans: The data item whose value changes
during the execution of a program is called
variable.
b) Name any two data types used in C language.
Ans: The name of any two data types sued in C
language are char and int
c) Write the functions of NAME and CLOSE
statements.
i) NAME : The NAME statement renames a
file on a diskette.
ii) CLOSE: The CLOSE statement closes one
or all open files.
11a. Re-write the given program after correcting the bugs:
DECLARE SUB FIBO ( )
CLS
EXECUTE FIBO
END
SUB FIBO
REM Program to generate 2, 2, 4, 6, 10…upto
10 th terms.
A=2
B=2
FOR Ctr = 5 TO 1
DISPLAY A; B;
A=A+B
B=A+B
NEXT Ctr
END FUNCTION
Debugged Program
DECLARE SUB FIBO ( )
CLS
CALL FIBO
END
SUB FIBO
REM Program to generate 2, 2, 4, 6, 10…upto
10 th terms.
A=2
B=2
FOR Ctr = 5 TO 1 STEP-1
PRINT A; B;
A=A+B
B=A+B
NEXT Ctr
END SUB
12. Write the output of the following program:
DECLARE FUNCTION test (N)
CLS
FOR Ctr = 1 TO 3
READ N
Sum = Sum + test (N)
NEXT Ctr
PRINT “The result=”; Sum
DATA 3, 2, 1
END
FUNCTION test (N)
Test = N^2
END FUNCTION
The output will be:
The result = 14
13. Study the following program and answer the
given questions:
DECLARE FUNCTION JPT (N)
FOR ctr = 1 TO 6
READ N
J = JPT (N)
Sum = Sum + J
NEXT ctr
PRINT Sum
DATA 10, 20, 30, 40, 50, 60
END
FUNCTION JPT (N)
IF N MOD 2 = 0 THEN JPT = N
END FUNCTION
a) What is name to the function used in the above
program?
Ans: The name of the function used in the
above program is JPT
b) How many times the function will be executed
in the above program?
Ans: The function will be executed six times.
14a) Write a program using FUNCTION …END
FUNCTION to calculate and display the volume of a cylinder. [Hint: volume of cylinder = PR2H]
DECLARE FUNCTION VOLUME (R)
CLS
INPUT “ENTER RADIUS”; R
PRINT “VOLUME OF SPHERE ”; VOLUME(R)
END
FUNCTION VOLUME (R)
VOLUME = (4 / 3) * 3.14 * R ^ 3
END FUNCTION
b) Write a program using SUB…END SUB to print
the first ten odd numbers.
DECLARE SUB DISPLAY ( )
CLS
CALL DISPLAY ( )
END
SUB DISPLAY ( )
A = 1
FOR I = 1 TO 10
PRINT A
A = A + 1
NEXT I
END SUB
c) A sequential data file called ‘Marks.dat’ has
stored data under the field heading Roll No.,
Name, English, Nepali and Maths. Write a
program to display all the information of those
students whose marks in Nepali is more than 50.
OPEN “Marks.dat’ FOR INPUT AS #1
CLS
WHILE NOT EOF (1)
INPUT #1, R, N$, E, NE, M
IF NE > 50 THEN PRINT N$, E, NE, M
WEND
CLOSE #1
END