SLC COMPUTER 2069 QUESTION

SLC COMPUTER 2069 QUESTION

SLC Examination 2069 (2013)

Attempt all the questions.

Computer Fundamental (22 marks)

1. Answer the following questions:

a) Write any four advantages of computer network.

b) What is internet? Write the name of any two E-commerce sites.

c) What is computer ethic?

d) What is hardware security? Write any two software security measures.

e) What is computer virus?

2.a) Convert as indicated:

   i) (684)₁₀ into octal                                       ii) (101011)₂ into decimal

   b) Perform binary calculation:

    i) 1011*11                                                   ii) Divide 100101 by 110

3. Match the following:
    Group A                      Group B
a) RJ-45                       a) Multimedia
b) WAN                      b) Duplicate copy
c) Back up                   c) Fiber optic cable
d) microphone             d) Twisted pair cable
                                    e) Internet

4. Select the best answer:
 a) Which is not unguided media?
   i) Fiber optics           ii) Microwave  iii) Infrared      iv) Radio wave

 b) Which is the internet service?
   i) IRC           ii) Telnet          iii) E-mail        iv) All of the above

 c) Which is not related to multimedia?
   i) Printer                   ii) Sound card iii) Microphone                        iv) CD-ROM

 d) Which virus infects boot sector files?
   i) Macro virus           ii) Multipartite virus    iii) Boot sector virus    iv) Program virus

5. Give appropriate technical terms:
     a) Business through internet.

     b) The software that protects computer virus.

     c) Physical layout of LAN.

     d) A sector word that gives user access to a particular program or computer     

          system.

6. Write the full forms of:
     a) VOIP                 b) MAN                      c) UTP             d) WWW       

     Group B Database(10 marks)
7. Answer the following questions:

  a) What is database? Give two examples.

  b) Write any two types of primary key.

  c) What is query?

8. Choose the best answer:
    a) Which of the following is not a database application?
                  i) Oracle                ii) Foxpro        iii) MS-Access     iv) MS-Excel

    b) Memory space consumed by a currency data type maximally is …………
          i) 2 bytes                       ii) 4 bytes        iii) 8 bytes       iv) 1 GB

    c) The default data type of MS-Access is:
          i) Number          ii)Text              iii) Memo         iv) Auto number

    d) Row is also called …………
          i) Record                       ii) Field                        iii) Database    iv) Table

9. Match the following:
      Group A                    Group B
     i) OLE                    a) Data Entry
    ii) Hyperlink            b) Formatted  Hardcopy
   iii) Report                 c) 1 GB

   iv) Form                   d) Up to 255 characters

                                    e) Up to 2048 characters

Group-C

Programming(18 marks)

10.a) What is meant by mode of data file?

     b) Write any two characteristics of ‘C’ language.

     c) Write the function of the following statements:
            i) NAME                     ii) KILL

11. Write the output of the following program

DELARE SUB NUMBER()

CLS

CALL NUMBER

END

SUB NUMBER

N=3

C=1

WHILE C<=5

            PRINT N

            N=N*10+3

            C=C+1

WEND

END SUB

12. Rewrite the given program after correcting the bugs:

REM display Records of students From Data File

OPEN “STDREC.DAT” FOR INP AS #1

PRINT “ROLL”,”NAME”,”ADDRESS”,”CLASS”,”SECTION”

DO WHILE NOT EOF

            INPUT #1,RN,N$,AD$,CL,S$

            PRINT RN,N$,AD$,CL,S$

NEXT

CLOSE #1

END

13. Study the following program and answer the given questions:
DECLARE SUB EXAM(N$)

CLS

INPUT “Enter word”;WO$

CALL EXAM(WO$)

END

SUB EXAM (N$)

FOR I = 1 TO LEN (N$)

PRINT RIGHT$(N$,I)

NEXT I

END SUB

a) Write the names of two built-in functions used in the above program.

b) List the real parameter in the program.

14. a) Write a program to find the numbers of vowels in an input string using ‘FUNCTION…..END FUNCTION’.

b) Write a program using sub procedure module to print the series 1,1,2,3,5,8.. up to ten terms.

c) Write a program to create a data file ‘teldir.dat’ to store Name, Address and Telephone number of employees according to the need of the user.

**********