SEE Computer Science Examination Paper Solved 2069

SEE Examination 2069

Computer Science

Group “A”

Computer Fundamental [22 marks]

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

a. Write any four advantages of a computer network.

Ans: The four advantages of a computer network are listed below:

· Computer in a network can access network-connected hardware devices like printer, disk drives, etc.

· Information can be exchanged in computer network.

· Computer network allows us to work in a group.

· Software packages can be shared between network connected computers.

b. What is internet? Write the name of any two E-commerce sites.

Ans: Internet is an interconnection of millions of computers across the world for sharing information.

The two E-commerce websites are listed below:

· www.Amazon.com

· www.Daraz.com

c. What is computer ethic?

Ans: Computer ethics is the set of moral principles or code of conducts that should be followed by computer user.

d. What is hardware security? Write any two software security measures.

Ans: The security given to computer hardware to protect from being damaged due to dust, dirt, heat, fire or theft is called hardware security.

Any two software security measures are:

· password

· backup

e. What is a computer virus?

Ans: Computer virus is a destructive man-made program that harms computer data and hardware.

ii.(101011)₂ into decimal

Soln:

1x2⁵ + 0x2⁴ + 1x2³ + 0x2² + 1x2¹ + 1x2⁰

=1x32 + 0x16 + 1x8 + 0x4 + 1x2 + 1x1

=32 + 0 + 8 + 0 + 2 + 1

=43

Therefore: (101011)₂= (43)₁₀

1. Binary Calculation. (1x2=2)

i. 1101 x11

Soln:

1 0 1 1

x 1 1

1 0 1 1

+ 1 0 1 1 x

1 0 0 0 0 1

ii. Divide 100101 by 110

Soln:

110)100101(110

-110

110

-110

X 1

- 0

:. Q= 110 R= 1

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

   Group A                      Group B
a. RJ-45                        Multimedia
b. WAN                        Duplicate copy
c. Back up                    Fiber optic cable
d. microphone              Twisted pair cable

Internet

Answers

Group A Group B
a. RJ-45 Twisted pair cable
b. WAN Internet
c. Back up Duplicate copy
d. microphone Multimedia

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

a. Which is not unguided media?
i. Fiber optics ii. Microwave iii. Infrared iv. Radio wave

b. Which is the internet service?
i. IRC ii. Telnet iii. E-mail iv. All of the above

c. Which is not related to multimedia?
i. Printer ii. Sound card iii. Microphone iv. CD-ROM

d. Which virus infects boot sector files?
i. Macro virus ii. Multipartite virus iii. Boot sector virus

iv. Program virus

5. Give appropriate technical terms. (0.5x4=2)

a. Business through internet. E-commerce

b. The software that protects computer virus. Antivirus Software

c. Physical layout of LAN. Topology

d. A secret word that gives user access to a particular program or computer system. Password

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

a. VOIP Voice Over Internet Protocol

b. MAN Metropolitan Area Network

c. UTP Unshielded Twisted Pair

d. WWW World Wide Web

Group B Database (10 marks)

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

a. What is database? Give two examples.

Ans: Database is a collection of related and organized information that can be used for a different purpose.
Two examples of database are listed below:

· Dictionary

· Telephone Directory

b. Write any two types of primary key.

Ans: The two uses of Primary key are listed below:
To reduce and control duplication of record in a table.
To set the relationship between tables.

c. What is query?

Ans: Query is an object of MS-Access which extracts and displays information from a table.

8. Choose the best answer. (0.5x4=2)
a. Which of the following is not a database application?
i. Oracle ii. FoxPro iii. MS-Access iv. MS-Excel

b. Memory space consumed by a currency data type maximally is ………
i. 2 bytes ii. 4 bytes iii. 8 bytes iv. 1 GB

c. The default data type of MS-Access is:
i. Number ii. Text iii. Memo iv. Auto number

d. Row is also called …………
i. Record ii. Field iii. Database iv. Table

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

   Group A                 Group B
a. OLE                    Data Entry
b. Hyperlink Formatted  Hardcopy
c. Report 1 GB

d.Form Up to 255 characters

Up to 2048 characters

Answers

Group A Group B
a. OLE 1 GB

b. Hyperlink Up to 2048 characters
c. Report Formatted Hardcopy

d. Form Data Entry

Group C Programming (18 marks)

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

a. What is meant by mode of data file?

Ans: Mode of data file means opening a sequential file for one of the three modes of operation like output mode, input mode and append mode.

b. Write any two characteristics of ‘C’ language.

Ans: The characteristics of ‘C’ language are listed below:
It is a high level language with some features of low level language.
It is mostly used to prepare system software.

c. Write the function of the following statements:
i. NAME: The NAME statement renames a file on a disk.

ii. KILL: The KILL statement deletes the file from the specified drive and directory.

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

DECLARE SUB NUMBER ()

CLS

CALL NUMBER

END

SUB NUMBER

N=3

C=1

WHILE C<=5

PRINT N

N=N*10+3

C=C+1

WEND

END SUB

OUTPUT

333

3333

33333

12. Rewrite the given program after correcting the bugs. (0.5x4=2)

REM display Records of students from Data File

OPEN “STDREC.DAT” FOR INP AS #1

PRINT “ROLL”,”NAME”,”ADDRESS”,”CLASS”,”SECTION”

DO WHILE NOT EOF

INPUT #1,RN,N$,AD$,CL,S$

PRINT RN,N$,AD$,CL,S$

CLOSE #1

END

Debugged Program

REM display Records of students from Data File

OPEN “STDREC.DAT” FOR INPUT AS #1

CLS

PRINT “ROLL”,” NAME”,” ADDRESS”,” CLASS”,” SECTION”

DO WHILE NOT EOF (1)

INPUT #1, RN, N$, AD$, CL, S$

PRINT RN, N$, AD$, CL, S$

LOOP

CLOSE #1

END

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

DECLARE SUB EXAM(N$)

CLS

INPUT “Enter word”; WO$

CALL EXAM(WO$)

END

SUB EXAM (N$)

FOR I = 1 TO LEN (N$)

PRINT RIGHT$(N$, I)

NEXT I

END SUB

a. Write the names of two built-in functions used in the above program.

Ans: The names of two built-in functions used in above program are LEN( ) and RIGHT$( ) .

b. List the real parameter in the program.

Ans: The real parameter used in the above program is WO$.

14. a. Write a program to find the numbers of vowels in an input string using FUNCTION ….. END FUNCTION. (3)

DECLARE FUNCTION COUNT (S$)

CLS

INPUT "ENTER ANY STRING"; S$

PRINT "TOTAL NO. OF VOWELS= "; COUNT(S$)

END

FUNCTION COUNT (S$)

C = 0

FOR I = 1 TO LEN(S$)

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

B$ = UCASE$(B$)

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

C = C + 1

END IF

NEXT I

COUNT = C

END FUNCTION

b. Write a program using sub procedure module to print the series 1,1,2,3,5,8.. up to ten terms. (3)

DECLARE SUB SERIES ( )

CLS

CALL SERIES

END

SUB SERIES ( )

A = 0

B = 1

FOR I = 1 TO 10

C = A + B

PRINT C;

A = B

B = C

NEXT I

END SUB

c. Write a program to create a data file ‘teldir.dat’ to store Name, Address and Telephone number of employees according to the need of the user. (3)

OPEN “teldir.dat” FOR OUTPUT AS #1

CLS

INPUT “ENTER NAME”; N$

INPUT “ENTER ADDRESS”; A$

INPUT “ENTER TELEPHONE NUMBER”; T

WRITE #1, N$, A$, T$

INPUT “DO YOU WANT TO CONTINUE(Y/N)”; CH$

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

CLOSE #1

END

Computer Science

Search This Blog