Solved SLC Supp. Computer
Science 2066
Supplementary Examination 2066
Group
A
Computer
Fundamentals (22 marks)
1.
Answer the following questions:
a) What is bandwidth?
Ans: The data handling
capacity of a communication system is known as bandwidth.
b) What is network topology?
Ans: The arrangement or
connection pattern of computers or nodes and other devices of the network is
known as network topology.
c) How can multimedia help in
education?
Ans: Multimedia technology
is very much useful in education. It helps to present the information about
various topics in more interesting and interactive way which makes the learner
easy to understand. It helps to give better ideas and concept to the students
with good vocabulary.
d) Write any four safety measures to
protect computer form virus.
Ans: Any four safety
measures to protect computer from viruses are:
i. Write-protect your floppy disk when using them on
other computers.
ii. Do not install pirated software, especially computer
games.
iii. Always scan files downloaded from the internet or
transferred over the network before executing them.
iv. Do not interchange internal disk among the computers.
e) What is computer hardware and
software security?
Ans: The security given to
various hardware tools and equipment from being lost or damaged due to
accidental or intentional harm is known as hardware security. For e.g:
protection from theft, power protection device, etc.
The security given to various
software and data from being lost or damaged due to accidental or intentional
harm is known as software security. For e.g: defragmentation, scan disk, etc.
3. Match the following
Group A Group
B
i) Bandwidth a)
ISP
ii) Internet b)
FAT
iii) Network c)
bps
iv) Software security d)
NAV
e) NIC
Ans:
Group A Group
B
i) Bandwidth - a) bps
ii) Internet - b) ISP
iii) Network - c) NIC
iv) Software security - d)
NAV
4. Choose the correct answer:
a) Which is NOT a guided media?
i) UTP Cable ii) STP Cable iii)
Satellite iv) Fiber Optics
Ans: Satellite
b) Which device is necessary to
operate internet?
i) CD-ROM ii) ISP iii) MODEM iv) All of the above
Ans: MODEM
c)Modem converts
i) Sound into digital ii) Digital into sound iii) Both i) and ii)
iv) None
Ans: Both i) and ii)
d) Which is not an internet service?
i) e-mail ii) e-telephone iii)e-fax iv) e-commerce
Ans: e-telephone
5. Write the technical terms of the
following:
a) Making extra copies of data or
program.
Ans: Backup
b) A card used to connect network cable to computer.
Ans: NIC (Network Interface Card)
c) Device used for power protection.
Ans: Volt guard
d) Program used to detect and
eliminate computer virus.
Ans: Anti-virus
6. Write the full forms of:
a) WWW- World Wide Web
b) UPS- Uninterruptible Power Supply
c) NOS- Network Interface Card
d) UTP- Unshielded Twisted Pair
Group B
Database (10 marks)
7. Answer the following questions:
a) Define database.
Ans: Database is a
collection of related and organized information that is used to store, organize
and extract data.
b) Write any four data type used in
MS-Access.
Ans: Any four data types
used in MS-Access are as follows:
i. Number
ii. Text
iii. Memo
iv. Auto Number
c) What is query?
Ans: Query is an object of
MS-Access which allows selecting specific data from one or more tables.
8. State whether the following
statements are true or false:
a) Primary key does not accept null
value. True
b) The extension of database file created by MS-Access is .BDF. False
c) Memo data type cannot be indexed. True
d) The default size of text data type is 50.True
9. Match the following: Group A Group B
a) OLE i)
Formatted output
b) Primary key ii)
Interface
c) Form iii)
64,000 characters
d) Report iv) Unique Field
v) Picture
Ans:
Group A Group B
a) OLE - Picture
b) Primary key - Unique
Field
c) Form - Interface
d) Report - Formatted
output
Group C
Programming (18 marks)
10. a) What
is user defined function?
Ans: The function which is
defined by the user according to the need is known as user-defined function.
b) List any two data types
used in C language.
Ans: The data types used in C
language are:
· Char
· Int
c) Write down the function
of the following statements:
i) KILL ii) FILES
Ans: The function of:
i. KILL: It deletes the file
or files from the specified drive and directory.
ii. FILES: It displays all the
files of the current subdirectory or specified sub directory.
11. Write the output of the given program:
DECLARE SUB Result
CALL Result
END
SUB Result
For I = 1 to 9 STEP 2
Sum=Sum +I^2
Next I
PRINT Sum
END SUB
Ans:- OUTPUT
165
12. Rewrite the following program after correcting the
bugs:REM to store Name, post and salary
OPENEMP.DOCFOROUTAS#1
INPUT “Enter Name”; N
INPUT “Enter post”; P$
INPUT “Enter salary”; S
WRITE #2, N$,P$,S
CLOSE #1
END
Ans:
REM to store Name, post and
salary
OPEN “EMP.DOC” FOR OUTPUT AS #1
INPUT “Enter Name”; N$
INPUT “Enter post”; P$
INPUT “Enter salary”; S
WRITE #1, N$,P$,S
CLOSE #1
END
13. Study the following program and
answer the following questions:
DECLARE FUNCTION COUNT(A$)
Input “Enter a word”; W$
END
Function Count(A$)
B=LEN(A$)
C$=UCASE$(A$)
FOR I=1 TO B
E$=MID$(C$,I,1)
IF E$=”A” OR E$=”E” OR E$=”I” OR E$=”O”
OR E$=”U” THEN C=C+1
END IF
NEXT I
COUNT=C
END FUNCTION
a) List the string Library functions used in the above program.
Ans: The string Library
functions used in the above program are as follows:
· LEN
· MID$
· UCASE$
b) Write down the missing statements
in the main module to execute the program.
Ans: The missing statements
in the main module to execute the program is :
PRINT COUNT(W$).
14. a) Write a program using
FUNCTION…..END FUNCTION to find the average of any two numbers given by the
user.
Ans:
DECALRE FUNCTION AVE(A,B)
CLS
INPUT “Enter any two numbers”; A,B
PRINT “The average of two numbers=”;
AVE(A,B)
END
FUNCTION AVE(A,B)
AV=(A+B)/2
AVE=AV
END FUNCTION
b) Write a program using
SUB……END SUB to check whether the number given by the user is positive or
negative.
Ans:
DECLARE SUB CHECK(N)
CLS
INPUT ”Enter any number”; N
CALL CHECK(N)
END
SUB CHECK(N)
IF N>0 THEN
PRINT N;”is positive number”
ELSEIF N<0 THEN
PRINT N;”is negative number”
END IF
END SUB
c) A data file “LIB.TXT”
consists of book’s name, author’s name and price of books. Write a program to
count and display the total number of records present in the file.
Ans:
OPEN “LIB.TXT” FOR INPUT AS #1
CLS
WHILE NOT EOF(1)
INPUT #1, N$, A$, P
C=C+1
WEND
PRINT “The total number of records=”;
C
CLOSE #1
END
***
No comments:
Post a Comment