ABILITY TEST 2074

Class: - X F.M:50

Time: - Time: 1:30 hrs.        Sub: - Computer Science P.M:16


(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) 1011+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) CPU  (c) WLAN  (d) AI  

(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.

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

Query

Printed format

Form

Stores data

Table

Allows view, edit, input data

Report

Extracts selected record of view

 

DBMS

(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 SUB area() 
CALL area

END

SUB area

r= 4

a= 3.141*r^2

PRINT “Area of a circle is”; a

END SUB

(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 using sub procedure to generate following pattern (3)

6

66

666

6666

 66666



b. Write a program to declare a SUB procedure module to calculate and display area of a circle.

c. Write a program to print the perimeter of the circle using SUB procedure. (Hint: Perimeter of circle= 2*pi*r)         (3)

The End