SEE Model Set 9 Solution

MODEL  QUESTION SET  9

1.      Answer the following question:

a.      How do we know that our computer is infected by virus?

Ans: These are the following symptoms to know about computer virus inffection

1. Computer will be hang.

2. The size of the files and folders are changed.

3. The computer will show you unneccessary errors/ messages.

4. Computer's files will be deleted automatically.

b.      What are symptoms of virus?

Ans: These are the following symptoms to know about computer virus inffection

1. Computer will be hang.

2.. The size of the files and folders are changed.

3. The computer will show you unneccessary errors/ messages.

4. Computer's files will be deleted automatically.

 

c.       What is a backup? Why backup plays a vital role in the computer security system?

Creating duplicate of files, data, software for the future use is called backup. It is vital because it will give you the duplicate copy of the original one if your computer hardware or software will be damage.

d.      Explain the importance of internet in education.

Ans: The internet is very important in education because student can learn the any topic and teachers can easily teach them and give them variety of the answers related any perticular topic or question. CAD, CAL are the tools by which education can be delivered easily among the students of any country via internet.

e.      Mention any five points of computer Ethics.

1. Do not use computer to harm anyone.

2. Do not steal the information of any computer.

3. Do not hack any password of any computer.

4. Do not use the computer for any illegal work.

2.      a. Convert as instructed:

                                                              i.      (670)₈ into decimal

                                                             ii.      (BEE) ₁₆ into octal

b.      Perform binary calculation:

                                                              i.      11101*10+101            ii. Multiply 1001 to 111 and 10

3.      Match the following:

 Group A                                  Group B

a.      VOIP                            b. Protocol

b.      TCP/IP                         a. internet service

c.       Encrypt                        d. Type of virus

d.      Macro virus                 c. Changed format of original matter

v. Transferring & receiving message on the online

4.      Selected the correct answer:

a.      Which device is used to connect networks using the same communication protocol?

                                                              i.      Hub      ii. NIC card       iii. Gateway     iv. Routers

b.      Which is online business through internet?

                                                              i.      E-commerce                ii. E-shopping

iii.        Both (i) & (ii)               iv. None of above

c.       Computer virus can destroy ………………………….

                                                              i.      Hardware                    ii. E-shopping

iii.        Hardware and software IV. none

d.      Which is not objective of IT policy, 2000 A.D.?

                                                              i.      Knowledge based society.

                                                            ii.      Increase number of computer hacker.

                                                           iii.      Create employment.

                                                           iv.      Knowledge based industry

5.      Give the technical terms of the following:

a.      A type of virus which infects the document of word processing or spreadsheet package. file virus

b.      A device that connects networks using the same communication protocols. Router

c.       Meeting between two or more people located at different location in the world. Email

d.      A secret code that gives the user to access particular program and system. Password

6.      Write the full forms of the following:

a. JPG-Joint Pictures Expert Group

b. BBS-Bulletin Board System                        

c. INTERNET- Interconnected Network         

d. VHF- Very High Frequency

7.      Answer the following questions:

a.      Show the difference between sorting and filtering.

Ans: Sorting is the process to arrange the data and information in ascending or descending order. Filtering is the method to search the record faster.

b.      What is MS Access? For what purpose the field property, i.e.capition is used?

Ans: MS Access is the DBMS and used to create, manage the database electronically. Caption is used to give the alternative name for any field.

c.       Mention any four features of DBMS.

1. Manage the records.

2. Creating reports.

3. Avoid the duplication  of data.

4. Makes easy to search and find the records.

8.      State whether the statement is true/false:

a.      The extension of database file of MS Access is ADB. F

b.      Data type is used for declaring different types of data in MS Access.T

c.       Table is the name of any object. F

9.      Match the following:

                                                              i.      Hyperlink                     ii. Name of object

                                                             ii.      Entity                           iii. Upto 255 characters

                                                           iii.      Text                             i. Data type

                                                           iv.      Report                         IV. Query

iv. Object of Access

10.  Answer the following questions:

a.      What is structured programming?

Ans: Sturctured programming is the method to divide  the program into small modules and help to create the large programe.

b.      What is operator in c Language?

Ans: The operator is used to perform the arithmetic and logical calculation in C programming language eg. AND, +,- etc

c.       Write the function of following statement:

                                                              i.      INPUT                          ii. LINE INPUT

Ans: INPUT mode is used to extract the data from data file whereas LINE INPUT is used to extract the single record from the data file.

11.  Write the output of the given program:

DECLARE SUB OUTPUT (A$)

X$= “book”

CALL OUTPUT (X$)

END

                 SUB OUTPUT (A$)

 

                        L= LEN (A$)

                        FOR I = 1 TOL

                        PRINT LEFT $ (A$,I)

                        NEXT I

                        END SUB

Ans: The output is

b

bo

boo

book

12.  Rewrite the given program after correcting the bugs:

OPEN “RECORD.DAT” FORINPUT AS # 1

CLS

WHILE NOT EOF (1)

INPUT #1, N$, A$,D$,E$, T#

B$=LEEFT$(D$,2)

C= VAL (B$)

E$=LEFT$(DATE$,2)

F=VALE(E$)

IF C= F THEN PRINT NAME$, A$, D$, E$, T#

WIND

CLOSE #1

END

Ans: The correct program is

OPEN “RECORD.DAT” FOR INPUT AS # 1

CLS

WHILE NOT EOF (1)

INPUT #1, N$, A$,D$,E$, T#

B$=LEEFT$(D$,2)

C= VAL (B$)

E$=LEFT$(DATE$,2)

F=VAL (E$)

IF C= F THEN PRINT NAME$, A$, D$, E$, T#

WEND

CLOSE #1

END

 

13.  Study the following programs and answer the given question:

DECLARE FUNCTION REV$ (ST$)

CLS

INPUT “Enter a string inverse is: “;S$

Let R$ = REV (S$)

PRINT “The string inverse is :”;R$

END

FUNCTION REV$ (ST$)

RV$ = FUNCTION RV$ (ST$)

FOR I = LEN (ST$) TO 1 STEP -1

RV$ = RV$ +MID$ (ST$, I, 1)

NEXT I

REV$ = RV$

END FUNCTION

a.      Write the function of MID$.

Ans: The function is to extract the character from any string from any position.

b.      List the name of actual and formal parameter used in the program.

Ans: actual parameter  S$, formal parameter ST$

14.  a. write a program to display prime from 1 to 200 number by using FUNCTION ……………. END FUNCTION.

DECLARE FUNCTION PRIME(I,J)

CLS

FOR I=1 TO 200

C=0

FOR J=1 TO I

X=PRIME(I,J)

NEXT J

IF C=2 THEN PRINT I

NEXT I

END

FUNCTION PRIME(I,J)

IF I MOD J=0 THEN C=C+1

PRIME=C

END FUNCTION

b.      Write a program to print following series using SUB ….. END SUB,1,1,2,3,5,8,13,up to 10^th terms.

CLS

DECLARE SUB SER

CALL SER

END

SUB SER

A=1

B=1

FOR I=1 TO 5

PRINT A;B;

A=A+B

B=A+B

NEXT I

END SUB

 

c.       “XYZ” school administrator has the following data, i.e. staff name, department name and salary in a data file named “salary. Dat”. Write a program to display all the data of school staff that belongs to administration department and getting salary more than 15000.

OPEN "SALARY.DAT" FOR INPUT AS #1

WHILE NOT EOF(1)

INPUT #1, N$,D$,S

IF S>150000 THEN PRINT N$,D$,S

WEND

CLOSE #1

END