SLC SUPPLEMENTARY 2067 SOLVED

Supplementary Examination 2067
Group A
Computer Fundamental (22 marks)

1. Answer the following questions:a) Define LAN topology. Draw the Bus topology.

Ans: LAN topology is the arrangement or connection pattern of computers or nodes and other devices of the network Diagram of Bus topology:

b) What is multimedia? Name any two fields where multimedia is used.

Ans: The integration of several forms of media such as text, audio, video, animation, etc. to present the information in more attractive and understandable way is known as multimedia.

Any two fields where multimedia is used are as follows:

i.  Multimedia technology in advertisement

ii.Multimedia technology to learn foreign language

c) Give two advantages of e-mail over traditional mail.

Ans: The advantages of e-mail over traditional mail are as follows:

i.  It is faster and cheaper.

ii.It allows us to send and receive messages, documents, sounds, etc. across the world.

d) Write any two ways of protecting computer software.

Ans: Any two ways of protecting computer softwares are:

i.  Defragmentation

ii.Scan disk

e) What is antivirus? Name any two antivirus software.
Ans: The software designed to detect and remove virus from the computer to ensure a virus free environment is known as anti-virus software.

Any two anti-virus software are as follows:

i.  Norton Antivirus

ii.McAfee

 

3. Match the following:Group A                      Group B
a) Pictures in motions  i) Guided media
b) TCP/IP                     ii) animation
c) UTP                         iii) Random Access Memory
d) Volatile memory      iv) CD-ROM
                                    v) Protocol used in Internet

Ans:

Group A                                  Group B
a) Pictures in motions  -           animation
b) TCP/IP                     -           Protocol used in Internet
c) UTP                         -           Guided media
d) Volatile memory      -           Random Access Memory


4. Choose the best answer:a) E-commerce is ………….
i) a type of business     ii) a type of virus                     iii) both (i) &(ii)                       iv) None of the above

Ans: a type of business

b) E-mail is a/an ……………
i) organization which controls internet ii) protocol to access internet   iii) service of Internet  iv) none of the above

Ans: service of internet

c) Which one is not a type of virus?
i) message carrying virus                     ii) boot sector virus      iii) system infector       iv) special purpose application infector

Ans: special purpose application infector

d) Which one is an example of bounded media?
i) Fiber optics   ii) Microwave transmission      iii)Laser transmission   iv) infrared transmission
Ans:Fiber optics

5. Give an appropriate technical terms of the following:a) Network of networks

Ans: Internet

b) A device which can convert analog signal to digital codes and vice versa.

Ans: MODEM

c) A company that provides the internet facility.

Ans: ISP (Internet Service Provide)
d) An electronic device that supply electronic current when electricity is cut off.

Ans: UPS (Uninterruptible Power Supply)

6. Write the full forms of:a) NIC- Network Interface Card         

b) WAN- Wide Area Network            

c) WWW- World Wide Web   

d) FTP-File Transfer Protocol

Group B
Database (10 marks)

7. Answer the following questions:a) What is database? Name any two database software.

Ans: Database is a collection of related and organized information that is used to store, organize and extract data.

Any two database software are as follows:

i.  Telephone directory

ii.Dictionary

b) Name any four data types that can be define in MS-Access.

Ans: Any four data types that can be defined in MS-Access are as follows:

i.  Number

ii.Text

iii.    Auto number

iv.    Memo

c) What is a report? Give its importance.

Ans: Report is an object of MS-Access that is used to present data in a printed format using a specific layout.

The importance of report are as follows:

i.  It presents data and information from table or query in a flexible layout.

ii.It helps to present data in printed format.

8. Match the following: Group A         Group B
a) MS-Access   i) Data entry and editing interface
b) Query          ii) Electronic Spreadsheet softwarec) Record         iii) Tool to retrieve data from one or more than one   tables
d)Form             iv) Data base management software
                        v) Collection of related fields

Ans:

Group A                      Group Ba) MS-Access   -           Database management software
b) Query          -           Tool to retrieve data from one or more than one   tables
c) Record         -           collection of related fields
d)Form             -           Data entry and editing interface

9. State whether the following statements are true or false:a) A query is used to select fields and records from many tables.True
b) MS-Access is not spread sheet software.True
c) Index increases the speed of the query and sort operations.True
d) The primary key field can also be left empty.False

Group C
Programming (18 marks)

10. a) What is a loop?

Ans:The process of repeating a statement or block of statement for a number of times is known as loop.

b) Name any two data types used in C language.

Ans: Any two data types used in C language are:

·         int

·         char

c) Give the functions of NAME and CLOSE statements.

Ans: The functions of:

i. NAME: It renames a file on a diskette.

ii.    CLOSE: It closes one or all open files.

11. Rewrite the following program after correcting the bugs:DECLARE SUB Series()
CLS
EXECUTE Series
END

SUB Series()
            REM program to generate 1 1 2 3 5…. Up to 20^th terms

            A=1

            B=1

            FOR ctr= 10 TO 1

                        DISPLAY A;B;

                        A=A+B

                        B=A+B

            EXT ctr

END Series()

Ans:

DECLARE SUB Series ( )
CLS
CALL Series
END

SUB Series()
            REM program to generate 1 1 2 3 5…. Up to 20^th terms

            A=1

            B=1

            FOR ctr= 1 TO 10

                        PRINT A;B;

                        A=A+B

                        B=A+B

            NEXTctr

END Series()

12. Write the output of the following program:

DECLARE FUNCTION AREA(L,B)

CLS

LET L =100

LET B = 20

LET ans=AREA(L,B)

PRINT “The area=”,ans

END

FUNCTION AREA(L,B)

            ar=L*B

            AREA=ar

END FUNCTION

13. Analyse the program given  below and answer the questions.

DECLARE FUNCTION Prod(A,B)

CLS

INPUT “Enter first number:”;A

INPUT “Enter second number:”;B

PRINT “the product of two number=”;Prod(A,B)

END

FUNCTION Prod(A,B)

            P=A*B

            Prod=P

END FUNCTION

a)      List all the numerical variables used in the program.

Ans: The numerical variables used in the program are: A, B, P.

b)      List all the local variables used in the program.

Ans: The local variables used in the program is P.

14.a) Write a program using FUNCTION….END FUNCTION to get a word from the user and then print the word in reverse order

Ans:

DECLARE FUNCTION REV$(S$)

CLS

INPUT “Enter any word”; S$

PRINT “The reverse word is”; REV$(S$)

END

FUNCTION REV$(S$)

FOR I = LEN(S$) TO 1 STEP -1

B$=MID$(S$,I,1)

W$=W$+B$

NEXT I

REV$=W$

END FUNCTION

b) Write a program using SUB….END SUB to get radius of circle and then print its circumference.

Ans:

DECLARE SUB CIRC(R)

CLS

CONST PI=3.1416

INPUT ”Enter radius”; R

CALL CIRC(R)

END

SUB CIRC(R)

C=2*PI*R

PRINT “The circumference of circle=”;C

END SUB

c) A sequential data file called ‘MARKS.DAT’ contains ROLL NO, NAME, English, Nepali and Maths fields. Write a program to display all the contents of the data file.

Ans:

OPEN “MARKS.DAT” FOR INPUT AS #1

CLS

WHILE NOT EOF(1)

INPUT #1, RN, N$, E, N, M

PRINT RN, N$, E, N, M

WEND

CLOSE #1

END

***