SEE MODEL QUESTION-1 2074

 (Group 'A') Computer Fundamental (22 marks)

1. Answer the following questions: (5x2=10)

a. What is Transmission Media? List any two differences between Star and Bus topology. 

b. What is Internet ? List the services provided by the Internet. 

c. What is multimedia technology? List any four application areas of multimedia. 

d. Define Software Piracy. List out any four measures to protect computer software. 

e. Define boot sector virus. How can we protect computer from computer virus?

2. a. Convert as instructed: (2x1=2) 

(i) (305)8   into decimal 

(ii) (CAB)16 into binary

b. Perform binary operation.          ( 2x1=2)

(i) 101*11+101  

(ii) Divide 101101 by 101

3. Match the following pairs: (4x0.5=2) 

Group A	Group B
Microwave	Network Protocol
UPS	Unguided transmission media
AppleTalk	Power protection device
Cyber ethics	Android OS
	Code of conduct for computer users

4. Select the correct answer: (4x0.5=2)

a. Which is not the network hardware component? 

(i) Switch (ii) Repeater (iii) Router (iv) Windows NT  

b. In which communication media does data travel in the form of light signal?

(i) Telephone wire (ii) Fiber optic (iii) Coaxial Cable (iv)Twisted pair cable  

c. Which is not the protocol?  

(i) POP (ii) IPX/SPX (iii) NETBIOS/NETBUI (iv) Client/Server

d. Which is the Anti-virus program?  

(i) DNS (ii) NAV (iii) Windows 10 (iv) MS-Excel

5. Give appropriate technical terms of the following: (4x0.5=2)

a. The process of  buying and selling products and services online 

b. The cabling structure of  LAN

c. Group of computers that can share resource. 

d. One way communication mode. 

6. Write full forms: (4x0.5=2)

a) UPS (b) VOIP  (c) WLAN  (d) VRML  

(Group  'B') Database (10 marks)

7. Answer the following questions. (3x2=6) 

a. What is a database and DBMS?  

b. What is data type? List any four types of data used in Microsoft Access? 

c. Define Query. List any two uses of form.

8. Select the correct answer: (4x0.5=2)

(a) The maximum text field size in Access is ……….

(i) 50  (ii) 10   (iii) 256  (iv) 255 

(b) The extension of database file in Access is …….. 

(i) .DBF (ii) .MDB (iii) .DMB (iv) .DBM 

(c) …...... uniquely identifies any field. 

(i) Indexing  (ii) Memo Field (iii) Primary Key (iv) Query

(d) The objects of Access that stores the data is known as ……… 

(i) Query   (ii) Table (iii) Form  (iv) Report

9. Match the following pairs: (4x0.5=2) 

Group A	Group B
MySql	iOS
Indexing data	To store picture and video
OLE Object	RDBMS
Caption	Searching fast
	2048 characters

(Group 'C') programming (18 marks)

10. a. What is a local and global variable?      1

b. Define C Language.List any two data types used in C language.    1

c. Write down the function of the following statements: 1

(i)NAME  (ii) EOF()  

11.Write the output of the given program:  2

DECLARE SUB Series ( ) 

CALL Series 

END

SUB Series ( ) 

N=2

C=1 

WHILE C<=10 

       PRINT N 

       N=N+C 

       C=C+1 

WEND

END SUB

12.Re-write the given program after correcting the bugs: 2 

REM To display all the records from emp.dat file

OPEN "emp.dat" FOR APPEND AS#1

WHILE NOT FOE()

INPUT"Enter name ";N

INPUT"Enter Address";A 

WRITE 1,N$,A

PRINT N$,A$

LOOP

CLOSE #1

END

13. Study the following program and answer the given questions:      (2x1=2)   

DECLARE FUNCTION   Result(X,Y) 

CLS

X=10

Y=15

Z=Result(X,Y) 

PRINT Z

END

FUNCTION Result(X,Y)

FOR i= 1 TO Y

       IF X MOD i=0 AND Y MOD i=0 THEN H=i

NEXT i

Result=H

END FUNCTION 

(a) How many arguments and parameters are used in the above program? 

(b) What is the output of  the above program?

14. a. Write a program to calculate and display area of a triangle using FUNCTION..END FUNCTION. (Hints: Area =1/2*base*height)         (3)

b. Write a program to check whether the given word is ‘palindrome or not’ using SUB….END SUB.           (3)

c. Write a program to create a sequential data file "marks.dat" to store Name and Mark obtained in Computer, Math and Science subjects for some student.         (3)