Solved Computer Science - SEE (Supplementary/Upgrade) 2073 (2017)

SEE (Supplementary/Upgrade) 2073 (2017)

(Group 'A')

Computer Fundamental (22 Marks)

Answer the following questions:

a)      What is multimedia? Name any two fields where multimedia is used.

Ans: Multimedia is the integration of multiple forms of media, which presents information in more interesting and understandable way. Any two fields where multimedia is used are communication and

Entertainment.

b)     What is antivirus? Name any two antivirus software.

Ans: Antivirus software is software designed to detect and remove virus from computer system to ensure virus free environment. Any two antivirus software are NAV and  Kaspersky,

c)      Give two advantages of e-mail over traditional mail.

Ans: The  two advantages of e-mail over traditional mail are:

v  E-mail is faster, cheaper, more reliable than traditional mail.

v  Unlike traditional mail, email can be accessed from anywhere in the world.

d)     Give the importance of MODEM to the computer network.

Ans: The importance of MODEM to the computer network is that MODEM modulates the digital codes of the computer into analog signal, which then can travel through the telephone cable. At the receiving end the MODEM kept there will demodulate the analog signal to digital codes, which can be then understood and used by the receiving computer. In this way a MODEM makes the computer network possible.

e)      Write any two ways of protecting computer hardware.

Ans: Two ways of protecting computer hardware are:

v  use power protection device to protect computer from power fluctuation.

v  use grille in the windows and use lock in the door to protect from thieves.

Convert as instructed):

(i)               (364)8 into decimal

(ii) (1101010)2 into octal.

Perform the binary calculation):

(i) 1011 x 101

(ii) 100101 ÷ 101

 

Match the following):

Group 'A'                                Group 'B'

(a) Network services                  (i) Power protection device

(b) Infrared                               (ii) E-Banking

(c) Internet services                   (iii) Transmission media

(d) Volt Guard                          (iv) File sharing

(v) Media

Answers:

Group A                                   Group B

a. Network services                   iv) File sharing

b. Infrared                                 iii) Transmission Media

c. Internet Services                    ii) E-Banking

d. Volt Guard                            i) Power protection devices

Choose the correct answer.

a) Which is not a protocol?

(i) FTP             (ii) POP            (iii) HTTP         (iv) TIP

b) www is a ........

(i) Web browser            (ii) Protocol      (iii) Internet service     (iv) None of the above

c) NIC is a .......

(i) Software       (ii) Hardware   (iii) HUB          (iv) Network operating system

d) In ......... Network Topology, nodes are connected in a single wire.

(i) STAR          (ii) BUS            (iii) MESH        (iv) All of the above.

Write the appropriate technical terms of the following:

a)      An electronic device that supplies electric current when the electricity is cut off. UPS

b)     A software which enables to view HTML pages in the Internet. Web Browser

c)      A device that can connect networks which may use different communication protocols. Gateway

d)     A set of rules that governs the communication among the computers in a network. Protocol

Write the full form:

(i)               UPS – Uninterruptible Power Supply

(ii)             FTP – File Transfer Protocol

(iii)           WWW – World Wide Web

(iv)             NOS- Network Operating System

Group 'B'

Database (10 Marks)

Answer the following questions:

a)      What is a database?

Ans: A database is an organized collection of related information that can be used for different purpose so that it can easily be accessed, managed, and updated.

b)     What is a data sorting?

Ans: Sorting is the process of arranging the record in ascending or descending order according to a given field or fields. Sorted data is easier to handle than unsorted data.

c)      What is a form?

Ans: A form is the database object used to interact with a database. It is the primary object that is used for customize data entry into the table.

State whether the following statements are true or false:

a)      Report is a database object used to print final report. True

b)     Money is a datatype used in Ms-Access. False

c)      Arranging all the records in a table either ascending or descending order is known as filtering. False

d)     Maximum data size of an auto number is 4 bytes. True

Match the following:

Group 'A'                                Group 'B'

(a) Ms-Access                           (i) data entry and editing interface

(b) Query                                  (ii) electronic spreadsheet software

(c) Record                                 (iii) tool to retrieve data from one or more tables.

(d) Form                                   (iv) database management software.

(v) collection of related fields.

Answers:

a) MS-ACCESS                        iv) Database management software.

b) Query                                   iii) Tool to retrieve data from one or more than one tables.

c) Record                                  ii) Collection of related fields.

d) Form                                    i) Data entry and editing interface

Group 'C'

Programming (18 Marks)

a)      Write any two advantages of Modular Programming.

Ans: The advantages of modular programming are:
i) Different programmers can design different program modules independently, which is required in a large and complex program.
ii) It is easy to design code and test the program modules independently.

b)     Write any two features of C language.

Ans: The two features of C language are:

- Simple and easy to use

- Occupies less Memory

c)      Write the functions of following statement /command.

(i) CLOSE : It closes one or all open files.

(ii) KILL: The KILL statement deletes the file or files from the specified drive and directory.

Re-write the given program after correcting the bugs:

DECLARE SUB Series ( )

CLS

EXECUTE Series

END

SUB Series

REM Program to print 4 4 8 12 20 ....... 20th terms

X = 4

Y = 4

FOR ctr = 10 To 1

DISPLAY X; Y;

X = X+Y

Y = X+ Y

Next ctr

End Series

Debugged Program:

DECLARE SUB Series ( )

CLS

CALL Series

END

SUB Series ( )

REM program to generate 4 4 8 12 20 …20th term

X=4

Y=4

For ctr = 10 TO 1 STEP -1

PRINT C ; Y;

X = X + Y

X = X + Y

NEXT ctr

END SUB

Write the output of the given program:

DECLARE SUB CHECK (N)

CLS

N = 1436

CALL CHECK (N)

END

SUB CHECK (N)

DO WHILE n< >0

R = N MOD 10

S = S*10+R

N = N\10

LOOP

PRINT "NOW N BECOMES"; S

END SUB

Output:

NOW N BECOMES 6341

Study the following program and answer the given questions:

DECLARE FUNCTION SUM (A, B)

INPUT A

INPUT B

X = SUM (A, B)

PRINT X

END

FUNCTION SUM (A, B)

S = A+B

SUM = S

END FUNCTION.

a)      Write the name of local variable used in the above FUNCTION procedure.

Local Variable: S

b)     Write the Mathematical operator and Relation operator used in above program.

Mathematical Operator : +

Relational Operator : =

a) Write a program using FUNCTION .... END FUNCTION to get temperature in Celsius from the user and then print the temperature in Fahrenheit. [Hint: F = 9 x c/5+32)]

DECLARE FUNCTION C2F(C)

CLS

INPUT "Enter temperature in Celsius", C

PRINT "The temperature in Fahrenheit=", C2F(c)

END

FUNCTION C2F(c)

F = 9 * C/5 + 32

C2F = F

END FUNCTION

b) Write a program to print only vowel letters from given string using SUB procedure.

DECLARE SUB Vowels (N$)

INPUT "Any String"; N$

CALL Vowels (N$)

END

SUB Vowels (N$)

A$ = UCASE$ (N$)

L = LEN (A$)

FOR X = 1 To L

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

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

V$ = V$ + B$

END IF

NEXT X

PRINT "Vowels"; V$

END SUB

c) A sequential data file called 'ADDRESS.DAT' contains NAME, AGE, CITY and TELEPHONE fields. Write a program to display all the contents of that data file.

OPEN "ADDRESS.DAT" FOR INPUT AS #1

REM **** Program to display contents of the data file called ADDRESS.DAT

PRINT "Name", "Age", "City", "Telephone"

WHILE NOT EOF(1)

INPUT #1, Name$, Age, City, Telephone

PRINT Name$, Age, City, Telephone

WEND

CLOSE #1

END

Source: Answer Key of SOCE Website