SEE Model Set 6 Solution

MODEL QUESTION SET 6

1.      Answer the following questions:

a)      What is a server? List the basic components of a computer network.

Ans: Server is a powerful computer of computer network. It is used to control all the computers of a computer network. The basic components of  a computer network are

1. computer 2. Connecting devices 2. Communication media 3. Network hardware and software

b)      What is FTP? What is it applied for?

Ans: FTP means File Transfer Protocol which is a software/ set of rules for data transmission along a computer networkdo you introduce a multimedia computer system? List its major components.

Ans: Multimedia system is the combination of multimedia hardware and software in order to produce multimedia contents. The major components of of multimedia system are as folllows

1. Multimedia hardware (like sound card, michrophone etc)

2. Multimedia software( powerpoint, power dvd, windows movie maker etc)

3. Multimedia objects (text, audio, video, graphics etc)

4. user

c)      What do you mean by defragentation? How is it different from sannddisk?

The process to arrange the scattered files and folders of the hard disk is called defragementation, It is different from the scandisk because it is used to arrange the scattered files and folders in their proper location and makes the space free for other programs but scandisk is used to scan the disk from any other illegal activities.

d)      List any four characteristics of computer virus?

Ans: The program which replicate itself and destruct the normal function of the computer is called virus. Four characteristics of virus are

1. Replicate itself

2. Damage normal function of the compuer.

3. Delete the files and filders without knowledge of the user.

4. Make the compuer slow.

2.      a) Perform the binary operation as indicated:

i)                    101010÷101          ii) 100010-10101

b) Convert the value as indicated:

i) (A2F)₁₆=(?)₂                    ii) (247)₈-(?)₁₆

3.      Fill in the blanks:

a)      STP-Shielded Twisted Pair                 

b) ARPANET- American Research Project Agency Network

c) PDF- Portable Document Format  

d) ISDN - Integrated Subscribe Digital Network

4.      Fill in the blanks:

a)      Bandwidth  is the range of frequency which is avaliable for transmission of data through a transmission medium?

b)      The technology which describes the intergration of information existing in different forms such as audio, video, text, graph, image to make the product product very attractive and interactive is known as Multimedia

c)      FTP A protocol that enables an internet user to log on to and enter commands on a remote computer linked to the internet.

d)      The missuse of computer by people either for pleasure or for making profit is termed as Computer Crime.

5.      Give the approplate technical terms of the following:

a)      One of the genuine services of the internet which has made people to buy and sell their goods in reliable way. Ecommerce

b)      A utility which helps people to sefeguard their valuable data information placing them in a safe storage media as a copy. Backup

c)      The pattern of network formed by the connection of devices on a LAN. Topology

d)      A network device which amlifies the weak electronic signal while transmitting through a communication media in network so that the target nodes/machine can read it easily. Repeater

6.      Choose the correct answer:

a)      A utility that scans a computer's memory and mass storage to identify, isolate and eliminate threats and viruses.

i)                    Scandisk                      ii) defragment            

ii)                  antivirus                     iv) disk cleanup

b)      A computer on a network that actually participation in comunication job under the control and management I the main computer.

i)                    Topology                     ii) non dedicated server

ii)                  worksation                  iv) server

c)      The theoretical concept behind the design of network among computers with the specific method of data transmission to perform.

i)                    toplogy                        ii) Protocol

ii)                  Network architecture                        iv) wireless network

d)      A program originally developed to allow users to view documents on the WWW.

i)                    telnet                           ii) website

ii)                  web browser              iv) web page

7.      Answer the following qeustion:

a)      What is a database? Mention  any four different types of data supported by the database of MS-ACCESS.

Ans:  Database is the collection of logically related data.Text, Memo, Number, Autonumber are the four datatypes supported by MSACCESS.

b)      What is query? Mention different types of action queries.

Ans: The object of MS Access which is used to retrieve the record or records from the table or tables according the condition is called query. It's types are

1. Select Query

2. Action Query

c)      Show any two differences between the objects FORM and REPORT of MS-ACCESS databse.

Form is the object of database used to edit, add, the records of the table but report is used to get the output of the table in printed form.

Form display the records in monitor as a softcopy format but report is used to get the records in hard copy format.

8.      Choose the correct annswer:

a)      To duplicate some records from a table into another table with or without the specifications of criteria, we perform the query

                                i.            update

                              ii.            append

                             iii.            Make table

                             iv.            Delete

b)      Which is not a RDBMS?

                                i.            MS-EXCEL

                               ii.            MS-ACCESS

                             iii.            ORACLE

                             iv.            DELPHI

c)      A field property that specifies what type of data with specific number and types of characters to input as data in a specific field

                                i.            format

                               ii.            validation rule

                             iii.            input mask

                             iv.            index

d)      To store a document file prepared by using another application as a data in a table, we need to define the specific field type as

                                i.            memo

                               ii.            hyperlink

                            iii.            OLE object

                             iv.            Text

9.      Match the following:

Group A                             Group B

                    i.            Information           (iii) an object of MS-ACCESS database

                   ii.            input mask            (iv) a field type of MS-ACCESS table

                 iii.            form                      (i) processed data

                 iv.            Boolean                 (ii) a field property that enhances data

integrity

                                e.  data collected from field visits

10.  Answer the following questions:

a.      What is a parameter? How is it different from an argument?

Parameter is the variable which is define in the sub procedure to store the value from the main module. It is different from the argument because argument is declared in main module but parameter is define in sub module.

b.      What type of language is C?

C is a high level structured programming language which is used to create the system and application software.

c.       Show the difference between PRINT # and PRINT statement.

Print is used to print the message of value of a variable but print # is used to print the record from a data file.

11.  Debug the given program.

REM to count total number of word existing in a sentence input by a user.

DECLERE FUNCTION wordcount (w$)

CLS

LINE INPUT "Enter a sentence;" N

END

FUNCTION wordcount (w$)

FOR C= LEN (w$) TO 1

      CH$ = ""THEN CNT=CNT+1

NEXT

CNT=wordcount

END FUNCTION

Solution:

REM to count total number of word existing in a sentence input by a user.

DECLERE FUNCTION wordcount (w$)

CLS

INPUT "Enter a sentence;" w$

END

FUNCTION wordcount (w$)

FOR C= LEN (w$) TO 1 step -1

      CH$ = ""THEN CNT=CNT+1

NEXT

wordcount=CNT

END FUNCTION

 

12.  Find the output of the following program showing the necessary rough:

DECLARE FUNCTION NUMPRO (A as integer, B as integer)

DIM N, M, S as integer

CLS

DATA 2, 5

READ M% N%

S=numpro (N%, M%)

Print "Sum of all the values is", S

END

FUNCTION NUMPRO (A as integer, B as integer

s=0

For c=1 to A%

      s=s+c*B%

      Next C

NUMPRO= s

END FUNCTION

Output of the program

 

13.  Give the answer of the following program with reference to the program given below:

DECLARE SUB SUM (A,B,S)

DECLARE FUNCTION ADD (x,y)

CLS

m=5, n=10

A=ADD (10,20)

B=ADD(m,n)

CALL SUM (A,B, S)

PRINT "SUM=";S

END

SUB SUM (A,B,S)

      S=A+B

END SUB

FUNCTION ADD (x,y)

      ADD= x+y

END FUNCTION

a)      What will be the output of the given program?

The output is SUM=30

b)      List all the parameters used in the above program?

A,B,x,y

14.  Write the following programs:

a)      To solve a quadratic equation ax2+bx+c=0 on the basis of the coefficient values a, b and c given by a user through a BASIC SUB named quadeqn().

DECLARE SUB quadeqn(A,B,C)

CLS

INPUT A,B,C

CALL quadeqn(A,B,C)

END

SUB quadeqn(A,B,C)

S=(B^2-4*A*C)^0.5

X1=(-B+S)/2*A

X2=(-B-S)/2*A)

PRINT X1,X2

END SUB

 

b)      To read two words nepathua and Gopal through main module, passing them to a user- defined function named titlecase (). The Funcation should concatenate (Ink) first three characters of the first word with the last two characters of second word and return it to the main module converting the concatenated word into Title Case. The output should be displaued through the main module.

[Hint: Titlecase: Honesty is the best policy]

c)      Score.dat is a sequentail data file which contains marks scored by students in a test. Write a program to count and display all the students who could pass in all the subjects along with the calculation of their total marks. Assume field structure of data stored in the file is REGNO (Registration number), ENGLISH, NEP, SCIENCE, COMPULSORY MATHEMATICS.

[Hint: Pass mark in each subject is 32]

OPEN "SCORE.DAT" FOR INPUT AS #1

WHILE NOT EOF(1)

INPUT #1, RNO,E,N,S,CM

IF N>32 AND E>32 AND S>32 AND CM>32 THEN

PRINT RNO,E,N,S,CM

ENDIF

WEND

CLOSE #1

END