SEE Computer Science Examination Paper Solved 2075

SEE Computer Science Examination Paper Solved 2075

SEE Examination 2075

Computer Science

Group “A”

Computer Fundamental [22 marks]

 

1. Answer the following questions. (2x5=10)

    a. Write any two features of Guided media.

Ans: The two features of Guided media are listed below:

·      It provides the physical connection between networking devices.    

·      Data travel in the pre-defined path.

 

b. Write any four advantages of internet.

Ans: The advantages of the internet are:

·      It helps in faster communication. 

·      It helps in sharing the data and information.

·      It helps to connect people through social media like Facebook, Instagram, etc.

·      It helps in teaching and learning activities in school, colleges and in universities.

        

c. What is multimedia?

Ans: Multimedia is the technology of presenting the information in more interesting, effective and in an understandable manner by the use of more than one media such as text, audio, video, animation, picture.

 

d. How password secure the data?

Ans: Password secures the data by preventing the system from unauthorized access and giving access to those who knows the password. 

 

      e. Write any two preventive measures to protect the computer from a computer virus?

Ans: The two preventive measures to protect a computer from computer virus are listed below:

·      Use antivirus software and scan the system regularly.

·      Do no open unknown emails.

 

 

     

ii. (39C)₁₆ into Decimal

     soln:

3x16² + 9x16¹ + Cx16⁰

= 3x256 + 9x16 + 12x1

= 768 + 144 + 12

= 924

 

                Therefore: (39C)₁₆ = (924)₁₀

      

    b. Perform the binary Calculation. (1x2=2)

i.        1011 × 11

Soln:    

1      0    1

X   1    1

1    0   1 

+1   0    1   X    

1   1    1   1

 

:. 1011x11= 1111

                           

ii. 110111 – 11001

Soln:

     110111

-       11001

  11110

 

:. 110111 – 11001= 11110

 

    

3. Match the following. (0.5x4=2)

Group A          Group B

a.      HUB            Communication media

b.      TCP/IP        network connecting device

c.       UTP             Windows NT

d.      NOS            protocol

 computer security

 

Answer

Group A          Group B

a.      HUB            Network connecting device

b.      TCP/IP        Protocol

c.       UTP            Communication media

d.      NOS            Windows NT

                                       

4. Choose the best answer of the following. (0.5x4=2)

a. The physical structure of a computer network.

          i. protocol              ii. Topology          iii. MAN       iv. cabling

b. Which is not an internet service?

          i. E-commerce   ii. NIC    iii. WWW      iv. E-Mail

c. Which is not a computer virus?

i. Kaspersky          ii. message carrying virus          

iii. Boot sector virus                  iv. program virus

d. A topology where all the computers are connected to a central connecting device, HUB or switch.

          i. BUS       ii. STAR                iii. TREE               iv. RING

 

5. Write the appropriate technical terms of the following. (0.5x4=2)

a.   A powerful computer which controls and co-ordinates all computers connected in a network.    Server

b.   The volume of bits that can be transferred per second through the communication media.    Bandwidth

c.    Making a duplicate copy of file or data.    Backup

d.   Illegal activities committed through the use of computers and the Internet. Cyber Crime

 

6. Write the full form. (0.5x4=2)

     STP              Shielded Twisted Pair

     PDF             Portable Document Format

     NIC              Network Interface Card

     IRC              Internet Relay Chat

 

Group B Database (10 Marks)

 

7. Answer the following questions. (2x3=6)

a. Write any two advantages of Database Management System.

Ans: The two advantages of Database Management System are

·      It helps to create, manage, and update database.

·      It helps to retrieve information from the existing database.

 

b. What is Primary key?

Ans: Primary key is a field of a table that uniquely identifies the record and helps to prevent from data repetition.

 

c. Write any two functions of form.

Ans: The two functions of a form are listed below:

·      It allows to enter data easily by providing graphical interface.

·      It helps to edit, update as well as delete data from the database.

 

8. State whether the following statements are true or false. (0.5x4=2)

a.   The size of the currency data type is 10 Bytes. False

b.   Indexing is the process of arranging the records in ascending or descending order. False

c.    Validation rule will limit data entry. True

d.   Select Query is used to retrieve and display records from the selected table. True

 

9. Match the following. (0.5x4=2)

Group A                      Group B

a.   Yes/No                       4 bytes

b.   Long Integer             Access Object

c.    OLE                             Picture

d.   Report                        1 bit

                                     8 bytes

 

Answer

Group A                       Group B

a.   Yes/No                      1 Bit

b.   Long Integer             4 Bytes

c.    OLE                             Picture

d.   Report                        MS Access Object

 

Group C Programming (18 Marks)

10. Answer the following questions. (1x3=3)

a. Define logical operators.

Ans: Logical operators are symbols, that performs logical calculations like comparing data and giving result as True/False or Yes/No.

 

b. Write any two advantages of structure programming.

Ans: The two advantages of structured programming are listed below:

·      It is easy to design code and debug the program modules independently.

·      Single modules can be used more than once in the program.  

 

c. Write the function of the following command / statements:

i.     FILES: The FILES statement displays the files of the current directory or specified sub directory.

ii.    WRITE: It helps to store the data to a particular file.

 

11. Re-Write the given program after correcting the bugs. (0.5x4=2)

DECLARE FUNCTION reverse$(N$)

INPUT “Any String”; N$

X$ = reverse$(N$)

PRINT N$

END

FUNCTION reverse(N$)

L = LEN$(N$)

FOR X = L to 1 STEP – 1

A$ = MID$(N$, X, I)

B$ = B$ + A$

NEXT X

B$ = reverse$(N$)

END FUNCTION

 

Debugged Program

DECLARE FUNCTION reverse$(N$)

INPUT “Any String”; N$

X$ = reverse$(N$)

PRINT X$

END

FUNCTION reverse$(N$)

L = LEN(N$)

FOR X = L TO 1 STEP – 1

A$ = MID$(N$, X, 1)

B$ = B$ + A$

NEXT X
reverse$ =  B$

END FUNCTION

  

12. Write the output of the following program. (2)

DECLARE SUB series ()

CALL series

END

SUB series

X = 1

FOR K = 1 TO 4

PRINT X;

X = X + K

NEXT K

END SUB

 

OUTPUT:         1          2          4          7

 

13. Study the following program and answer the given questions. (1x2=2)

DECLARE SUB SUM (N)

N = 5

CALL SUM (N)

END

SUB SUM (N)

FOR X = 1 TO N

S =S + X

NEXT X

PRINT S

END SUB

 

a.   In the above program, how many times does the FOR ………..NEXT loop executes?

Ans: The FOR ………..NEXT loop will execute 5 times.

b.   Write the name of the procedure used in the above program.

Ans: The name of the procedure used in the above program is SUM.

 

14 a. Write a program to calculate the average of three numbers using FUNCTION procedure.  (3)

DECLARE FUNCTION Average (A, B, C)

CLS

INPUT “ENTER FIRST NUMBER”; A

INPUT “ENTER SECOND NUMBER”; B

INPUT “ENTER THIRD NUMBER”; C

PRINT “The average of three number is”; Average (A, B, C)

END

FUNCTION Average (A, B, C)

Avg = (A+B+C)/3

Average = Avg

END FUNCTION

   

 

b. Write a program to print the total number of vowel alphabets present in the given word using SUB procedure. (3)

DECLARE SUB Vowel (W$)

CLS

INPUT "ENTER ANY STRING"; W$

CALL Vowel (W$)

END

SUB Vowel (W$)

FOR I = 1 TO LEN (W$)

A$ = MID$(W$, I, 1)

C$ = UCASE$(A$)

IF C$ = "A" OR C$ = "E" OR C$ = "I" OR C$ = "O" OR C$ = "U" THEN

C=C+1

END IF

NEXT I

PRINT "TOTAL NO. OF VOWELS= "; C

END SUB

 

c. A data file “STAFF.dat” has stored records of few employees with EMPID, First name, last name, post and salary. Write a program to display all the records of the employees whose salary is more than 40,000. (3)

OPEN “STAFF.dat” FOR INPUT AS #1

CLS

DO WHILE NOT EOF (1)

INPUT #1, ID, F$, L$, P$, S

IF S > 40000 THEN

PRINT ID, F$, L$, P$, S

LOOP 

CLOSE #1

END