by 
(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)
No comments:
Post a Comment