Solved SLC Computer Science 2065

Solved SLC Computer Science 2065

SLC Examination-2065(2009)

Computer Fundamental (22 marks)

1.      Answer the following questions

a)      Define star topology with figure.

Ans: The topology in which all computers or the network devices are connected through a central device in the shape of star structure is called star topology.

Diagram of star topology

b)     List out 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)      Define computer ethics.

Ans: Computer ethics is the set of moral principles or code of conducts that should be followed by computer user.

d)     Write down two measures of each to protect computer hardware and software.

Ans: Any two hardware security measures are:

i) Insurance Policy
ii) Power Regulator Device

Any two software security measures are:
i) Backup
ii) Password

e)      What is anti-virus? Write down any two examples of anti-virus software.

Ans: Antivirus software is software designed to detect and remove virus from computer system to ensure virus free environment.

Any two examples of antivirus software are:
i) Kaspersky    ii) NOD32

2.       

3.      Match the following:
Group A                                            Group B
a) Server                                            i) HTTP
b) Node                                              ii) Work station
c) Protocol                                         iii) Main computer
d) Coaxial cable                                iv)Repeater
                                                            v) Communication Media

Answers

Group A                                             Group B
a) Server                                            Main computer
b) Node                                              Work station

c) Protocol                                         HTTP

d) Coaxial cable                                Communication Media

 

4.      Select the best answer:
a)Which refers to the communication media?
i) UTP cable ii) Fiber optic cable      iii) Satellite       iv) All of the above

All of the above

b) Which is the correct Email ID?
i) Yahoo@ramesh ii) Ramesh@yahoo.com          iii) @ramesh.yahoo.com          iv) None of the above

Ramesh@yahoo.com
c) Route of virus transmission:
i) Pen driveii) Microphone             iii) Printer                     iv) Mouse

Pen drive

d) Main component of multimedia is:
i) Floppy disk            ii) Floppy drive                        iii) Sound card             iv) Magnetic tape

Sound card

5) Give appropriate technical terms:
a) A computer network limited within a room.

LAN (Local Area Network)

b) A program that destroys other program

Computer Virus

c) Law regarding internet (or Legal issues of Cyber Space).

Cyber Law

d) Buying and selling products and services online.

E-Commerce

6.      Write the full forms:

a) UPS= Uninterruptible Power Supply

b) TCP =          Transmission Control Protocol

c) STP=          Shielded Twisted Pair

d) NIC= Network Interface Card

Group B-  Database (10 marks)

7.      Answer the following question:
a) What is database?

Ans: Database is a collection of related and organized information that can be used for different purpose.

b) While designing table structure which data types are suitable to store information about teacher’s name, address, salary, and date of birth.

While designing table structure the data types are suitable to store information about

teacher’s name = Text

Address = Memo

Salary = currency

Date of birth = Date / Time

c) Write down any two advantages of Query.

Any two importance of query are:

1.      It allows user to make calculations and change data in automated fashion.

2.      It provides option to delete all the unwanted data matching certain criteria.

8.      Select the best answer:
a) …………… is not the data type of MS-Access.
i) Numberii) Text             iii) Memo         iv) Form

Form

b) …………… is the DBMS.
i) Fox-Proii) MS-Excel                 iii) Lotus-123   iv) All of the above

Fox-pro

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

Null value

d) In MS-Access we enter data using ………….
i) Form ii) Table           iii) Report        iv) Both (i) &(ii)

Both (i) &(ii)

9.      Match the following:
Group AGroup B
a) Query                                 i)Printed format
b) Form                                    ii) Stored data
c) Table                                  iii) Allows view, edit, input data
d) Report                               iv) Extracts the selected record for view
v) DBMS

Answers

Group A                                 Group B
a) Query                                Extracts the selected record for view
b) Form                                  Allows view, edit, input data
c) Table                                  Stores data
d) Report                               Printed format
           

Group C-Programming (18 marks)

10.  a) Write down one difference between function and sub procedure.

Ans: One difference between function and sub procedure is

SUB-procedure	FUNCTION-procedure
SUB-procedure does not return value.	FUNCTION-procedure must return a value.

b) List any two data type used in C language.

Ans: Any two data type used in C language are char and int

c) Write down the functions of:
i) RMDIR       

Ans: It is used to remove or delete only the subdirectories from a disk. It can remove only empty subdirectories.

ii) NAME

Ans: The NAME statement renames a file on a disk.
11.Write the output of:
DECLARE SUB RESULT(A$)
A$ = “EDUCATION”
CALL RESULT(A$)
END

SUB RESULT (A$)
FOR C = 1 TO LEN(A$) STEP 2
X$ = MID$(A$, C, 1)
PRINT X$
NEXT C
END SUB

12.  Re-write the following program after correcting:DECLARE FUNCTION SUM(a,b)
REM Program to sum given two numbers
Input ”Enter first number”; x
Input “Enter second number; y
PRINT SUM(a,b)
END

FUNCTION SUM(x,y)
SUM=a+b
END

Debuged Program

DECLARE FUNCTION SUM (a,b)
REM Program to sum given two numbers
Input ”Enter first number”; x
Input “Enter second number”; y
PRINT SUM (x, y)
END

FUNCTION SUM(a, b)
SUM=a+b
END FUNCTION

13.  Study the following program and answer the following question:
DECLARE FUNCTION xyz(N)
FOR I = 1 TO 5
READ N
Z=xyz(N)
S=S+Z
NEXT I
PRINT S
DATA 10,13,15,4,6
END

FUNCTION xyz(N)
IF N MOD 2=0 THEN xyz=N
END FUNCTION
a) What is the name of the function used in the above program?

Ans: The name of the function used in the above program is xyz.

b) How many times the function will be called in the above program?

Ans: The function will be called five times in the above program.

14.  a) Write a program to store records regarding the information of Book number, Book’s name and Writer’s name in a sequential data file called “Library.dat”.

OPEN “Library.dat” FOR OUTPUT AS #1

DO

CLS

INPUT “ENTER BOOK’S NUMBER”; BN

INPUT “ENTER BOOK’S NAME”; B$

INPUT “ENTER WRITER’S NAME”; N$

WRITE #1, BN, B$, N$

INPUT “DO YOU WANT TO CONTINUE”; CH$

LOOP WHILE UCASE$(CH$) = “Y”

CLOSE #1

END

b) Using FUNCTION……END FUNCTION, write a program to calculate distance travelled by a body. (Hint: s=ut+ (1/2) at²)

 

DECLARE FUNCTION DISTANCE (U,T, A)

CLS

INPUT “ENTER INITIAL VELOCITY, TIME AND ACCELERATION”; U, T, A

PRINT “DISTANCE TRAVELLED BY BODY”; DISTANCE (U, T, A)

END

 

FUNCTION DISTANCE (U, T, A)

DISTANCE = U*T+1/2*A*T^2

END FUNCTION

c) Using SUB……….END sub, write a program to print the following serial 9, 7, 5,……1

           

            DECLARE SUB SERIES ( )

CLS

CALL SERIES

END

SUB SERIES ( )

FOR I = 9 TO 1 STEP-2

PRINT I

NEXT I

END SUB

 

 

***