SLC COMPUTER 2071 QUESTION

SLC COMPUTER 2071 QUESTION

SLC Examination 2071 (2015)

Attempt all the questions.

Computer Fundamental (22 marks)

1.      Answer the following questions:

a.   Give two-two difference between peer-to-peer and client/server network architecture.

b.   What is the function of file transfer protocol (FTP)?

c.   What is cybercrime? Give any two examples.

d.   Write any four preventive measures for computer hardware security.

e.   Write any two medium for transmission of computer virus.

2.      a. Convert as indicated:

                i. (108)₁₀ into binary                                ii.    (765)₈ into decimal

        b. Perform the following binary calculations:

              i.       111*11                              ii.       Divide 1101 by 11

3.      Match the following:

a.       E-commerce                      Power protection device

b.      Volt guard                          Online shopping

c.       Satellite link                      WAN

d.      Sound card                         Optical fiber

                                                                      Multimedia

4.      Choose the best answer:

     a. Which of the following is remote login service?

                i. Video conferencing          ii. FTP              iii. Telnet         iv. TCP/IP

     b. Process of arranging the scattered parts of file into a contiguous manner is _______.

                i. debugging           ii. Backup        iii.Defragmentation      iv. Scandisk

    c.  Which of the following is an audio input device?

                i. Printer     ii. Microphone             iii. Head phone                        iv. Speaker

    d.  Virus is a type of ___________.

                i. System program  ii.Package program    iii.Destructive program   iv. Web program

5.      Technical terms:

a.  The data carrying capacity of communication channel.

b.  The moral principles that control cybercrime.

c.  Buying and selling product and services online.

d.  An integration of text, audio, graphics and video.

6.      Write down the full forms:

      a. LAN                              b. VOIP c. Gbps    d. DVD

Group B 

Database(10 marks)

7.      Answer the following question:

a.       Write any two advantages of computerized database.

b.      Name any four objects of MS-Access database.

c.       What is data sorting?

8.      State whether the following are true or false:

   a. Graphics can also be stored in MS-Access database. 

   b. Maximum field size of memo field is 256 characters.

   c. A form is an object of MS-Access used for entering data.

   d. An action query makes changes in a table. 

9.      Match the following:

a.       Indexing data                     Final output

b.      Report                                View data

c.       Yes/No                              Searching fast

d.      Select query                       Picture

                                                                    Data type

Group-C

Programming(18 marks)

10.  Answer the following:

a.       Mention the types of procedures used in QBasic.

b.      Write two characteristics of C language.

c.       Write down the function of:

    i. SHARED                         ii. CALL

11.  Re-write the following correcting the bugs:

DECLARE SUB CUBE(N)

CLS

FOR I = 1 TO 5

READ

CALL CUBE(No)

NEXT X

DATA 3, 5, 2, 6, 4

END

SUB CUBE( )

DISPLAY N^3

END SUB

12.  Write down the output:

DECLARE FUNCTION AVGE(A,B,C)

X=10

Y=5

Z=15

AV= AVGE(X,Y,Z)

RPINT “Average of three numbers”; AV

END

FUNCTION AVGE(A, B, C)

S=A+B+C

AVGE = S/3

END FUNCTION

13.  Study the following program and answer the following:

DECLARE SUB Stde(N$U)

FOR Loop = 1 TO 5

READ NM$(Loop)

NEXT Loop

DATA RAMA, PRATIMA, PRASANT

DATA NISHA, RUDHRA

CALL Stde(NM$U)

END

SUB Stde(N$U)

PRINT “Name starting from P”

FOR J = 1 TO 5

C$=MID$(N$,(J),1,1)

IF C$=”P” THEN

PRINT N$(J)

END IF

NEXT J

END SUB

a.       List the library function used in the above program.

b.      List the conditional statement used in the above program.

14.  a. Write a program using FUNCTION….END FUNCTION to input a string and count the total number of consonants.

       b. Write a program using SUB……END SUB to find the area of circle.

       c. A data file “Salary.Dat” contains the information of employee regarding their name, post and salary. Write a program to display all the information of employee whose salary is greater than 15000 and less than 40000.

*******