SEE Model Set 2 Solution

MODEL QUESTION SET 2

1.      Answer the following question:

a.      What is band-width?

Ans: The bandwidth is the rate of data transmisstion in a computer network. The unit of bandwidth is bps(bits per second) in digital and cps(cycle per second) or hertz in analog data transmission.

b.      What is network topology?

The physical layout or the arrangement of computers in a computer network is called network topology.

c.       How can multimedia help in education?

Multimedia can help in education in following way

1. It helps in teaching learning because it uses CAL (computer Aided Learning) technology where the students can learn in audio and video mode.

2. The online education where student can learn by using video conferencing and remote computing.

d.      What is Antivirus software? List any two antivirus softwares.

Ans: The software or collection of programs that is use to detect the virus and eliminate them from the computer is called antivirus softwares. The two examples of antivirus softwares are kespersky, NOD 32.

e.      What do you mean by software security? Write any two methods to protect the computer software.

Ans: The protection of software from being damage, currupt is called software security. The two methods to protect the computer software are Scandisk and use of Antivirus.

 

3. Write the technical terms of the following:

f.        Marking extra copies of data or program. Backup

g.      A card used to connect network cable to computer.NIC

h.      Device used for power protection.Power protection device(UPS)

i.        program used to detect and eliminate computer virus.(Antivirus)

2.      Write the full forms:

a.      WWW-World Wide Web

b.      UPS-Unintruptible Power Supply             

c.       NOS-Network Operating System             

d.       UTP-Unshilded Twisted Pair

3.      Answer the following questions in short:

a.      Define Database  

Database is the organised collection of logically related data.

b.      Write any four data type used in MS-Access.

The four data types are text, memo, date/time, autonumber

c.       What is query?

The query is the object of database to extract the records from a table/tables according to a specific criteria or condition.

4.      State whether the following statements are 'True' or 'False':

a.      Primary key does not accept null value. (T)

 

b.      Memo data type can not be indexed.(T)

c.       The default size of text data type is 50.(T)

5.      Match the following:

 Group A                                 Group B

a.      OLE                                    (d.)Formatted output

b.      Memo                                (c )Interface

c.       From                                  (b) 64,000 characters

d.      Report                               (a) Picture

6.      a. What is user defined function?

Ans: The function which is created by user to perform a specific task is called user define function.

b. List any two data types used in C Language.

Ans: The two data types used in C Language are int and float.

a.      Write down the function of following statements.

KILL- This istatement is used to delete an existing program file in qbasic.

FILES- This stattement is used to display the all files in qbasic.

 

 

7.      Write the output of given problem:

DECLARE SUB Result

CALL Result

END

SUB Result

For I= 1 to 9 step 2

Sum=sum+I^2

NEXT I

PRINT Sum

END SUB

Ans: The output of the program is 165

8.      Rewrite the given program after correcting the bugs:

REM to store name, post and salary

OPEN EMP DOC FOR OUT AS#1

INPUT "Enter Name" N

INPUT "Enter Post" p$

INPUT " Enter Salary; S

WRITE #2, N$, P$, S

CLOSE#1

END

Ans: The correct program is

REM to store name, post and salary

OPEN "EMP.DOC" FOR OUTPUT AS#1

INPUT "Enter Name" N$

INPUT "Enter Post" p$

INPUT " Enter Salary; S

WRITE #1, N$, P$, S

CLOSE#1

END

 

 

9.      Study the following program and answer the given questions:

Rem *to count voweis*

DECLARE FUNCTION COUNT (AS)

Input *Enter a word* ; w$

END

FUNCTION Count (A$)

B= LEN (A$)

C$=UCASE$ (A$)

FOR I=1 TO B

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

IF E$="A" OR E$="E" OR E$= "I''

OR E$= "O" OR E$= 'U' THEN

C=C+1

End IF

NEXT I

Count=C

                        END FUCTION

a.      List the string library function used in the above program.

Ans: String library functions are Len(), Ucase$(),Mid$()

b.      Write down the missing statement in the main module to execute the program.

Ans: The missing statement in main module is

Print count(w$) in line number 3

 

10.   

a.      Write a program using function……….. End Function to find the average of any two numbers given by the user.

DECLARE FUNCTION AV(A,B)

CLS

INPUT "ENTER FIRST NUMBER" ;A

INPUT "ENTER SECOND NUMBER";B

PRINT AV(A,B)

END

FUNCTION AV(A,B)

AV=(A+B)/2

END FUNCTION

 

b.      Write a program using SUB….. END SUB to check whether a number given by user is positive of negative.

DECLARE SUB CHECK(A)

CLS

INPUT "ENTER A NUMBER";A

CALL CHECK(A)

END

SUB CHECK(A)

IF SGN(A)=1 THEN

PRINT "NUMBER IS POSITIVE"

ELSE

PRINT "NUMBER IS NEGATIVE"

ENDIF

 

c.       A data file "LIB.TXT" consists of Book's name, Author's name and price of books. Write a program to count and display the total number of records present in the file.

CLS

OPEN "LIB.TXT" FOR INPUT AS $1

WHILE NOT EOF(1)

INPUT #1, B$,A$,P

C=C+1

WEND

PRINT "TOTAL NUMBER OF RECORDS";C

CLOSE#1

END