SLC COMPUTER 2070 SOLVED

Computer Fundamental (22 marks)

1. Answer the following questions:                                      2×5=10

a) What is network topology? Write any one advantage of star topology.

The arrangement or connection pattern of computer or nodes and other devices of the network are known as network topology.

Any one advantage of star topology is:

i) Failure of single computer or cable doesn’t affect the entire network.

b) Give any two advantages of E-mail over traditional mail.

Any two advantages of E-mail over traditional mail are

i) It allows sending and receiving message across the world at very low cost.

ii) Emails are usually received fairly quickly, most of the time a couple of seconds after they are sent.

c) List any two main aims of formulating cyber law in Nepal.

The two main aims of formulating cyber law in Nepal are:

i) To legalize the transaction through electronic media to control various types of electronic frauds

ii) To punish a person who does criminal activities through electronic means especially on computers.

d) Give any two symptoms of virus attack.

The two symptoms of virus attacks are:

i) Increased use of disk space and growth in file size

ii) Program takes long time to load.

e) Give the importance of UPS to the computer system.The importance of UPS in computer security system is that it controls fluctuation of electric voltage and provides enough backup electric power to the computer system when there is power failure.

2. a) Convert as instructed:                                                  0.5×2=1

i) (BED)₁₆ into binary              

            Converting Hexadecimal to Binary equivalent value

            B = 1011

            E = 1110

            D = 1101

            = (101111101101)₂

ii) (1010111)₂ into octal

            Converting Binary to Octal equivalent value

            001 = 1

            010 = 2

            111 = 7

            =(127)₈

b) Perform the binary calculations                                 0.5×2=1

       

                  

3.  Match the following                                             0.5×4=2

    Group A                                                      Group B

i) Combination of several media                a) Guided Media

ii) POP                                                        b) Power Protection Device

iii) UTP                                                       c) Multimedia

iv) UPS                                                       d) Protocol used in e-mail

                                                                        e) CD-ROM

Answers

i) Combination of several media                a) Multimedia

ii) POP                                                        b) Protocol used in e-mail

iii) UTP                                                       c) Guided Media

iv) UPS                                                       d) Power Protection Device

                                                       

4. Choose the correct answer                                   0.5×4=2

a) Which of the following is an audio output device?

i) Microphone  ii) Speaker       iii) Monitor      iv) Printer

Speaker

b) Which one is not a type of virus?

i) Message Carrying virus       ii) Boot sector virus    

iii)System virus           iv)Special Purpose Application Infector

Special Purpose Application Infector

c) Which one is bounded media?

i) Fibre optics              ii) Microwave             

iii) Infrared                  iv)Laser

Fibre optics

d) Which one is an operating system software?

i) MS-Word     ii) MS-Excel    iii) Firefox       iv) MS-DOS

MS-DOS

5. Give an appropriate technical term for the following.  0.5×4=2

           

a) A program that can disinfect a file from virus

Antivirus Software

b) A person who steals or destroys other’s data, information and program

        Hacker

c) A company that provides internet service

        ISP (Internet Service Provider)

d) A computer in a network which can provide services to other computer

        Server

6. Write the full forms of:                                                     0.5×4=2

a) TCP/IP    = Transmission Control Protocol / Internet Protocol

b) LAN       = Local Area Network

       

c) UPS        = Uninterruptible Power Supply

d) FTP        = File Transfer Protocol

Group B

Database (10 marks)

7. Answer the following:                                                        2×3=6

a) Define data and information.

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

Information is an organized collection of related data which gives a complete sense.

b) What is report? Give its importance.

Report is an object of database which displays the output in an effective way to present the data in a printed format.

The importance of report are:
i) It displays the information the way we want to view it.
iii) It presents the information in designed layouts by adding necessary titles, setting font colour or font size, etc.

c) Name any four data types that can be defined in MS-Access.

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

        i) Text

ii) Memo

iii) Number

iv) Yes/No

8. Choose the best answer.                                                               0.5×4=2

a) The columns in database tables are called:

i) Record         ii) Field                        iii) Report        iv) Memo

Field

b) Which is suitable data type to store video?

i) Text              ii) Number       iii) Hyperlink   iv) OLE object

OLE object

c) Text data type can store maximum of ___characters

i) 250               ii) 350              iii) 255             iv) 355

255

d) Which of the following is database application?

i) MS-Word     ii) MS-Access  iii) MS-Excel   iv) QBASIC

MS-Access

9. Match the following                                                               0.5×4=2

    Group A                                          Group B

i) Indexing Data                               a) Size upto 1 GB

ii) Form                                            b) Column of datasheet

iii) Field                                            c) Row on a datasheet

iv) OLE object                                 d) Searching Fast

                                                            e) Graphical interface for data entry

Answers

    Group A                              Group B

i) Indexing Data                   a) Searching Fast

ii) Form                                b) Graphical interface for data entry

iii) Field                                c) Column of datasheet

iv) OLE object                     d) Size upto 1 GB

                                                           

Group C

Programming (18 marks)

10. a) What is a variable?                                                     1

The data item whose value changes during the execution of a program is called variable.

b) Name any two data types used in C language.              1      Any two data types used in C language are:

      i) char

      ii) int

c) Give the functions of:                                                        0.5×2=1

i) NAME AS

The NAME statement renames a file on a diskette. Only file name changes, data and program

ii) CLOSE

            It closes one or all open files.

11. Rewrite the following program after correcting the bugs:       2

DECLARE SUB Series(.)

DLC

EXECUTE Series

END

SUB Series

REM  to generate 2 2 4 6 10….. upto 10^th term

P=2

Q=2

FOR    Ctr=1 TO 5

            DISPLAY P,Q,

P=P+Q

Q=P+Q

WEND

END Series()

Debugged Program

DECLARE SUB Series( )

CLS

CALL Series

END

SUB Series

REM  to generate 2 2 4 6 10….. upto 10^th term

P=2

Q=2

FOR    Ctr=1 TO 5

            PRINT P,Q,

P=P+Q

Q=P+Q

NEXT Ctr

END SUB

13. Study the following program and answer the questions:   1×2=2

DECLARE FUNCTION Sum(A,B)

INPUT “Enter first number:”; A

INPUT “Enter second number:”; B

PRINT “The sum of the two number=”;Sum(A,B)

END

FUNCTION SUM(A,B)

S=A+B

Sum=S

END FUNCTION

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

           Ans: The numerical variables used in the above program are A, B, S

b) Will the program run if the first line (i.e. DECLARE….) is deleted?

Ans: Yes, the program will run if the first line (i.e. DECLARE...) is deleted.

14. a) Write a program using Function…..End Function to get temperature in Celsius from the user and then print the temperature in Fahrenheit.(hint: F=9C/5+32).       3

            DECLARE FUNCTION CONVERT (C)

CLS

INPUT “ENTER TEMPERATURE IN CELCIUS”; C

PRINT “TEMPERATURE IN FARENHEIT=”; CONVERT (C)

END

FUNCTION CONVERT (C)

F = 9  * C / 5 + 32

CONVERT = F

END FUNCTION

b) Write a program using Sub….End Sub to get a word from the user and then print it in reverse order.                                         3

DECLARE SUB REV (S$)

CLS

INPUT "ENTER ANY STRING"; S$

CALL REV(S$)

END

SUB REV (S$)

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

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

W$ = W$ + B$

NEXT I

PRINT "REVERSED STRING IS "; W$

END SUB

c) A sequential data file called “Marks.dat” contains Name, English, Nepali, Maths and Science Fields. Write a program to display all the contents of that data file.       3

OPEN “Marks.dat” FOR INPUT AS #1

CLS

PRINT “NAME”, “ENGLISH”, “NEPALI”, “MATHS”, SCIENCE”

WHILE NOT EOF(1)

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

PRINT N$, E, N, M, S

WEND

CLOSE #1

END

***