SEE Computer Science Examination Paper Solved 2074

 SEE Computer Science Examination Paper Solved 2074

SEE Computer Science Examination Paper Solved 2074
SEE Computer Science Examination Paper Solved 2074

 

SEE Examination 2074

Computer Science

Group “A”

Computer Fundamental [22 marks]

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

a.   Define computer network.

Ans: The interconnection of two or more than two computers for data communication is called computer network. 


b.   Define Internet.

Ans: The world’s largest computer network that connects millions of computers across the world for data communication is called internet.


c.    Write the importance of power protection device to protect the computer system.

Ans: The importance of power protection device to protect the computer system are listed below:

·      It protects from power fluctuations.

·      It supplies constant voltage.

·      UPS provides backup power that helps to save computer data.


d.   Write any two symptoms that can be seen when a computer is infected by computer virus.

Ans: The symptoms that can be seen when a computer is infected by computer virus are listed below:

·      Computer becomes hang and perform slowly.

·      Applications opens automatically.

 

 

e.   What is cybercrime? Give any two examples.

Ans: Cyber-crime refers to any illegal activity that is done with the help of computer and internet.

Two cyber-crimes are listed below:

·      Software piracy

·      Hacking

 

  2. a. Perform the conversion as per the direction. (1x2=2)

i.  (523)8 into Binary  

Soln:    

Octal   5                      2                      3

Binary  101                  010                  011

Therefore: (523)= (101010011)2

 



 

 

 

 

 

 







b. Binary Calculation. (1x2=2)

 i.  110 x 101     

Soln:                       

 1   1   0

x 1 0   1

 1    1   0

0  0   0  x

+ 1   1   0  x   x

  1     1  1     0

:. 110 x 101 = 11110

ii.111010 ÷ 110

     Soln:

            110) 111010(1001

-110

 X    1010

                             -110  

                               100

:. Q= 1001        R=100

 

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

Group A                                     Group B

a.   RJ 45 connector                  Duplicate copy

b.   Back up                               Multimedia

c.    Microphone                        Twisted pair cable

d.   Hub/switch                         Ring Topology

Star Topology

Answer

Group A                                                  Group B

a.   RJ 45 connector                  Twisted pair cable

b.   Back up                               Duplicate copy

c.    Microphone                        Multimedia

d.   Hub/switch                         Star Topology

 

 

 

 

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

a. Which of the following is not a network protocol?

i. POP    ii. FTP     iii. TCP/IP     iv. NOS

b. Which of these software is used for photo editing?

i. MS-Excel    ii. Photoshop    iii. Power-Point     iv. MS-Word

c. Which device is used to connect multiple networks that uses the same protocol.

i. Bridge    ii. NIC     iii. Switch     iv. Gateway

d. Process of arranging the scattered files into a contiguous manner.

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


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

a.   The physical layout of local area network. Topology

b.   The business conducted through Internet. E-commerce

c.    The law which controls the crime which is done with the help of computer and Internet. Cyber law

d.   A computer or device which provides different services to other computers connected to the network. Server computer

 

 

6. Write the full forms of. (0.5x4=2)  

a.   SMTP          Simple Mail Transfer Protocol

b.   WAN           Wide Area Network   

c.    URL              Uniform Resource Locator  

d.   VOIP            Voice Over Internet Protocol

 

Group B Database (10 Marks)

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

a.   Define Database.

Ans: Database is the organized collection of information in a systematic way that can used for various purposes.


b.   What is data redundancy? How can it be reduced in database?

Ans: The repetition of same record in a table is called data redundancy.

It can be reduced by using primary key.


c.    Mention any four data types that can be used in MS-Access.

Ans: The four data types used in MS-Access are listed below:

·      Text

·      Memo

·      Currency

·      Date/Time

 8. Select the correct answer. (0.5x4=2)

a. Which of the following is not accepted by primary key?

i. Number    ii. Text    iii. Null value    iv. None

b. What is called rows in database table?

i. Field     ii. Record    iii. Form    iv. None

c. Which data type consumes the least storage space?

i. Text     ii. Yes/No    iii. OLE object     iv. Memo

d. Which is the default data type of MS-Access?

i. Memo     ii. Number    iii. Text     iv. Auto number

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

Group A          Group B

a.   Data            Input, view, edit data

b.   Form           Formatted output

c.    Report         Collection of raw facts

d.   Table           Question to the database

Stores data in database

Answer

Group A          Group B         

a.   Data            Collection of raw facts

b.   Form           Input, view, edit data

c.    Report         formatted output

d.   Table           Stores data in database

Group C Programming (18 Marks)

10. Answer the following questions. (3x1=3)

a.   What is formal parameter?

Ans: The parameter used while declaring the procedure is called a formal parameter.

b.   List any two data types used in C programming language.

Ans: The wo data types used in C programming language are listed below:

·      Int

·      Char

c.    Write the function of KILL and CLOSE statements.

i.     The function of KILL is to delete files on a disk.

ii.    The function of CLOSE statement is to close open files.

 

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

REM TO find the factorial of a given number.

DECLARE FUNCTION FACTO (N$)

CLS

INPUT "Enter a number"; X

PRINT "The Factorial is: "; FACTO (N)

END

FUNCTION FACTO (N)

F = 1

WHILE N = 0

F = F*N

N = N - 1

WEND

F = FACTO

END FUNCTION

 

Debugged Program

REM TO find the factorial of a given number.

DECLARE FUNCTION FACTO (N)

CLS

INPUT "Enter a number”; N

PRINT "The Factorial is: "; FACTO (N)

END

FUNCTION FACTO (N)

F = 1

 WHILE N <> 0

 F = F*N

 N = N - 1

 WEND

 FACTO = F

 END FUNCTION

 

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

DECLARE SUB Display (T$)

CLS

T$ = "COMPUTER"

CALL Display (T$)

END

SUB Display (T$)

FOR C = 1 TO LEN (T$) STEP 2

$ = MID$ (T$, C, 1)

PRINT D$;

NEXT C

END SUB

OUTPUT:         C          M         U          E

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

DECLARE   FUNCTION   SUM (N)

CLS

INPUT "Enter any number"; N

S= SUM (N)

PRINT "The Sum of individual digit is:"; S

END

FUNCTION SUM (N)

WHILE N > 0 R = N MOD 10

S= T + R

N = N\10

WEND

SUM = T

END FUNCTION

a.   State the purpose of using variable S in line 4 in the above program.

Ans: The purpose of using variable S is to call the function and store the value returned by the function. 

b.   Write the use of MOD in the above program.

Ans: The MOD is used to calculate the remainder.


14. a. Write a program to calculate the area of a circle using Sub..... End Sub. (3)

DECLARE SUB AREA (R)

CLS

INPUT” ENTER THE RADIUS”; R

CALL AREA(R)

END

SUB AREA(R)

A= (22/7) * R^ 2

PRINT” THE AREA OF CIRCLE IS “; A

END SUB

 

b.   Write a program using FUNCTION... END FUNCTION to count the number of words in a sentence. (3)

DECLARE FUNCTION COUNT(S$)

CLS

INPUT” ENTER A SENTENCE”; S$

PRINT” TOTAL NUMBER OF WORDS”; COUNT(S$)

END

FUNCTION COUNT(S$)

W=1

FOR I = 1 TO LEN(S$)

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

IF C$ = ” “ THEN

W=W+1

END IF

NEXT I

COUNT=W

END FUNCTION

 

c.    Write a program to store Roll no., Name, Class, and Address of any five students. (3)

OPEN “STD.DAT” FOR OUTPUT AS #1

CLS

FOR I = 1 TO 5

INPUT” ENTER ROLL NUMBER”; RN

INPUT” ENTER NAME”; N$

INPUT” ENTER CLASS”; C

INPUT” ENTER ADDRESS”; A$

WRITE #1, RN, N$, C, A$

NEXT I

CLOSE #1

END



Comments