By Ramesh Mahato
AMS
Group “A”
COMPUTER FUNDAMENTAL (22
Marks)
1.
Answer
the following questions.
a)
What
is Tree topology?
Ans: If all the component or computer
in a networks connected with central located device Hub is called Tree
topology. All the data in this topology passing through Center located Device.
b)
What
is Search engine? List its 4 examples
Ans: Search engine is a special type of
website which help us to find any content in world wide web.
Example: Google, ask, Yahoo, Being
c)
List
any four strategies of IT policy?
Ans: Strategies of IT policy are as
follow:
i)
The
mechanism will be created to increase employment on IT industry.
ii)
The
national information technology index will be constantly monitored.
iii)
Wireless
technology will be adapted for the development of rural areas and encourage to
operate such sites.
iv)
E-Government
master plan will be effectively implemented.
d)
What
is multimedia technology?
Ans: Combination of two or more media
is called multimedia. To be a perfect multimedia there must be combination of
Audio, video, text, animation and graphics.
e)
List
any four common software security methods.
Ans: Software security methods are as
follows:
i)
Password
protection
ii)
Antivirus
software
iii)
Defragmentation
iv)
Backup
system
a.
(10101111)2
= (?)16
Ans: (10101111)2 = (AF)16
B)
Perform the binary operation.
a.
1011+1011-101
Ans: (10001)2
b.
(1111+1111)/100
Ans: (111)2 and Remender
(10)2
3.
Give
technical terms of the following:
a.
Number
of bits that can be transferred per second over a given transmission medium.
Ans: Bandwidth
b.
It
is a simulation of movement created by computer technology to displaying a
series of pictures or frames.
Ans: Animation
c.
The
police, procedures, tool and techniques designed to protect computer assets.
Ans: Cyber security
d.
The
process of rewriting part of file to contiguous sector on a hard disk to
increase.
Ans: Defragmentation
4.
Match
the following Pairs:
i.
Server
a. HTTP
ii.
Node
b. Work station
iii.
Protocol
c. Main computer on the
network
iv.
Coaxial
cable d. Repeater
e.Communication media
Ans:
i. Server c. Main computer on te network
ii.Node b. Work station
iii.Protocol a. HTTP
iv.Coaxial cable e. Communication media
5.
Select
the best alternatives:
a.
Which
refers to the communication media?
a)
UTP
cable c) Fiber
optics cables
b)
Satellite
d) All of
these
Ans:
d) All of these
b.
…..
is the leading information exchange of the internet.
a)
E-mail
c) Search engine
b)
Newsgroup
d) None of the
above.
Ans:
Newsgroup
c.
The
main component of multimedia is ……
a)
Floppy
disk c)
Floppy drive
b)
Sound
card d)
magnetic tape
Ans:
Sound card
d.
Name
the connector used in twisted pair cable.
a)
ST
c)
RJ45
b)
BMC
d)
None of them
Ans:
RJ45
6.
Write
the full form of the following:
i)
MSAV iii)
EOF
ii)
DVD
iv)
CAN
Ans:
i) MSAV= Microsoft Antivirus ii)EOF= END of File
ii)DVD= Digital Versatile Disk iv) CAN=Computer Association Nepal
Group “B”
DATABASE (10 Marks)
7.
Answer
the following questions.
a)
What
is a database?
Ans: Collection of concerning a certain
topic or business application is Database.
b)
What is form? List two advantages of forms.
Ans: Form is important object of
Database which help to input data into database.
Advantage of form are as follow:
i)
Easy
to data entry
ii)
User
friendly
c)
What
is a primary key?
Ans: Primaty key is special key or
field which uniquely identify the table value or row. Which don't allow to
entry duplicate data.
8.
Choose
the correct answer;
a)
The
caption can be declared up to ……….
a.
2048
character c. 2063
characters
b.
64,000
character d. 2005
characters
Ans:
2048 character
b)
A
restriction applied on the data can be entered is collect a ……
a.
Format
c.
Validation text
b.
Field
property d.
None of these rule
Ans:
c. Validation rules
c)
A database
is the collection of ……..
a.
Tables
c.
Names
b.
Software
d.
2005
Ans:
………………
d)
…..
helps to arrange records faster in order.
a.
Indexing c.
Names
b.
Filtering d.
Query
Ans:
b.Filtering
a.
Primary
key i. Picture
b.
OLE
ii.
Data type
c.
Memo
iii.
Easy to search
d.
Sort
iv. Unique
identification of record
v. Query
Ans:
a.
Primary
key i. Unique identification of
record
b.
OLE
ii. Picture
c.
Memo
iii. Data type
d.
Sort
iv. Easy to search
10.
A.
What do you meant by parameter? 1
Ans: In the procedural
programming parameter are those variables or any valid identifier which
receives the value is sent for processing when a procedure is called from
calling module.
B.
Mention two characteristics of ‘C’
language. 1
Ans:
Characteristics of 'C' Programming language are as follows:
i.This
language has both feature of High and Low level language.
ii.
It has only 33 keywords.
11. Write down the functions of the
following:
i.
SHELL
ii.
SUB ….. END SUB
Ans:
i.SHELL - The SHELL statement allows a program to run
external programs or command line statements in Windows, macOS and Linux.
ii.Sub………
End sub- This function is use to write modular programming using sub procedure.
12. Write the output of the given program. 2
DECLARE
SUB patt()
CALL
patt
END
SUB
patt
FOR i = 5 TO 1 STEP -1
FOR j = 1 TO i
PRINT i;
NEXT
PRINT
NEXT
END
SUB
Ans:
55555
4444
333
22
1
13. Debug the following program: 2
DECLARE
SUB series()
CALL
series
END
SUB
series
B = 1
while
B cube 2
B=
B+2
NEXT
END
SUB
FINISH
Ans:
Declare
sub series()
Call
series()
End
Sub
series()
B=1
While B= 2^3
B=B+2
Print
b
Wend
End
sub
14. Read the following program and answer
the following questions: 2
DECLARE
FUNCTION sum;(n)
INPUT
"Enter a number"; n
PRINT
"Sum="; SUM(n)
END
FUNCTION
SUM (n)
DO
r = n MOD 10
s = s + r
n = INT(n + 10)
LOOP WHILE n <> 0
SUM = s
END
FUNCTION
a.
What
will be the output of the program first value of r if the user print 125?
Ans: 5
b.
What
is the function of INT in the above program?
Ans: Function of INT is convert value
of n into integer data type.
15.
a)
A data file ‘info.dat” has numerous
records in it with name, address and telephone number in each.WAP to Scan all
the records from that file and display only the records with address
“Kathmandu”. 3
Ans:
Open
"info.dat" for input as #1
Do
Input#1,n$,a#,t
If
a$="Kathmandu"
Loop
while not EOF()
Close
#1
end
b) WAP using FUNCTION ….
END FUNCTION to erase the vowels from an input string. 3
DECLARE FUNCTION DISPC
(S$)
CLS
INPUT “ENTER ANY STRING”;
S$
CC = DISPC(S$)
END
FUNCTION DISPC(S$)
FOR I = 1 TO LEN(S$)
B$ = MID$(S$, I, 1)
C$ = UCASE$(B$)
IF C$ <> “A” AND C$
<> “E” AND C$ <> “I” AND C$ <> “O”
AND C$ <> “U” THEN
PRINT B$
END IF
END FUNCTION
d)
WAP
to declare SUB procedure to print only the vowels from a given word.
DECLARE SUB VOWELS()
CLS
INPUT"ENTER ANY WORDS";W$
CALL VOWELS()
END
SUB VOWELS()
FOR I=1 TO LEN(W$)
B$=MID$(W$,I,1)
C$=UCASE$(B$)
IF C$="A" OR C$="E"
OR C$="I" OR C$="O" OR C$="U" THEN
PRINT B$
END IF
NEXT I
END SUB
*****
No comments:
Post a Comment