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

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) at2)
           
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

Comments

Unknown said…
this is very useful to me
Unknown said…
this is very useful to me
Unknown said…
Thank you so much... it was very helpful to refer answer ket3

Popular posts from this blog

PROGRAM TO FIND SQUARE, CUBE, SQUARE ROOT AND CUBE ROOT OF GIVEN NUMBER

PROGRAM TO DISPLAY SUM, PRODUCT, DIFFERENCE AND PRODUCT OF TWO / THREE NUMBERS

PALINDROME AND ARMSTRONG PROGRAMS