KATHMANDU PABSON SEND UP 2067 [SLC COMPUTER SOLVED]

PABSON

SLC Send Up Examination 2067(2011)

Subject: Computer Science                                        Full marks: 50

Time: 1hrs                                                                  Pass marks:16

Candidates are requested to give their answer in their own words as far as practicable.

Attempt ALL the questions.

Group’A’

[Computer Fundamentals- 22 marks]

1. Answer the following question:                                    (5X2=10)

a)      Define is LAN? How does computer network reduce the cost of operation?

è A local Area Network (LAN) is a network of computers that connects two or more computers within a local area, such as a room or a building.

A computer network helps to reduce initial and operation cost. A computer network allows sharing of resources like hardware, software and services. For example, a printer or one Internet connection can be shared by all users of a network. In this way it helps to save the cost of buying extra hardware or service. Problems of the computers in a network can be solved by one or a few experts from one place. This saves the cost of hiring experts for all the branches of an office and the cost of travel by the expert to different branches.

b)      Write down any four uses of internet.

è The four uses of internet are:-

i.                     The internet facilitates the speedy sharing of information among research and education communities.

ii.                   Businesses and institutions use the Internet for video conferencing and other forms of communication that enables people to telecommunicate or work from distance.

iii.                  Individuals use the Internet for communication, entertainment, finding information, and to buy and sell goods and services.

iv.                 Media and entertainment companies use the Internet to broadcast audio and video, including live radio and television programs.

c)      What is Cyber Law? Write any two ethical standards to be followed by computer user.

è Cyberlaw is a generic term which refers to all the legal and regulatory aspects of Internet and the World Wide Web.

è The two ethical standard s to be followed by computer user are:-

i.                     Do not use a computer to harm others

ii.                   Do not use a computer to steal

d)      Why is power protection devices needed to our computer system? Name any two power protection devices.

è Power protection device is needed to our computer system to maintain constant voltage level and produce electricity during the power cuts and surges.

è The two power protection devices are :-

i.                     Uninterruptible Power Supply(UPS)

ii.                   Voltage Guard

e)      How can we protect computer from methods.

è We can protect computer from methods :

i)                    Antivirus software can detect and remove viruses.

ii)                   Scan disk check folder , bad sector and other errors of the disk and fix them.

iii)                 Regular Maintenance helps to keep computer in good condition.

iv)                 Power protection device protects computer from surges and provides backup to save important files during power cut up.

2 a)  Convert as instructed:                                              (2X1=2)

b) Perform binary calculation.                               (2X1=2)

3. Match the following:                                                          (4X0.5=2)

Group A                                              Group B

a)      Communication Channel                        i) Router

b)      Multimedia Device                                ii)Network of networks

c)      Internet                                                 iii)CD-ROM

d)      Network Device                                    iv)Network within LAN

v)Fiber optic

Ans:-

Group A                                              Group B

a)      Communication Channel                  i) Fiber optic

b)      Multimedia Device                          ii)CD-ROM

c)      Internet                                           iii) Network of networks

d)      Network Device                              iv) Router

4. Select the correct answer:                                                      (4X0.5=2)

a) Component of multimedia

i) Text, Audio-visual & Animation          ii) Text, Graphics & Animation

iii) Text, Graphics & Soundiv) Text, Graphics, Audio-visual & Animation 

è Text, Graphics, Audio-visual & Animation

b) Which is not a network OS?

I) Windows NT

II )GNU/Linux      

III)              MS-DOS    

IV)              UNIX 

è MS-DOS    

c)  Data communication means

i) We can easily send and receive the messages.

 ii) Data computing system is fastest in the network.

iii) The process of transferring data and information.

iv)None of the above.

è The process of transferring data and information

d) Computer software security include

i) Use of password        ii) Use of Genuine software      

iii)Use of hard lock key.     iv)All of the above.

è All of the above

5. Give the appropriate technical terms of the following:     (4X0.5=2)

a) Online mail service through internet.

Electronic - mail

 b) Cabling structure of LAN.

Topology

c) Making an extra copy of data and software.

Backup

d) A program that is attached to other programs.

Computer Virus

6.                  Write the Full forms of the following:                                    (4X0.5=2)

a) UPS – Uninterruptible Power Supply     

b)UTP – Unshielded Twisted Pair 

c)TCP/IP - Transmission Control Protocol/Internet Protocol

d)DVD – Digital Versatile Disk

Group’B’

[MS-ACCESS – 10 marks]

7.                  Answer the following questions:                                           (3X2=6)

a)      Define database and DBMS

è Database is a collection related and organised information that is used to store, organise and extract data.

DBMS is a software which is used to manage data, manipulate them and provide the information.

b)      What is data sorting? How does it differ from filtering?

è Data sorting means grouping all the records in a table either ascending or descending based on a key field of the record.

è The differences between sorting and filtering are:-

c)      What is form? Write any two advantages of forms.

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

è Two advantages of forms are:

i)        It provides an interactive platform for input of data into the database.

i)                    It helps to display data in more presentable form than a datasheet can.

8.                  State True Or False.                                                         (4X0.5=2)

a)      A primary key does not accept null value.True

b)      Rows in database are called fields.False

c)      We can’t change data type in design view.False

d)      The extension file name of MS-ACESS is .DBM(dot DBM).False

9.                  Match the following:                                                  (4X0.5=2)

Group A                                      Group B

a) Ye/No                                  i) Up to 1 GB

b)Query                                    ii) Used for logical operation

c) Caption                                 iii) retrieving information conditionally

d) OLE Field                             iv) 255 characters

                                                            v) Field property

Ans:  Group A                                      Group B

a) Yes/No                                 i) Used for logical operation

b)Query                                    ii) retrieving information conditionally

c) Caption                                 iii)Field property

d) OLE Field                             iv) Up to 1 GB

                                                           

Group ‘C’

[QBASIC Programming – 18 Marks]

10.              a)Define Local and Global variable.                                 1

è    Local variable are those variables which are declared inside a function and are not visible to other modules or functions.

è Global variables are those variables which are declared outside of any functions and are visible to other functions or modules.

b)  Write any two advantages of “C” Language.                  1

è The two advantages of C language are:

i) It is a high level language with some features of low level language.
ii) It is mostly used to prepare system software.

c)      State the function of the following statements.   . 1

i)                    WRITE# :

è It sends one or more data items to the specified file.

ii)                         ii) EOF()

è It detects the End Of the File marker reading the data from an OPEN sequential file.

11.              Write the output of the following program.                     2

DECLARE FUNCTION A(X)

X=10

Z=A(X)

PRINT Z

END

FUNCTION A(X)

FOR I = 1 TO X

S=S+I

NEXT I

A=S

END FUNCTION

12.  Re-write the given program after correcting the bugs.                   2

REM ’to calculate sum of digits of a number’

DECLARE FUNCTION XYZ (N)

CLS

INPUT”ANY NUMBER”; N

DISPLAY XYZ (N)

END

FUNCTION XYZ (N)

S=0

WHILE N>0

R= N MOD 10

S=S+R

N=(N/10)

LOOP

S=XYZ

END FUNCTION

            Debugged Program

REM ’to calculate sum of digits of a number’

DECLARE FUNCTION XYZ (N)

CLS

INPUT”ANY NUMBER”; N

PRINT XYZ (N)

END

FUNCTION XYZ (N)

S=0

WHILE N>0

R= N MOD 10

S=S+R

N= INT(N/10)

WEND

XYZ=S

END FUNCTION

13.              Study the following program and answer the given questions. (2x1=2)

DECLARE SUB WORD(N$)

CLS

N$=”PABSON”

CALL WORD(N$)

END

SUB WORD(N$)

B=LEN(N$)

C=1

WHILE C<B

M$=MID$(N$, B, 1)

PRINT M$

C=C+2

WEND

END SUB

Questions:-

a)      List the string and numeric variables used in the program.

è The string variables are :-

i)                    M$

ii)                   N$

è The numeric variable used are :

i)                    B

ii)                   C

b)      What is the value of B in the program?

è Value of  B in following is 6.

14.              a) Write a program to calculate the volume of cylinder using

FUNCTION……………END FUNCTION .[Hints:-v=pie*r² h]

è DECLARE FUNCTION VOLU(R,H)

CLS

INPUT”ENTER RADIUS AND HEIGHT”; R, H

PRINT “THE VOLUME OF CYLINDER IS”;VOLU(R,H)

END

FUNCTION  VOLU(R,H)

V = 3.14 * R^2 * H

VOLU = V

END FUNCTION

b)         Using SUB………………END SUB, write a program to generate series

81,64,49,………………………10^th term                                             3

è DECLARE SUB CHECK()

CLS

CALL CHECK

END

SUB CHECK

FOR I = 9 to 1 STEP-1

PRINT I^2

NEXT I

END SUB

c)         Write a program to search and display only those records whose percentage is more than 60% from the data file “RESULT.DAT” which contains Student’s Symbol number, Date of Birth, Total Marks, Percentage and Division.                                               3

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

CLS

WHILE NOT EOF(1)

INPUT #1 , SN , D$ , M  , P , DV$

IF P> 60 THEN PRINT SN , D$ , M , P ,DV$

WEND

CLOSE #1

END