SEE Computer Science Exam Paper Solved 2067

SEE Computer Science Exam Paper Solved 2067

SEE Examination 2067

Computer Science

Group “A”

Computer Fundamental [22 marks]

 

1.   Answer the following questions. (5x2=10)

a.   Write any two examples of data communication.
Ans: The two examples of data communication are listed below:
·      Sending email
·      Sharing file from one computer to another.
b.   What do you mean by web browser?
Ans: A web browser is an application software that helps to access internet and display the content of web pages.
c.    Write any four advantages of multimedia.
Ans: The four advantage of multimedia are listed below:
·      It helps to share the information effectively.
·      It helps in design computer graphics.
·      It provides entertainment with movies and cartoons.
·      It helps in effective learning.
d.   Write any four symptoms of computer virus.
Ans: The four symptoms of computer virus are listed below:
·      Computer becomes slow.
·      Missing of files and folders.
·      Applications open automatically.
·      Irritating messages will display frequently. 
e.   What is computer security?
Ans: The process of securing computer form being damaged and maintaining it for well-functioning for long term is called computer security. 
 

2.   a. Convert as indicated. (1x2=2)

i.     (AC3)₁₆ into decimal

Soln:

 A X 16² + C X 16¹ + 3 X 16⁰
=10 X 256 + 12 x 16 + 3 X 1
=2560 + 1792 + 3
=4355
Therefore: (AC3)₁₆ = (4355)₁₀
 
ii.   (110010)₂ into octal
Soln:
Binary 110       010
Octal   6          2
Therefore: (110010)₂ = (62)₈
 

b.   Binary calculations. (1x2=2)

i.     11 x 11 – 101
Slon:
    1        1
X 1       1
1          1
+1  1  x
1 0  0    1
-1  0    1
1  0    0
 
:. 11x11-101 = 100
 

ii. Divide 1010 by 10 

 

soln:

     10)1010(101

10

001

0010

-    10

0000

Q:101

R: 0

    

                                     

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

Group A                      Group B

a.  Satellite                  Multimedia

b.  HTTP                       High bandwidth

c.  Online Business      Unguided media

d.  Fiber optics             E- commerce

Protocol

Answer

Group A                      Group B

a.  Satellite                  Unguided media

b.  HTTP                       Protocol

c.  Online Business      E-commerce

d.  Fiber optics High     bandwidth

 

 

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

a.   Which is not a communication media?

i. Wire             ii. Microwave    iii. Satellite      iv. NIC

 

b.   Which is a web browser?

i. Window NT              ii. Internet explorer       

iii. Window 2007         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 the appropriate technical terms of the following. (0.5x4=2)

a.   An internet tool that helps to upload/download the file.  FTP

b.   Making duplicate copy of file for security purpose. Backup

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

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

 

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

a.  URL       Uniform Resource Locator

b.  ISP         Internet Service Provider

c.  ASCII    American Standard Code for Information Interchange  

d.  BPS       Bits Per Second

 

Group B Database (10 marks)

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

a.   Define DBMS with examples.

Ans: DBMS is a system or a software that creates, modifies, update and maintain databases. Ex: MS-ACCESS, ORACLE, etc.
b.   What is primary key? 
Ans: Primary key is a field of a table that uniquely identifies each record of the table.
c.    Why report is created?
Ans: Report is created to get the formatted data from the database for printing the data of the database.
 
 

8.   Choose the best answer.  (0.5x4=2)

a.   Which is not a type of query?
i. Search        ii. Select       iii. Update         iv. All of the above
b.   The storage size of Date and Time is…….
i. 4 Bytes      ii. 6 Bytes           iii. 8 Bytes           iv. 10 Bytes
c.    Collecting multiple related fields is called…….
i. Record         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.  (0.5x4=2)

Group A                      Group B

a.   OLE                         Report

b.   Data Entry               Picture

c.    Indexing                  Table

d.   Formatted               Fast searching

    Printout                    Form

                        
                         

Answer

Group A                      Group B

a. OLE                          Picture

b.   Data Entry               Form

c.    Indexing                  Fast searching

d.   Formatted                Report

    printout                      

 
    
                         

Group C Programming (18 marks)

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

a.   What is procedures?

Ans: Procedures are the block of codes that performs a pre-defined task when executed.

b.   Write any two characteristics of C Language.

Ans: The two features of C language are listed below:

·      It has many library functions.

·      It is used for developing operating system.

c.    Write the function of the following commands

i.     INPUT- This statement is used to receive input from the user.

ii.    MKDIR- It is used to create a new directory or a sub directory.

 

11.  Write the output of the given program. (2)

DECLARE SUB result(n$)

CLS

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

Output: SINE

 

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

REM to display all the records from 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

 

Program after correcting bugs

REM to display all the records from data file “ABC.DAT”

OPEN “ABC.DAT” FOR INPUT AS #1

DO WHILE NOT EOF (1)

INPUT # 1, N$, A$

PRINT N$, A

CLOSE# 1

END

 

13. Read the given program and answer the given questions.                                          (2)

DECLARE SUB SUM(N)

INPUT “ANY Numbers”; 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

 

a.   In which condition the statements within the WHILE…...WEND looping statement will not be executed?

Ans: When the value of N will be 0, the statements within the WHILE…...WEND looping statement will not be executed.

b.   Will the output be same if the place “/” instead of “\” in the above program?

Ans: No the output will not be the same.

 

14.  a. Using FUNCTION…END FUNCTION write a program to find the average of three numbers. (3)     

DECLARE FUNCTION AVG (a, b, c)

CLS

INPUT” ENTER FIRST NUMBER”; a

INPUT” ENTER SECOND NUMBER”; b

INPUT” ENTER THIRD NUMBER”; c

PRINT” THE AVERAGE NUMBER IS”; AVG (a, b, c)

END

FUNCTION AVG (a, b, c)

Average= (a + b + c)/3

AVG= Average

END FUNCTION

b.   Write a program to test whether a number is completely divisible by 13 or not. Use SUB…...END SUB.  (3)                              

DECLARE SUB CHECK(N)

CLS

INPUT” ENTER A NUMBER”; N

CALL CHECK(N)

END

SUB CHECK(N)

IF N MOD 13=0 THEN

PRINT “THE NUMBER IS COMPLETELY DIVISIBLE BY 13”

ELSE

PRINT” THE NUMBER IS NOT COMPLETELY DIVISIBLE BY 13”

END IF

END

 

c. 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). (3)

OPEN “EMP.DAT” FOR INPUT AS #1

CLS

DO WHILE NOT EOF (1)

INPUT#1, NAME$, POST$, SALARY

TAX= (15/100) * SALARY

PRINT NAME$, POST$, SALARY, TAX

LOOP

CLOSE # 1

END