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
***

Comments

Post a Comment

Popular posts from this blog

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

7. Display square of an input number. REM PROGRAM TO DISPLAY SQUARE OF AN INPUT NUMBER CLS INPUT “ENTER ANY NUMBER”; N S = N ^ 2 PRINT “SQUARE OF NUMBER ”; S END USING SUB PROCEDURE DECLARE SUB SQUARE (N) CLS INPUT “ENTER ANY NUMBER”; N CALL SQUARE(N) END SUB SQUARE (N) S = N ^ 2 PRINT “SQUARE OF NUMBER “; S END SUB USING FUNCTION PROCEDURE DECLARE FUNCTION SQUARE (N) CLS INPUT “ENTER ANY NUMBER”; N S = SQUARE(N) PRINT “SQUARE OF NUMBER “; S END FUNCTION SQUARE (N) SQ= N ^ 2 SQUARE = SQ END FUNCTION 8. Display cube of an input number. REM PROGRAM TO DISPLAY CUBE OF AN INPUT NUMBER CLS INPUT “ENTER ANY NUMBER”; N C = N ^ 3 PRINT “CUBE OF NUMBER ”; C END USING SUB PROCEDURE DECLARE SUB CUBE (N) CLS INPUT “ENTER ANY NUMBER”; N CALL CUBE(N) END SUB CUBE (N) C = N ^ 3 PRINT “CUBE OF NUMBER “; C END SUB USING FUNCTION PROCEDURE DECLARE FUNCTION CUBE (N) CLS INP...
Read more

PALINDROME AND ARMSTRONG PROGRAMS

120.  WAP to input any number and check whether the given no. is palindrome or not. CLS INPUT "ENTER ANY NUMBER"; N A = N S = 0 WHILE N < > 0 R = N MOD 10 S = S * 10 + R N = N \ 10 WEND IF A = S THEN PRINT A; "IS PALINDROME" ELSE PRINT A; "IS NOT PALINDROME" END IF END USING SUB PROCEDURE DECLARE SUB PALIN (N) CLS INPUT "ENTER ANY NUMBER"; N CALL PALIN (N) END SUB PALIN (N) A = N S = 0 WHILE N < > 0 R = N MOD 10 S = S * 10 + R N = N \ 10 WEND IF A = S THEN PRINT A; "IS PALINDROME" ELSE PRINT A; "IS NOT PALINDROME" END IF END SUB USING FUNCTION PROCEDURE DECLARE FUNCTION PALIN (N) CLS INPUT "ENTER ANY NUMBER"; N P = PALIN ((N)) IF P = N THEN PRINT N; "IS PALINDROME" ELSE PRINT N; "IS NOT PALINDROME" END IF END FUNCTION PALIN (N) S = 0 WHILE N < > 0 R = N MOD 10 ...
Read more

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

1. Enter any two numbers and display its sum. REM PROGRAM TO DISPLAY SUM OF TWO NUMBERS CLS INPUT “ENTER FIRST NUMBER”; A INPUT “ENTER SECOND NUMBER”; B S = A + B PRINT “SUM OF TWO NUMBERS”; S END USING SUB PROCEDURE DECLARE SUB SUM (A, B) CLS INPUT “ENTER FIRST NUMBER”; A INPUT “ENTER SECOND NUMBER”; B CALL SUM(A, B) END SUB SUM (A, B) S = A + B PRINT “SUM OF TWO NUMBERS”; S END SUB USING FUNCTION PROCEDURE DECLARE FUNCTION SUM (A, B) CLS INPUT “ENTER FIRST NUMBER”; A INPUT “ENTER SECOND NUMBER”; B S = SUM(A, B) PRINT “SUM OF TWO NUMBERS”; S END FUNCTION SUM (A, B) SU = A + B SUM = SU END FUNCTION 2. Enter any two numbers and display its difference. REM PROGRAM TO DISPLAY DIFFERENCE OF TWO NUMBERS CLS INPUT “ENTER FIRST NUMBER”; A INPUT “ENTER SECOND NUMBER”; B D = A - B PRINT “DIFFERENCE OF TWO NUMBERS”; D END USING SUB PROCEDURE DECLARE SUB DIFF (A, B) CLS INPUT “ENTER FIRST NUM...
Read more