SEE 2075 (2019) Computer Science Solved

SEE 2075 (2019)

Computer Science Solved

Group A

Computer Fundamentals (22 Marks)

1. Answer the following questions:

a) Write any two features of Guided media.

Any two features of Guided media.

Twisted-pair and coaxial cable use metallic (copper) conductors that accept and transport signals in the form of electric current.

Optical fibre is a cable that accepts and transports signals in the form of light.

b) Write any four advantages of internet.

The advantages of internet are:

a)    The internet provides the ability of emails. Free mail service to anyone in the country. 

b)    Things such as Yahoo Answers and other sites where kids can have readily available help for homework. 

c)    Message boards where people can discuss ideas on any topic. Ability to get wide range of opinions. People can find others that have a similar interest in whatever they are interested in. 

d)    News, of all kinds is available almost instantaneously. Commentary, on that news, from every conceivable viewpoint is also available. 

c) What is multimedia?

Multimedia is the integration of multiple forms of media, which presents information in more interesting and understandable way.

d) How password secure the data?

Password secures the data by giving access to the authorized person only.

e) Write any two preventive measures to protect  computer from computer virus?

Any two preventive measures to protect  computer from computer virus

ii) Scan the mail or unknown files of internet before opening in your computers.
iii) Use a good antivirus program to scan floppy disk, CD, etc. before copying.

2.

 

  

3. Match the following:

Group A                          Group B

a)    HUB                      i) communication media

b)    TCP/IP                             ii) Network connecting device

c)    UTP                       iii) Windows NT

d)    NOS                      iv) Protocol

                                        v) computer security

Answers

Group A                          Group B

a)    HUB                      i) Network connecting device

b)    TCP/IP                             ii) Protocol

c)    UTP                       iii) communication media

d)    NOS                      iv) Windows NT

                                       

4. Choose the best answer of the following:

a) The physical structure of 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) 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:

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 duplicate copy of file or data. Backup

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

6. Write the full form:

i) STP – Shielded Twisted Pair

ii) PDF – Portable Document Format

iii) NIC – Network Interface Card

iv) IRC – Internet Relay Chat

Group B

Database

7a. Write any two advantages of Database Management System.

Any two advantages of Database Management System are

i) It controls data redundancy which means duplication of data.
ii) It allows sharing the existing database by different programs.

b. What is Primary key?

Primary key is a field that uniquely identifies the record.  It is needed because it neither accepts duplicate values nor  permit null values.

c. Write any two functions of form.

Any two functions of form are

i) It allows to design the layout of field on screen in any arrangement.
ii) It shows only the information we want to see.

8 State whether the following statements are true or false.

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

b) Validation rule will limit data entry. True

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

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

9. Match the following:

Group A                          Group B

a)    Yes/No                  i) 4  Bytes

b)    Long Integer          ii) MS Access Object

c)    OLE                       iii) Picture

d)    Report                    iv) 1 Bit

v) 8 Bytes

Answers:

Group A                                    Group B

a)    Yes/No                            i) 1 Bit

b)    Long Integer                    ii) 4  Bytes

c)    OLE                                 iii) Picture

d)    Report                              iv) MS Access Object

Group C

Programming (18 Marks)

10 a.Define logical operators.

Ans: Logical operators are symbols, which are used to combine two or more logical or relational expressions and return a single ‘true’ or ‘false’ value.

b.Write any two advantages of structure programming.

Ans: The two advantages of structured programming are:

a)     It is easy to design code and test the program modules independently

b)     It is possible to use a single module in different in different places which reduces program codes.  

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

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

ii) WRITE: It sends one or more data items to the specified file.

11. Re-Write the given program after correcting the bugs:

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:

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:

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.

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

DECLARE FUNCTION AVERAGE (A, B, C)

CLS

INPUT “ENTER FIRST NUMBER”; A

INPUT “ENTER SECOND NUMBER”; B

INPUT “ENTER THIRD NUMBER”; C

AVGR = AVERAGE(A, B, C)

PRINT “AVERAGE OF TWO NUMBERS”; AVGR

END

FUNCTION AVERAGE (A, B, C)

AV = (A + B + C) / 3

AVERAGE = AV

END FUNCTION

   

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

DECLARE SUB COUNT (S$)

CLS

INPUT "ENTER ANY STRING"; S$

CALL COUNT(S$)

END

SUB COUNT (S$)

VC = 0

FOR I = 1 TO LEN(S$)

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

C$ = UCASE$(B$)

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

VC = VC + 1

END IF

NEXT I

PRINT "TOTAL NO. OF VOWELS= "; VC

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.

OPEN “SALARY.dat” FOR INPUT AS #1

CLS

WHILE NOT EOF(1)

INPUT #1, A, B$, C$, D$, E

IF E > 40000 THEN PRINT A, B$, C$, D$, E

WEND

CLOSE #1

END

***