SLC Computer 2067 Question

SLC COMPUTER 2067 QUESTION

SLC Examination-2067 (2011)

Computer Fundamental (22 marks)

1. Answer the following questions:

a. Write any two examples of data communication.

b. What do you mean by web browser?
c. Write any four advantages of multimedia.
d. Mention any four symptoms of computer virus.
e. What is computer security?

2.a) Convert as instructed:

    i. (AC3)₁₆ into decimal                   ii. (110010)₂ into octal

   b) Perform binary calculation:

    i. 11*11-101                                    ii. Divide 1010 by 10

3. Match the following:
             Group A                       Group B
       a) Satellite                        a) Multimedia
       b) HTTP                           b) Protocol
       c) Online business            c) Unguided media
       d) Fiber optics                  d) E-commerce

4. Choose the correct answer:
a) Which is not a communication media?
  i) Wire                       ii) Microwave              iii) Satellite                  iv) NIC

b) Which is web browser software?
  i) Window 2007        ii) Internet Explorer    iii) Windows NT         iv) All of the above

c)In which topology network devices are connected through hub?
  i) Ring topology        ii) Bus topology          iii) Star topology         iv) None of the above
d) Which is not related to Internet?
  i) ISP             ii) TCP/IP                    iii) WWW                    iv) UPS

5. Give appropriate technical terms of the following:
a) An internet tool that helps to upload/download the file.

b) Making duplicate copy of file for security purpose.

c) A set of rules that governs how computer exchange information over computer network.

d) An integrations of audio, video, graphics and text.

6. Write the full forms:
a) URL            b)ISP               c)ASCII          d)bps

Group B-Database

7. Answer the following questions:
a) Define DBMS with examples.

b) What is primary key?
c) Why is reporter created?

8. Choose the best answer:
a) Which is not a type of query?
  i) Search        ii) Select          iii) Update       iv)All of the above

b) The storage size of data and time is :
  i) 4 bytes       ii)6 bytes         iii)8 bytes        iv)10 bytes
c) Collecting multiple related fields  is called:
  i)Records       ii)Table            iii) Forms         iv)Query
d) The data type appropriate to store salary is:
  i)Memo          ii)Currency      iii)Text             iv) Auto number

9. Match the following:
   a) OLE                                             a)Report
   b) Data entry                                    b) Picture
   c) Indexing                                       c) Table
   d) Formatted printout                      d)Fast searching
                                                            e)Form

Group C-Programming

10. i) What is procedure?

ii) Write any two characteristics of C language.

iii) Write the function of:

  a) INPUT                 b) MKDIR

11. Write the output of the following program.
DECLARE SUB RESULT(N$)
N$ = "SCIENCE"
CALL RESULT(N$)
END
SUB RESULT (N$)
B = LEN(N$)
COUNT = 1
WHILE COUNT <= B
 X$ = X$ + MID$(N$, COUNT, 1)
 COUNT = COUNT + 2
WEND
PRINT X$
END SUB

           

12. Rewrite the given program after correcting the bugs.
REM to display all the records from sequential Rem data file ABC.DAT
OPEN “ABC.DAT” FOR OUTPUT AS # 1 DO WHILE NOT EOF(“ABC.DAT”)
INPUT # 1,N$,A
PRINT N$,A
CLOSE 1
END

13. Read the program given below and answer the following questions.
   DECLARE SUB SUM(N)
   INPUT”ANY NUMBER”;N
   CALL SUM(N)
   END
   SUB SUM(N)
   S=0
   WHILE N<>0
   R=N MOD 10
   S=S+R
   N=N\10
   WEND
   PRINT “SUM”;S
   END SUB
 i) In which condition the statements within the WHILE….WEND looping statement   

     will not be executed?

ii) Will the output be the same if we place “/” instead of”\” in the above program.

14. i)  Using FUNCTION…END FUNTION, write a program to calculate the average of three numbers.

     ii) Using SUB…END SUB, write a program to test whether the given number is completely divisible by 3 or not.

     iii) A sequential data file “EMP.DAT” contains name, post and salary fields of information about employees. Write a program to display all the information of employees along with tax amount (also tax is 15% of salary).

THE END