Friday, March 19, 2021

Solved Computer Science Supplementary Exam 2069

 

Solved Computer Science 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
***

No comments:

Post a Comment