Solved SLC Supp. Computer
Science 2065
Supplementary Exam 2065
Group
A
COMPUTER
FUNDAMENTALS (22 marks)
1. Answer the following
questions:
a) Explain about network topology. Write any two
advantages of computer networking.
Ans: The arrangement or
connection pattern of computers or nodes and other devices of the network is
known as network topology.
Any two advantages of computer networking are :
i. Computer in network share different software packages.
ii. Communication made by computer network is very cheap.
b) What is internet? Write any two advantages of
Internet.
Ans: Internet is a collection of
millions of computers of different types belonging to various networks all over
the world.
Any two advantages of internet are as follows:
i. The internet provides very fast and cheap
communication.
ii. It is easy to access information of different
governments and countries.
c) What is antivirus software? List any two antivirus software.
Ans: Those software which are
designed to detect and remove viruses from the computer system to ensure a
virus free environment is known as anti-virus software.
Any two antivirus software are:
i. Norton Antivirus
ii. McAfee
d) What is multimedia? Write any two applications of it.
Ans: The integration of several
forms of media like audio, video, animation, etc. to present information in
more interactive and understandable way is known as multimedia.
Any two applications of it are as follows:
i. Adding special effects in movies:
Multimedia is used in movies to add special
effects to make movie more realistic and interesting.
ii. Preparing presentation:
Multimedia is used in preparing presentation which helps
to convey information in more interesting and interactive way.
e) What do you mean by software security? Write any two
methods to protect the computer software.
Ans: The security given to
various software or data from being lost or damaged due to accidental or
intentional harm is known as software security.
Any two methods to protect the computer software are:
i. Defragmentation
ii. Scan disk
3. Match
the following:
Group A Group B
i) McAfee a) Supplies continuous power
ii) UPS b)
Internet protocol
iii) Web Browser c) Antivirus software
iv) TCP/IP d) Internet explorer
e)
Computer virus
Ans:
Group A Group B
i) McAfee - a)
Antivirus software
ii) UPS - b) Supplies continuous power
iii) Web Browser - c) Internet
explorer
iv) TCP/IP - d)
Internet Protocol
4. State
whether the statements are True or False
a) MODEM is necessary to access the
internet. False
b) Fiber optics use light to carry a
data signal through cable. True
c) Multimedia does not include
animation. False
d) Cyber ethics are moral principles
that make aware to the computer users. True
5. Give
appropriate technical terms:
a) Network of networks.
Ans: Internet
b) A secret code that gives the user to
access particular program and system.
Ans: Password
c) Use of Internet to buy and sell goods
and services.
Ans: E-commerce
d) The rules and regulations to
systematize the computer related
technology.
Ans: Cyber law
6. Give
the full form:
a) Kbps -
Kilobits per second
b) NIC -
Network Interface Card
c) MODEM- Modulator Demodulator
d) FTP - File Transfer Protocol
Group B
DATABASE
MANAGEMENT (10 marks)
7. Answer the following
a) Define data and database.
Ans: Data can be numbers,
letters or symbols representing facts and figures that may or may not give
complete sense.
Database is a collection of related and organized
information that is used to store, organize and extract data.
b) Name any four data types that can be defined in
MS-ACCESS.
Ans: Any four data types that
can be defined in MS-Access are as follows:
i. Number
ii. Text
iii. Memo
iv. Auto number
c) What is a form? Give its importance.
Ans: Form is an object of
MS-Access that provides user friendly interface to enter data in a table or
multiple linked tables.
Importance of form are as follows:
i. It provides an interactive platform for input if data
into the database.
ii. It helps to display data in more presentable form
than a datasheet can.
8. State whether the
following statements are true or false.
a) A query is used to select fields and records from many
tables. True
b) MS-ACCESS is a spread-sheet software. False
c) Index decreases the speed of the query and short
operations. False
d) The data in primary key field need to be unique and
not null. True
9. Match the following:
Group
A Group
B
i)
MS-ACCESS a)
analyze and present data in a printed format
ii) Data
update b)
Query
iii)
Field c)
a piece of information related to someone or something
iv)
Report d)
Database management software
e)
collection of related fields.
Ans:
Group
A Group
B
i)
MS-ACCESS - a)
Database management software
ii) Data
update - b)
Query
iii)
Field - c)
a piece of information related to someone or something
iv)
Report - d)
analyze and present data in a printed format
Group C
Programming(18 marks)
10. a) Define
modular programming.
Ans: Modular programming is a
technique in which a program is divided into different small manageable program
blocks, which are called modules or sub programs.
b) Name
any two data types used in C language.
Ans: Any two data
types of C language are:
· char
· int
c) Give
the functions of NAME and CLOSE statements.
Ans:
NAME: The
function of NAME statement is to rename a file on a diskette
CLOSE: The
function of CLOSE statement is to close one or all open files.
11.
Re-write the given program correcting the bugs:
DECLARE
SUB Series()
CLS
EXECUTE
Series
END
SUB
Series
A=2
B=2
FOR ctr=
1 to 5
DISPLAY
A;B;
A=A+B
B=A+B
LOOP
ctr
END
Series()
Ans:
DECLARE
SUB Series ( )
CLS
CALL Series
END
SUB
Series
A=2
B=2
FOR ctr=
1 to 5
PRINT A;B;
A=A+B
B=A+B
NEXTctr
END SUB
12. Write the output of the following
program.
DECLARE FUNCTION Interest(p,t,r)
CLS
LET p=30
LET t=40
LET r=6
LET d=Interest(p,t,r)
PRINT “The simple interest will be”; d
END
FUNCTION Interest(p,t,r)
answer = (p*t*r)/100
Interest=answer
END FUNCTION
OUTPUT :
The simple interest will be 72
13. Analyse the program
given below and answer the questions:
DECLARE FUNCTION Diff(A,B)
CLS
INPUT “Enter first number”;A
INPUT “Enter second number”;B
PRINT “The difference of the two number=”;Diff(A,B)
END
FUNCTION Diff(A,B)
D=A-B
Diff=D
END FUNCTION
a) What will be the output of the program if the user
enters 200 as the first number and 100 as the second number?
Ans: The output of the above program will be
The
difference of two number = 100
b) Will the program run if the first line (i.e.
DECLARE…..) is deleted?
Ans: Yes, the program will run
if the first line (i.e. DECLARE…) is deleted.
14.a) Write a program using
FUNCTION….END FUNCTION to get a word from the user and print the word in the
reverse order.
Ans:
DECLARE FUNCTION REV$(S$)
CLS
INPUT “Enter any word”; S$
PRINT “The reverse word is”; REV$(S$)
END
FUNCTION REV$(S$)
FOR I = LEN(S$) TO 1 STEP -1
B$=MID$(S$, I, 1)
W$=W$+B$
NEXT I
REV$=W$
END FUNCTION
b) Write a program using SUB….END SUB to get radius of
the circle and display the area.
Ans:
DECLARE SUB AREA(R)
CLS
CONST PI=3.1416
INPUT ”Enter radius”; R
CALL AREA(R)
END
SUB AREA(R)
A=PI*R^2
PRINT “The area of circle”; A
END SUB
c) A sequential data file called “Marks.dat” contains
roll number, name, English, Nepali, and Maths field. Write a program to display
all the content of the data file.
Ans:
OPEN “MARKS.DAT” FOR INPUT AS #1
CLS
WHILE NOT EOF(1)
INPUT #1, RN, N$, E, N, M
PRINT RN, N$, E, N, M
WEND
CLOSE #1
END
***
No comments:
Post a Comment