SEE
(Supplementary/Upgrade) 2074 (2018)
(Group 'A')
Computer
Fundamental (22 Marks)
Answer the following questions):
a) What is a communication channel in networking?
Differentiate between guided and unguided communication media.
Ans:
A communication channel or simply
channel refers either to a physical transmission medium such as a wire, or to a
logical connection over a multiplexed medium such as a radio channel in
telecommunications and computer networking.
The differences
between bounded media and unbounded media
|
Guided media
|
Unguided media
|
|
Guided media are the
physical links through which signals are confined to narrow paths.
|
Unguided media are
wireless media that do not use any physical connections between the two
communicating devices.
|
|
It travels in a
contained conductor.
|
It uses a
transmission carrier to send data signals through the air instead of cables.
|
|
e.g.: coaxial cable,
twisted pair cable and fiber optics cable.
|
e.g.: radio waves,
micro waves and infrared waves.
|
b) What is Search Engine? Give any two examples of
search engine.
Ans:
A search engine is a software program or
script available through the Internet that searches documents and files for
keywords and returns the results of any files containing those keywords. Today,
the most popular search engine is Google, Bing, Yahoo.
c) What is a computer security? Explain any two ways
of hardware security.
Ans:
Computer security is a branch of study known as information security as applied
to computers. It is the process of securing computer’s data and information.
The
two ways of hardware security:
Protect from theft and
vandalism.
Regular maintenance of computer hardware.
d) Define computer ethics.
Ans:
Computer ethics is set of moral
principles that regulate the use of computers. Some common issues of computer
ethics include intellectual property rights (such as copyrighted electronic
content), privacy concerns etc.
e) Mention any four symptoms of computer virus.
Ans:
Any four symptoms of computer virus are:
i) Program takes long time to load.
ii) The floppy disk or hard disk is suddenly accessed without a logical reason.
iii) Increased use of disk space and growth in file size.
iv) Corrupting the system’s data.
ii) The floppy disk or hard disk is suddenly accessed without a logical reason.
iii) Increased use of disk space and growth in file size.
iv) Corrupting the system’s data.
Perform the conversion as per the
direction:
(i) (CCA)16 into decimal (ii) (479)10 into octal
Perform the binary calculation):
(i) (1010) x
(111) (ii) (10011) ÷ 10
 |
 |
Group 'A' Group 'B'
(a) BNC (i)
two way communication
(b) URL (ii)
address of web page
(c) Online business (iii)
connector
(d) Duplex (iv)
E-commerce
(v)
Protocol
Answers:
Group A Group
B
i) BNC
- Connector
ii) URL - address of web page
iii) Online Business - E-commerce
iv) Duplex -
Two way communication
Select the best answer for the
following:
In which communication channel data transfer is the
fastest?
(i) Coaxial Cable (ii)
Fiber Optical Cable (iii) Twisted Pair Cable
(iv) Wireless
Which of the following is the main component of
Multimedia system?
(i) Keyboard (ii)
Windows (iii) Sound Card (iv) Printer
Which one of the following is harmed by computer
virus?
(i) Monitor (ii)
Mouse (iii)
Printer (iv)
Hard Disk
In binary number systems 1 and 0 means ........
(i) ON,
OFF (ii) YES, TRUE
(iii) OFF, NO (iv) YES, ON
Write the appropriate technical
terms of the following:
a)
A
main computer in the computer network. Server
b)
The
law that control cybercrime Cyber Law
c)
Combination
of Text, Audio and Video. Multimedia
d)
Learning
through the electronic media. E-Learning
Write the full form:
(i)
ISP – Internet Service Provide
(ii)
NIC – Network Interface Card
(iii)
CD-ROM – Compact Disk Read Only Memory
(iv)
LCD – Liquid Crystal Display
(Group 'B')
Database (10
Marks)
Answer the following questions):
a)
Define
DBMS with example.
Ans:
DBMS is a process of technique to collect, organize and retrieve data is DBMS.
In DBMS, data can be accessed, managed and updated easily. Some of the popular
DBMS software are Ms-Access, My SQL, Oracle.
b)
Name
any four objects of Ms-Access database.
Ans:
Any four objects of Ms-Access database are table, form, query and report
c)
What
is report?
Ans: A
report is the object of MS-Access that lets us design a ready to print document
of our desired database information. It is generated from tables or queries.
Write True or False
a)
Graphics
can also be stored in Ms-Access Database. True
b)
Maximum
field size of text field is 255 characters. True
c)
An
action query makes changes in table. True
d)
Primary
key accepts null value. False
Match the following
Group 'A' Group 'B'
(a) Form (i)
Column on datasheet
(b) Field (ii)
Data type
(c) Currency (iii)
Graphical interface for data entry
(d) Query (iv)
DBMS
(v)
Retrieves data conditionally
Answers
Group A Group B
i)
Form Graphical
Interface for data entry
ii)
Field Column
on datasheet
iii)
Currency Data
type
iv) Query Retrieves
data conditionally
Group 'C'
Programming (18
Marks)
a)
Write
one difference between String function and Numeric function.
Ans: String
function is used with string it returns string value where Numeric function is
used with number it returns numeric value.
b)
Compare
between "C" and "Q-Basic".
C is
case sensitive language where Qbasic is not case sensitive. Both are high level
language.
c)
Write
the function of the given statements or commands.
i)
FILES: This statement is used to display the list of files and directories.
ii) COMMON SHARED:
This statement is used to declared variable global.
Re-write the given program after
correcting the bugs:
Rem To print only class 10 record from
"student.dat"
CLS
OPEN "I",#2, "Student.Dat"
WHILE NOT EOF (#2)
WRITE#2, N$,C,R
IF C=10 THEN
DISPLAY N$,C,R
END IF
NEXT
CLOSE #2
END
Debugged program
Rem To print only class 10
record from “student.dat”
CLS
OPEN “I” , #2 ,
“Student.Dat”
WHILE NOT EOF (2)
INPUT #2, N$,
C, R
IF C=10 THEN
PRINT N$, C,
R
END IF
WEND
CLOSE #2
END
Write the output of the following
program:
DECLARE SUB REMINDER (R)
CLS
FOR I = 1 TO 4
READ X
CALL REMINDER (X)
NEXT I
DATA 56, 28, 8, 48
END
SUB REMINDER (R)
R1 = R MOD 4
R2 = R MOD 3
IF R1 = 0 AND R2<> 0 THEN
PRINT R
END IF
END SUB
Output
56
28
8
Study the following program and
answer the given questions:
DECLARE FUNCTION TEST (X)
X = 100
Z = TEST (X)
PRINT Z
END
FUNCTION TEST (X)
FOR I = 1 TO X
S = S +I
NEXT I
TEST S
END FUNCTION.
a)
How
many parameters are used in the above program?
Ans:
One
b)
How
many times does the statement S=S+I get executed in the above program.
Ans:
100 times
a)
Write
a program using FUNCTION..... END FUNCTION to get a word from the user and then
print the word in reverse order.
DECLARE
FUNCTION REV$ (W$)
CLS
INPUT
“ENTER A WORD”; WO$
PRINT
“The Word You Enter In Reverse Order Is ”; REV$ (WO$)
END
FUNCTION
REV$ (W$)
FOR X
= LEN (W$) TO 1 STEP -1
CH$ =
CH$ + MID$ (W$, X, 1)
NEXT X
REV$ =
CH$
END FUNCTION
b)
Write
a program using SUB... END SUB to find the area of circle.
DECLARE
SUB ARC (AC, P)
CLS
CONST
PI=22/7
INPUT
“Enter the radius”; R
CALL
ARC(R, PI)
END
SUB
ARC (AC, P)
C=P*AC^2
PRINT
“Area of circle is ” ; C
END SUB
c)
A
Sequential data file called "SEE.DAT" has stored data under the field
heading Symbol No., Name, English, Nepali, Maths and Computer. Write a program
to display all the information of those students whose
marks in Computer is more than
80.
OPEN
"SEE.DAT" FOR INPUT AS #1
DO
WHILE NOT EOF (1)
INPUT
#1, SN, NA$, EN, NE, MA, CO
IF CO
> 80 THEN
PRINT
“Symbol No.” ; SN
PRINT
“Name ”; NA$
PRINT
“Marks Obt In English ”; EN
PRINT
“Marks Obt In Nepali ”; NE
PRINT
“Marks Obt In Math ”; MA
PRINT
“Marks Obt In Computer ”; CO
END IF
LOOP
CLOSE
#1
END
Source:
Answer Key SOCE Website
