Solved SEE Supplementary-Upgrade 2075 (2019) - Computer Science
Group A [Fundamentals – 22 Marks]
1. Answer the following questions. [5×2=10]
a) What is network topology? Name any of two
Ans: The arrangement or connection pattern of computers or nodes and other devices of the network is called network topology.
Any two topologies are:Bus Topology
Star Topology
b) Define web browser with examples.
Ans: Web browser is a computer program that access web pages and displays them on the user computer. Examples of web browsers are Mozilla Firefox, Google chrome, internet explorer, opera etc.
c) What is computer ethic?
Ans: Computer ethic refers to follow the rules and regulation of computer technology and not to harm other computer users knowingly or unknowingly.
d) Write the importance of backup in data and software security.
Ans: The importance of backup in data and software security is to recover the important data and programs from accidental and intentional harm. They are stored in different storage devices like hard disk, CDs and pen drives. When the data and software gets lost or damaged the backup system helps to recover the lost or damaged data or software from the backup copy of data and software.
e) Write any two precautions to protect computer from virus.
Ans: Any two precautions to protect computer from virus are
i) Use a good antivirus program to scan floppy disk, CD, etc. before copying.
ii) Do not install pirated software, especially computer games.
ii) Do not install pirated software, especially computer games.
2.a) Perform as indicated: [2×1=2]
i) (546)8 into decimal
Soln:
=5 × 82 + 4 × 81 + 6 × 80
=5 × 64 + 4 × 8 + 6 × 1
=320 + 32 + 6
=358
(546)8 = (358)10
ii) (1011100111)2 into Hexadecimal.
Soln:
Converting binary to hexadecimal
10 1110 0111
0010 = 2
1110 = E
0111 = 7
(1011100111)2 = (2E7)16
b) Perform the following binary operations: [2×1=2]
i) 1011 × 101
1
|
0
|
1
|
1
| |||
×
|
1
|
0
|
1
| |||
1
|
0
|
1
|
1
| |||
0
|
0
|
0
|
0
|
×
| ||
+
|
1
|
0
|
1
|
1
|
×
|
×
|
1
|
1
|
0
|
1
|
1
|
1
|
1011 × 101 = 110111
c) 100101 ¸ 110
110
|
100101
|
110
|
-110
| ||
110
| ||
-110
| ||
001
| ||
-0
| ||
1
|
Q = 110
R = 1
3. Match the following: [4×0.5=2]
a) Microwave Protocol
b) UTP Power protection device
c) UPS Unguided media
d) SMTP Internet
Guided media
Answers:
a) Microwave Unguided media
b) UTP Guided media
c) UPS Power protection device
d) SMTP Protocol
4. Select the correct answer. [4×0.5=2]
a) When was cyber law introduced in Nepal?
i) 2057 ii) 2055 iii) 2061 iv) 2069
Ans: 2061
b) Which is not communication media?
i) NOS ii) Satellite iii) Infrared iv) STP
Ans: NOS
c) Software used in multimedia system.
i) Animator ii) Flash player iii) Power point iv) All of them
Ans: All of them
d) A program that is used to detect and remove virus.
i) C- Brain ii) Worm iii) Trojan Horse iv) Kaspersky
Ans: Kaspersky
5. Give the appropriate technical terms of the following. [4×0.5=2]
a) A type of network architecture in which every computer works as a both client and server.
Ans: Peer to Peer Network
b) Company provides Internet services.
Ans: ISP (Internet Service Provider)
c) The moving images.
Ans: Animation
d) The law that control cyber crimes.
Ans: Cyber Law
6. Write the full form of the following: [4×0.5=2]
a) PDF: Portable Document Format
b) WLAN: Wireless Local Area Network
c) HTTP: Hyper Text Transfer Protocol
d) JPEG: Joint Photographic Experts Group
Group ‘B’ [Database Management System - 10 Marks]
7. Answer the following questions. [3×2=6]
a) Define DBMS with any two examples.
Ans: DBMS is software which is used to manage data, manipulate them and provide the information in an organized way. Any two examples are MS-Access and Oracle.
b) What is query?
Ans: Query is an object of Ms-Access which extracts and arranges information from a table in a manner that is specified.
c) Why is report created?
Ans: Report is created to print documents according to user’s specifications of the summarized information through query or table.
8. State whether the following statements are True or False. [4×0.5=2]
a) Column is also called field. True
b) Primary key field can accept duplicate values. False
c) Text is and object of MS-Access. False
d) Auto Number Data consumed 2 bytes of memory space. Flase
9. Match the following. [4×0.5=2]
a) Caption Logical data type
b) OLE Error message
c) Data Redundancy Picture
d) Yes/No Label for field
Duplication of data
Answers
a) Caption Label for field
b) OLE Picture
c) Data Redundancy Duplication of data
d) Yes/No Logical data type
10 a) What is modular programming? [1]
Modular programming is a technique which divides program into many small, manageable, logical and functional modules or blocks.
b) Write any two characteristics of ‘C’ Language. [1]
Ans: The characteristics are :
i) It is a high level language with some features of low level language.
ii) It is mostly used to prepare system software.
i) It is a high level language with some features of low level language.
ii) It is mostly used to prepare system software.
c) Write the function of the following statements [2×0.5=1]
MKDIR - It creates a subdirectory which is used to manage files. INPUT # – It reads data from the sequential data file.
11. Rewrite the given program after correcting the bugs. [2]
REM program to read data from the data file.
OPEN “STD.DAT” FOR OUTPUT AS #1
CLS
WHILE NOT EOF(#1)
WRITE#1, N$, R, C, P
PRINT N$, R, C, P
WEND
CLOSE “STD.DAT”
END
Debugged Program
REM program to read data from the data file.
OPEN “STD.DAT” FOR INPUT AS #1
CLS
WHILE NOT EOF(1)
INPUT #1, N$, R, C, P
PRINT N$, R, C, P
WEND
CLOSE #1
END
12. Write the output of the following program. [2]
DECLARE FUNCTION SUM ( a )
CLS
a = 9
PRINT SUM ( a )
END
FUNCTION SUM ( a )
FOR K = 1 to a
IF K MOD 2 = 0 THEN
S = S + K
END IF
NEXT K
SUM = S
END FUNCTION
Output:
20
13. Study the following program and answer the given questions. [2×1=2]
DECLARE SUB TEST (N$ )
INPUT N$
CALL TEST ( N$ )
END
SUB TEST (N$ )
FOR P = 1 TO LEN ( N$ )
B$ = MID$ (N$, P, 1)
IF LCASE$ (B$) = “a” THEN
C = C + 1
END IF
NEXT P
PRINT C
END SUB
a) Write the name of the sub procedure used in the above program.
Ans: The name of the sub procedure used in the above program is TEST
b) Write any two library functions used in the above program.
Ans: Any two library functions used in the above program are MID$( ) and LEN( )
14
a) Write a program to calculate the area of four walls of a room using Sub…..End Sub. [3]
DECLARE SUB AREA (L, B, H)
CLS
INPUT “ENTER LENGTH”; L
INPUT “ENTER BREADTH”; B
INPUT “ENTER HEIGHT”; H
CALL AREA (L, B, H)
END
SUB AREA (L, B, H)
A = 2 * H * (L + B)
PRINT “AREA OF FOUR WALLS”; A
END SUB
b) Using Functions……End Functions Write a program to find odd or even. [3]
DECLARE FUNCTION CHECK$ (N)
CLS
INPUT “ENTER ANY NUMBER”; N
PRINT “The given number is “ CHECK$(N)
END
FUNCTION CHECK$ (N)
IF N MOD 2 = 0 THEN
CHECK$ = “Even Number”
ELSE
CHECK$ = “Odd Number”
END IF
END FUNCTION
c) Write a program to create a data file ‘emp.dat’ to store employees name, post, address and salary according to the need of the user. [3]
OPEN “record.dat” FOR OUTPUT AS #1
DO
CLS
INPUT “Enter Name”; N$
INPUT “Enter Post”; P$
INPUT “Enter Address”; A$
INPUT “Enter Salary”; S
WRITE #1, N$, P$, A$, S
INPUT “Do you want to continue (Y / N)”; CH$
LOOP WHILE UCASE$ (CH$) = “Y”
CLOSE #1
END
