SLC COMPUTER 2065 SOLVED

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:

ii) Insurance Policy
ii) Power Regulator Device

Any two software security measures are:
            i) Backup
            iv) 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

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 stationc) Protocol                   HTTPd) 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 drive      ii) 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:

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

b.      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) Number        ii) Text             iii) Memo         iv) Form

            Form

b) …………… is the DBMS.
i) Fox-Pro        ii) 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 A                      Group 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