SLC SUPPLEMENTARY 2066 SOLVED

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.                Autonumber

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

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

***