SEE 2080 (2024)
Group
'A'
1.
Answer
the following questions in one sentence. (6X1=6)
a.
What is unguided media?
Unguided communication is a communication channel in which data
and information transferred between two devices without using wire or cable.
b.
What is the business done through the mobile?
The business done through the mobile is M-Commerce.
c.
Which data type is used to store date of birth in MS-Access?
Data type is used to store date of birth in MS-Access is Date/Time.
d.
Write any two elements of database.
Elements of database are Field and Record.
e.
What is modular programming?
Modular programming is a technique used to divide our program into
many program small logical, manageable and functional modules or blocks
f.
Write any two features of C- language.
·
C is a Structured Programming Language. which break down a program
in several small modules and makes the programmer easier to manage and debug
the code.
·
C combines elements of a high level language with some features of
assembler which helps to manipulates memory address.
2.
Write
appropriate technical term for the following.(2X1=2)
a. A
secret group of characters used to protect computer system from unauthorized users.
Password
b. An
artificial environment created by a computer system that appears real.
c. Virtual
reality
3. Write the full form of the following(2X1=2)
a. URL - Uniform Resource Locator
b. STP-Shielded
Twisted Pair Cable
4.
Answer
the following questions(9X2=18)
a. Define
network topology. Sketch a drawing of star topology.
Network topology is the inter- connected pattern of network
components.
b. Write
any four commandments of computer ethics.
·
Do not use a computer to publish fake information.
·
Do not search the file or record of other people.
·
Do not destroy or delete the records of other people.
·
Do not use a computer to steal someone's privacy.
c. What
are the computer security threats? Mention any two measures to protect from
security threats.
Computer security threat is a risk which can potentially harm
computer systems and organization.
Any two measures to protect from security threats are:
·
Firewalls
·
Cryptography
d. What
is E-commerce? List any two E-commerce companies in Nepal.
E-Commerce refers to electronic transactions such as buying,
selling and exchanging of goods, services and information over computer
communication network such as the Internet.
Any two E-commerce companies in Nepal are sastodeal and daraz
e. Define
Artificial Intelligence with examples.
Al is an emerging branch in computer science, which interprets the
means and method of making computers think like human beings.
Examples are self-driving cars and speech recognition (like Siri,
Microsoft Cortana)
f. List
any four features of MS-Access.
·
It provides the flexible ways to add, edit, delete and display the
related data.
·
Queries help to view, change and analyse the data indifferent
ways.
·
Forms are used for viewing and editing the information.
·
Reports are used for summarizing and printing the data.
g. What
is Primary Key? Give any two benefits of it.
A primary key is a field or combination of fields in a table that
uniquely identifies each record, and is used to establish relationships between
tables and enforce data integrity.
Any two benefits are
·
It sets the relationship between tables.
·
It reduces and controls duplication of record in a table
h. Give the differences between the Select Query
and Action Query.
|
Select Query |
Action Query |
|
Select query is simply
used to select and display the relevant data from the database. |
An action query is a
query that makes changes to or removes many records in just one operation. |
|
It does not make
change to database. |
It makes change to
database. |
|
A query does not save
data; rather, it displays information from tables. |
Action query allows previewing
the query results before performing it, which is a nice feature |
|
A select query is a
database item that presents information in Datasheet view. |
Multiple records can
be added, updated, or deleted simultaneously using action queries. |
i.
Identify a record and
field from the following table structure:
|
Symbol
No. |
Name |
Marks |
|
001002025 |
Aarambha
Shrestha |
91 |
|
01002031 |
Suhisha
Rayamajhi |
99 |
Record :
|
001002025 |
Aarambha
Shrestha |
91 |
|
01002031 |
Suhisha
Rayamajhi |
99 |
Field : Symbol No., Name and Marks
5.
Write down the output of the given program and
show them in dry run table:
DECLARE FUNCTION SQN (N)
CLS
S=0
FOR L=1 TO 3
READ NUM
S=S+SQN (NUM)
NEXT L
PRINT "Sum of
square"; S
DATA 1, 4, 5
END
FUNCTION SQN (N)
SQN = N^2
END FUNCTION
|
S |
L=1 to 3 |
Read Num |
S=S+SQN (NUM) |
SQN = N^2 |
|
0 |
1 to 3 yes |
1 |
0+1=1 |
1^2=1 |
|
|
2 to 3 yes |
4 |
1+16=17 |
4^2=16 |
|
|
3 to 3 yes |
5 |
17+25=42 |
5^2=25 |
|
|
4 to 3 No loop exist |
|
|
|
|
Output : Sum of square
42 |
||||
6.
Re-Write the given program after correcting the
bugs:
DECLARE SUB Square (A)
REM to print square of an
input number
CLS
GET "Enter a
number"; N
Square (N)
END
SUB Square (A)
Sq = A^ 4
Display "Square of
a number is "; Sq
End Sub
Debugged Program
DECLARE SUB Square (A)
REM to print square of a
input number
CLS
INPUT
"Enter a number"; N
CALL Square
(N)
END
SUB Square (A)
Sq = A^ 2
PRINT
"Square of a number is "; Sq
End Sub
7.
Study the following program and answer the given
questions:
DECLARE FUNCTION Count
(W$)
INPUT "Enter a
word"; R$
C = Count (R$)
PRINT C
END
FUNCTION Count (W$)
FOR L 1 TO LEN (W$)
Ch$=MID$ (W$, L, 1)
IF UCASES (Ch$) =
"K" THEN
N=N+1
END IF
NEXT L
Count = N
END FUNCTION
a.
List any two library
functions used in the above program.
UCASE$() and MID$()
b.
Write the use of
variable 'C' in line 3 [i.e. C = Count (R$)] given in the above program.
The use of variable 'C' in line 3 [i.e. C =
Count (R$)] given in the above program is to store the value returned by the
function count().
Group C
8.
(Convert/Calculate as per the instruction):
a.
(ABC)16=(?)8
b.
(435)10 =(?)8
c.
(101)2 X(101)2=(?)2
d.
(101101)2 /(101)2
9.
a.
Write a program in
QBASIC that asks length, breadth and height of room and calculate its area and
volume. Create a User Defined Function to calculate Area and Sub Program to
calculate the Volume. [Hint: Area LxB and Volume = LxBxH]
DECLARE FUNCTION AREA(L,B)
DECLARE SUB VOL(L,B,H)
CLS
INPUT "Enter
Length"; L
INPUT "Enter
Breadth"; B
INPUT "Enter
Height"; H
PRINT "Area of
room="; AREA(L,B)
CALL VOL(L,B,H)
END
FUNCTION AREA(L,B)
AREA = L * B
END FUNCTION
SUB VOL(L,B,H)
V=L*B*H
PRINT "Volume of
Room="; V
END SUB
b.
Employee's name, address, gender and salary are
stored in the "EMP.DAT" sequential data file. Write a QBASIC program
that displays all information about personnel whose salaries exceed 60000.
OPEN "EMP.DAT"
FOR INPUT AS #1
CLS
WHILE NOT EOF (1)
INPUT #1, N$, A$, G$, S
IF S > 60000 THEN
PRINT N$, A$, G$, S
WEND
CLOSE #1
END
10.
a.
Write a program in 'C' language to find simple
interest where user need to input Principle, Rate and Time.
#include<stdio.h>
int main()
{
float p, t, r, i;
printf("Enter
principal, time and rate ");
scanf("%f%f%f",
&p,&t,&r);
i = (p*t*r)/100;
printf("Simple
Interest = %f", i);
return 0;
}
(Or)
Write a program in 'C' language to display the series with their
sum. 1,2,3,4, up to 10th term.
#include <stdio.h>
int main()
{
int i;
for(i=1;i<=10;i=i+1)
{
printf(“%d”,i);
}
return 0;
}