Solved SLC Computer Science 2068

SLC Examination 2068 (2012)

Optional II [Computer Science]

Examinees are required to answer in their own words as far as practicable. Credit shall be given to clarity and originality, not rote learning.

Time: 1 hour 30 minutes                                                        Full Marks: 50

                                                                                                Pass Marks:20

Attempt all the questions.

            Computer fundamental (22 marks)
1. Answer the following questions:
    a) Define LAN topology and write any two types of LAN topology.

Ans: The arrangement or connection pattern of computers or nodes and other devices of the network is known as LAN topology.

Any two types of LAN topology are

i) Bus topology

ii) Star topology
    b) Write any four services of Internet.

Ans: Any four services of internet are

i) E-mail (Electronic mail)
ii) FTP (File Transfer Protocol)
iii) IRC (internet Relay Chat)
iv) E-commerce

   c) Write any two advantages of multimedia in education field.

Ans: Any two ad advantages of multimedia in education field are

i) It makes teaching/learning easier in classroom.

iv) It makes presentation of related subject matter attractive.
    d) Write any two software security measures.

Ans: Any two software security measures are:

i) Backup

ii) Password
    e) Write any four symptoms that show, computer is infected by computer virus.

Ans: Any four symptoms that show, computer is infected by computer virus are :

i) Program takes long time to load.
ii) The floppy disk or hard disk is suddenly accessed without a logical reason.
iii) Increased use of disk space and growth in file size.
iv) Corrupting the system data.

 

3. Match the following:
    Group A                              Group B
    a) Microwave                       a) Multimedia
    b) Volt guard                                   b) Protocol
    c) Sound card                      c) Unguided media
    d) TCP/IP                             d) Power protection devices
                                                e) Guided media

Answers

    Group A                              Group B
    a) Microwave                       Unguided media
    b) Volt guard                         Power protection devices
    c) Sound card                      Multimedia
    d) TCP/IP                             Protocol                                                
4. Select the best answers:
    a) Which of the following is not a protocol?
         i) POP     ii) TCP/IP         iii) NOS                       iv) FTP

NOS

    b) Which device protects hardware?
         i) UPS     ii) MODEM      iii) Gateway     iv) All of the above

UPS

    c) In which communication media data transfer high?
         i) Twisted pair     ii) Co-axial cable         iii) Fiber optics

iv) Microwave

Fiber optics

    d) Which computer virus damages the master boot record?
         i) Macro virus     ii) File virus     iii) New folder virus   

iv) Boot sector virus

Boot sector virus

5. Write the appropriate technical terms:
     a) The device used to connect PC with telephone line.

MODEM

     b) The rules that make the network communication possible.

Protocol

     c) A program that effect the normal functioning of computer.

Computer Virus

     d) A main computer in the computer network.

Server

6. Write down the full forms:
            a) bps               =          bits per second

b) MAN           =          Metropolitan Area Network

c) FTP              =          File Transfer Protocol

iv)URL            =          Uniform Resource Locator
            Group B-Database Management(10 marks)
7. Answer the following questions:
     a) What is database?

Ans: Database is a collection of related and organized information that can be used for different purpose.
   

 b) What is data sorting?

Ans: Data sorting means grouping all the records in a table either in ascending or descending order based on a key field of the record.

c) What is a form?

Ans: Form is an object of MS-Access which provides a user friendly interface to enter data in a table or multiple linked tables.

8. Select the best answers:
     a) ………………. Is not a data type of MS-Access.
       i) Number             ii) Text             iii) Memo         iv) Form

            Form

     b) Primary key does not accept ……….
        i) Text                  ii) Number       iii) Null value   iv) None of the above
            Null value

           

c) ……………….. object of access is used to print formatted data.
        i) Query               ii) Form                        iii) Report        iv) Table

        Report

     d) In MS-Access data are stored in ………………
        i) Form                 ii) Query          iii) Table          iv) All of the above

Table

9. Match the following:
      Group A                            Group B
   a) Indexing                           a) Limits the value
   b) Report                              b) Data type
   c) Validation Rule                 c) Error messages
   d) Hyper link                                    d) Final output
                                                e) Search fast

Answers

       Group A                           Group B
   a) Indexing                           Search fast   b) Report                              Final output   c) Validation Rule                 Limits the value
   d) Hyper link                         Data type
                                                

            Group C- Programming (18 marks)
10.  a) What is loop?

Ans: Loop means executing a statement or group of statements a certain number of times depending upon the condition.

b) List any two data types supported by ‘C’ language.

Ans: Any two data types supported by ‘C’ language are:

i) char

ii) int

       c) State the function of the following statement:
             i) EOF                       

            Ans: It detects the end of the file marker reading the data from an open sequential file.

ii) MKDIRAns: It creates a subdirectory which is used to manage files.

11. Re-write the given program after correcting the bugs:
CREATE FUNCTION Square(A)
Rem to print square of a number
CLS
Get “a number”; A
CALL square(A)
END

FUNCTION square(A)
Ans=A^2
Square=Ans
END Square(A)

Debugged ProgramDECLARE  FUNCTION Square(A)
Rem to print square of a number
CLS
INPUT “a number”; A
PRINT square(A)
END

FUNCTION square(A)
Ans=A^2
Square=Ans
END FUNCTION

  

13. Analyze the program given below and answer the questions:
Declare function count(N$)
Input “Enter a word”; R$
C= Count(R$)

Print C
END
Function count(N$)
For k=1 to LEN(n$)
X$=MID$(N$,K,1)
IF UCASE$(X$)=”A” then
X=X+1
End if
Next K
Count = X
End function
i) List any two library functions used in the above program.

Ans: Any two library functions used in the above program are

1)      UCASE$( )

2)      MID$( )

ii) Write the use of variable ‘C’ inline 3 [i.e. C=Count(R$)] given in the above program.Ans: The use of variable ‘C’ inline 3 [i.e. C=Count(R$)] given in the above program is to call the function and store the value returned by the function count.

14. a) Write a program to calculate the area of four walls using SUB…END SUB.

            DECLARE SUB AREA (L, B, H)

            CLS

            INPUT “ENTER LENGTH”; L

            INPUT “ENTER BREADTH”; B

            INPUT “ENTER HEIGHT”; H

            CALL AREA (L, B, H)

            END

            SUB AREA(L, B, H)

            A = 2 * H * (L + B)

            PRINT “AREA OF FOUR WALLS=”; A

            END SUB

       b) Write a program using FUNCTION…..END FUNCTION to get a word  

            from the user and print it in reverse order.

            DECLARE FUNCTION REV$ (S$)

CLS

INPUT "ENTER ANY WORD"; S$

PRINT "REVERSED WORD IS "; REV$(S$)

END

FUNCTION REV$ (S$)

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

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

W$ = W$ + B$

NEXT I

REV$ = W$

END FUNCTION

        c) A sequential data file called “student.dat” contains some records under the  

             field’s name, English, Nepali and Computer. Write a program to add some

             more records in the same sequential data file.
           

            OPEN “student.dat” FOR APPEND AS #1

            DO

CLS

INPUT “ENTER NAME”; N$

INPUT “ENTER MARKS IN ENGLISH”; E

INPUT “ENTER MARKS IN NEPALI”; N

INPUT “ENTER MARKS IN COMPUTER”; C

WRITE #1, N$, E, N, C

INPUT “DO YOU WANT TO CONTINUE”; CH$

LOOP WHILE UCASE$(CH$) = “Y”

CLOSE #1

END

           

***