COMPUTER SCIENCE SLC 2068 - Solved

Computer Fundamentals (22 marks)
1. Answer the following questions:
a) Define LAN topology and write any two types of LAN topology.
Ans: The arrangement or connection pattern of computers or nodes and other devices of the network is known as LAN topology.
Any two types of LAN topology are
i) Bus topology
ii) Star topology

b) Write any four services of Internet.
Ans: Any four services of internet are
i) E-mail (Electronic mail)
ii) FTP (File Transfer Protocol)
iii) IRC (internet Relay Chat)
iv) E-commerce

c) Write any two advantages of multimedia in education field.
Ans: Any two ad advantages of multimedia in education field are
i) It makes teaching/learning easier in classroom.
iv) It makes presentation of related subject matter attractive.

d) Write any two software security measures.
Ans: Any two software security measures are:
i) Backup
ii) Password

e) Write any four symptoms that show, computer is infected by computer virus.
Ans: Any four symptoms that show, computer is infected by computer virus are :
i) Program takes long time to load.
ii) The floppy disk or hard disk is suddenly accessed without a logical reason.
iii) Increased use of disk space and growth in file size.
iv) Corrupting the system data.

3. Match the following:
Group A Group B
a) Microwave a) Multimedia
b) Volt guard b) Protocol
c) Sound card c) Unguided media
d) TCP/IP d) Power protection devices
e) Guided media
Answers

Group A Group B
a) Microwave Unguided media
b) Volt guard Power protection devices
c) Sound card Multimedia
d) TCP/IP Protocol


4. Select the best answers:
a) Which of the following is not a protocol?
i) POP ii) TCP/IP iii) NOS iv) FTP
NOS


b) Which device protects hardware?
i) UPS ii) MODEM iii) Gateway iv) All of the above
UPS

c) In which communication media data transfer high?
i) Twisted pair ii) Co-axial cable iii) Fiber optics
iv) Microwave
Fiber optics

d) Which computer virus damages the master boot record?
i) Macro virus ii) File virus iii) New folder virus
iv) Boot sector virus
Boot sector virus

5. Write the appropriate technical terms:
a) The device used to connect PC with telephone line.
MODEM

b) The rules that make the network communication possible.
Protocol

c) A program that effect the normal functioning of computer.
Computer Virus

d) A main computer in the computer network.
Server

6. Write down the full forms:
a) bps : bits per second
b) MAN : Metropolitan Area Network
c) FTP : File Transfer Protocol
iv)URL : Uniform Resource Locator

Group B-Database Management(10 marks)
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.Example: telephone directory, dictionary etc.

b) What is data sorting?
Ans: Data sorting means grouping all the records in a table either in ascending or descending order based on a key field of the record.

c) What is a form?
Ans: Form is an object of MS-Access which provides a user friendly interface to enter data in a table or multiple linked tables. It allows user to enter, edit and store the data.

8. Select the best answers:
a) ………………. Is not a data type of MS-Access.
i) Number ii) Text iii) Memo iv) Form
Form


b) Primary key does not accept ……….
i) Text ii) Number iii) Null value iv) None of the above
Null value

c) ……………….. object of access is used to print formatted data.
i) Query ii) Form iii) Report iv) Table
Report

d) In MS-Access data are stored in ………………
i) Form ii) Query iii) Table iv) All of the above
Table

9. Match the following:
Group A Group B
a) Indexing a) Limits the value
b) Report b) Data type
c) Validation Rule c) Error messages
d) Hyper link d) Final output
e) Search fast

Answers
Group A Group B
a) Indexing Search fast
b) Report Final output
c) Validation Rule Limits the value
d) Hyper link Data type

Group C- Programming (18 marks)10. a) What is loop?
Ans: Loop means executing a statement or group of statements a certain number of times depending upon the condition.It may be finite or infinite.

b) List any two data types supported by ‘C’ language.
Ans: Any two data types supported by ‘C’ language are:
i) char
ii) int

c) State the function of the following statement:
i) EOF
Ans: It detects the end of the file marker reading the data from an open sequential file.

ii) MKDIR: It creates a subdirectory which is used to manage files.


11. Re-write the given program after correcting the bugs:
CREATE FUNCTION Square(A)
Rem to print square of a number
CLS
Get “a number”; A
CALL square(A)
END

FUNCTION square(A)
Ans=A^2
Square=Ans
END Square(A)

Debugged Program
DECLARE FUNCTION Square(A)
Rem to print square of a number
CLS
INPUT “a number”; A
PRINT square(A)
END

FUNCTION square(A)
Ans=A^2
Square=Ans
END FUNCTION

13. Analyze the program given below and answer the questions:
Declare function count(N$)
Input “Enter a word”; R$
C= Count(R$)
Print C
END
Function count(N$)
For k=1 to LEN(n$)
X$=MID$(N$,K,1)
IF UCASE$(X$)=”A” then
X=X+1
End if
Next K
Count = X
End function

i) List any two library functions used in the above program.
Ans: Any two library functions used in the above program are
1) UCASE$( )
2) MID$( )

ii) Write the use of variable ‘C’ inline 3 [i.e. C=Count(R$)] given in the above program.Ans: The use of variable ‘C’ inline 3 [i.e. C=Count(R$)] given in the above program is to call the function and store the value returned by the function count.

14. a) Write a program to calculate the area of four walls using SUB…END SUB.
DECLARE SUB AREA (L, B, H)
CLS
INPUT “ENTER LENGTH”; L
INPUT “ENTER BREADTH”; B
INPUT “ENTER HEIGHT”; H
CALL AREA (L, B, H)
END
SUB AREA(L, B, H)
A = 2 * H * (L + B)
PRINT “AREA OF FOUR WALLS=”; A
END SUB

b) Write a program using FUNCTION…..END FUNCTION to get a word from the user and print it in reverse order.
DECLARE FUNCTION REV$ (S$)
CLS
INPUT "ENTER ANY WORD"; S$
PRINT "REVERSED 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


c) A sequential data file called “student.dat” contains some records under the field’s name, English, Nepali and Computer. Write a program to add some more records in the same sequential data file.

OPEN “student.dat” FOR APPEND AS #1
DO
CLS
INPUT “ENTER NAME”; N$
INPUT “ENTER MARKS IN ENGLISH”; E
INPUT “ENTER MARKS IN NEPALI”; N
INPUT “ENTER MARKS IN COMPUTER”; C
WRITE #1, N$, E, N, C
INPUT “DO YOU WANT TO CONTINUE”; CH$
LOOP WHILE UCASE$(CH$) = “Y”
CLOSE #1
END