SLC COMPUTER 2070 QUESTION

SLC COMPUTER 2070 QUESTION

SLC Examination 2070 (2014)

Attempt all the questions.

Computer Fundamental (22 marks)

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

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

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

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

d) Give any two symptoms of virus attack.

e) Give the importance of UPS to the computer system.

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

i) (BED)₁₆ into binary                               ii) (1010111)₂ into octal

b) Perform the binary calculations                                                0.5×2=1

  i) 1010 × 10                    ii) 10101÷10

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

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

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

c) Which one is bounded media?

i) Fibre optics                          ii) Microwave                         

iii) Infrared                              iv)Laser

d) Which one is an operating system software?

i) MS-Word            ii) MS-Excel            iii) Firefox               iv) 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

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

  c) A company that provides internet service

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

         

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

a) TCP/IP                          b) LAN   c) UPS                    d) FTP    

Group B

Database (10 marks)

7. Answer the following:                                                        2×3=6
    a) Define data and information.

b) What is report? Give its importance.

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

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

b) Which is suitable data type to store video?

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

c) Text data type can store maximum of ___characters

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

d) Which of the following is database application?

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

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

                                                                               

Group C

Programming (18 marks)

10. a) What is a variable?                                                     1

b) Name any two data types used in C language.              1
c) Give the functions of:                                                        0.5×2=1

i) NAME AS                          ii) CLOSE

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()

12. Write the output of the following program.

DECLARE FUNCTION AREA(L,B)

LET L=10

LET B=5

PRINT “The area = ”; AREA(L,B)

END

FUNCTION AREA(L,B)

A=L*B

AREA=A

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.

b) Will the program 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

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

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

*************