SEE (Supplementary/Upgrade) 2074 (2018) [Solved]

 

SEE (Supplementary/Upgrade) 2074 (2018) [Solved]

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

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

 

 Match the following

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