SLC SUPPLEMENTARY 2069 SOLVED

Supplementary Exam 2069

Group A

Computer Fundamental (22 marks)

1.       Answer the following questions:

2.        

a.       What is computer network? Draw the diagram of BUS topology.

è  A computer network means two or more than two computers connected to each other to share data, hardware, software and other resources.

Diagram of bus topology:

b.       Define Internet and E-mail.

è  Internet: A collection of millions of computers of different types belonging to various networks all over the world is known as internet.

E-mail: E-mail is one of the most popular services provided by internet which allows sending and receiving mail through the internet.

c.        Write any four advantages of using multimedia.

è  Any four advantages of using multimedia are as follows:

i.     It makes easy to share views, ideas and thoughts among various people around the world.

ii.   It can store data and information for a long period.

iii. It makes the presentation of related subject matter attractive.

iv. It makes teaching-learning easier in classroom.

v.    

d.       Write any four possible threats to computer security.

è  Any four possible threats to computer security are:

                                            i.            Extreme temperature and dust

                                          ii.            Theft of hardware components.

                                        iii.            Voltage fluctuation

                                        iv.            Unauthorized access of data and programs

e.        What is anti-virus program? Give any two examples.

è  The software which is designed to detect and remove viruses from computer system to ensure a virus-free environment is known as anti-virus software.

Any two examples of anti-virus software are:

i.     Norton Antivirus

ii.   McAfee

4.       Match the following:

Group A                                  Group B

a) Sound card                          i) WAN
b) Virus                                   ii) Internet explorer
c) Web browser                                   iii) Multimedia
d) Satellite link                         iv) damage or corrupt data
                                                v) Bridge

è   

Group A                                  Group B

a)      Sound card                        -           Multimedia

b)      Virus                      -           damage or corrupt data

c)      Web Browser         -           Internet explorer

d)      Satellite link           -           WAN

5.       Choose the best answers:

a.       Each computers on the Internet has a unique numeric address called a/an …

i) Web address       ii) Domain address       iii) Network binding     iv) IP address

è  IP address

b.      Which of the following is the component of multimedia?

i) Network             ii) Microphone             iii) Power cable                        iv) Printer

è  Microphone

c.       Which of the following network connects computer to the Internet?

i) Intranet   ii) LAN                        iii) WAN                      iv) MAN

è  WAN

d.      Computer virus is………

i) dust particle        ii) computer programs  iii) useful program       iv) none of the above

è  Computer program

6.       Give appropriate technical terms.

a.       The integration of text, graphics, audio and video.

è  Multimedia

b.      A spare copy of important program or document.

è  Backup data

c.       Law that governs the legal issue related to Internet.

è  Cyber law

d.      The method of consolidating fragmented files on the computers.

è  Defragmentation

7.       Give the full forms:

a.       LAN: Local Area Network

b.      NIC: Network Interface Card

c.       NOS: Network Operating System

d.      UPS: Uninterruptible Power Supply

Group B

Database (10 marks)

8.       Answer the following questions:

a.       What is data? Give any two examples of DBMS software.

è  Data can be numbers, letters or symbols representing facts and figures, which may or may not give any sense.

Any two examples of DBMS software are:

i.     MS-Access

ii.   Oracle

b.      Write any two things to be considered after assigning primary key for a field.

è  Any two things to be considered after assigning primary key for a field are as follows:

i.                    Reduce and control duplication of record in a table

ii.                  Set the relationship between tables.

c.       What is form?

è  Form is an object of MS-Access which provides a user friendly interface to enter data in a table or multiple linked tables.

9.       State whether the following statements are true or false:

a.       Default text field size is of 255 characters. False

b.      A database can contain multiple tables. True

c.       A row in a table is known as record. True

d.      Data like sound and pictures are held by memo data type. False

10.    Match the following:

Group A                      Group Ba) Report                      i) Data type
b) Currency                 ii) Column
c) Long Text                iii) Database object
d) Field                                                iv) Record

                                    v) Memo

è  
Group A                      Group B

Report              -           Database object

Currency          -           Data type

Long text         -           Memo

Field                -           Column           

Group C

Programming (18 marks)

11.    Answer the following questions:

a.       Write the difference between SUB procedure and FUNCTION procedure.

è  The difference between SUB procedure and FUNCTION procedure are as follows:

SUB Procedure	FUNCTION Procedure
i) SUB-procedure does not return value.	i) FUNCTION-procedure must return a value.
ii) SUB-procedure is called by CALL statement.	ii) FUNCTION-procedure is called by statement and expression method.
iii) SUB-procedure’s name does not accept data type symbol because it does not need to return a value.	iii) FUNCTION-procedure’s name accepts data type symbols such as $, %, !, #, &, etc. and it depends on the type of value to be returned. E.g.: FUNCTION REV$ returns string.

b.      Write the two basic data types used in “C” language.

è  The basic data types used in C language are as follows:

·         char

·         int

c.       Write the function of the following statements:

i.      NAME: The function of NAME statement is to rename a file on a diskette.

ii.    CLOSE: The function of CLOSE statement is to close one or all open file.

12.    Re-write the given program correcting the bugs:

Rem program to reverse the string or word

DECLARE SUB REV(W$)

CLS

INPUT “Enter a wod”;W$

CALL REV(W$)

END

SUB REV(W$)

FOR I=LEN(W$) to 1 step -1

C$=LEFT$(W$,I,1)

S$=D$+1

LOOP

PRINT “Reverse string is:”; D$

CLOSE SUB

è  Rem program to reverse the string or word

DECLARE SUB REV(W$)

CLS

INPUT “Enter a wod”;W$

CALL REV(W$)

END

SUB REV(W$)

FOR I=LEN(W$) to 1 step -1

C$=MID$(W$,I,1)

D$=D$+C$

NEXT I

PRINT “Reverse string is:”;D$

END SUB

13.    Write the output of the following program.

DECLARE SUB Series()
CLS
CALL Series
END
SUB Series
            A=1
            B=1
            FOR I = 1 TO 2
                        PRINT A; B;
                        A=A+B
                        B=A+B
            NEXT I
END SUB

14.    Analyse the program given below and answer the questions:DECLARE FUNCTION CHK$(N)
CLS
N=57
PRINT “The number is”; CHK$(N)
END
FUNCTION CHK$(N)
            FOR I = 1 TO N
                        IF N MOD I = 0 THEN C=C+1
            NEXT I
            IF C>2 THEN
                        CHK$=”Composite”
            ELSE
                        CHK$=”Prime”
            END IF
END FUNCTION

a)      Will the above program execute if “DECLSRE FUNCTION….” is deleted?

è  Yes, the above program will execute if “DECLARE FUNCTION…..” is deleted.

b)       Why $ sign is used in the name of the above function.

è  The $ sign is used in the above program because function returns string value.

15.    a)  Write a program to calculate and print the simple interest using FUNCTION……END FUNCTION.

è  DECLARE FUNCTION INTEREST (P,T,R)

CLS

INPUT “Enter principal, time and rate”; P,T,R

PRINT “The simple interest is”; INTEREST(P,T,R)

END

 FUNCTION INTEREST(P,T,R)

I=(P*T*R)/100

INTEREST=I

END FUNCTION

b)  Write a program to print the natural numbers from 1 to 5 using SUB…END SUB.

è  DECLARE SUB SERIES ( )

CLS

SUB SERIES

END

SUB SERIES

FOR I = 1 TO 5

PRINT I

NEXT I

END SUB

c) A sequential data file “Staff.dat” contains the name, address, post and salary of the employees. Write a program to read and display all the records stored in the above data file.

è  OPEN “STAFF.DAT” FOR INPUT AS #1

CLS

WHILE NOT EOF(1)

INPUT #1, N$, A$, P$, S

PRINT N$, A$, P$, S

WEND

CLOSE #1

END

***