OPT.II COMPUTER SCIENCE (3031)
SOLVED
SEE PRE BOARD EXAM (PABSON)-2081
Time: 2 Hours F.M.:
50
Group A (10 Marks)
1. Answer
the following questions in One sentence 6
× 1 =6
a. a. Write the different architecture of
computer network.
Ans: The different architectures of
computer networks are:
Peer-to-Peer (P2P): All devices
have equal capabilities and responsibilities
. Client-Server: Centralized
architecture where clients request services and servers provide them.
b. b. What is cyber bullying.
Ans: Cyberbullying refers to the use of digital platforms such as social media, emails, and messaging to harass, intimidate, or humiliate individuals.
c. Write any two services provided by the Internet.
Ans:
Two services provided by the Internet are: Email Services (Gmail, Yahoo, etc.)Cloud Storage (Google
Drive, OneDrive, etc.)
Ans:
The UPDATE query is used to make mass changes in the data
stored in a database.
Ans:
A Primary Key is a unique identifier for each record in a database table,
ensuring that no two records have the same value.
Ans:
Arithmetic Operators: +, -, *, /, MOD
b. Relational Operators: =, <>, >, <, >=, <=
2. Write appropriate technical terms for the following: (2 x 1 = 2)
(a) The law that determines cybercrime policies in a country.
Ans: Cyber Law
Ans: Search Engine (e.g., Google, Bing, Yahoo)
3.
Write the full form of the following: (2 x 1 = 2)
(a)
POP - Post Office Protocol
(b) ISP - Internet Service Provider
Group B (24
Marks)
4.
Answer the following questions: 9 × 2=18
a.
Differentiate
between LAN and MAN.
|
LAN (Local Area
Network): A
LAN is a network that connects computers and devices in a limited
geographical area such as a home, school, or office building. |
MAN
(Metropolitan Area Network): A MAN is a network that spans a city or a
large campus. It is larger than a LAN but smaller than a WAN (Wide Area
Network). |
|
It is typically used
for sharing resources like files, printers, and internet connections. |
MANs are
used to connect multiple LANs within a city. |
A.
What
is network topology? Explain about star topology with suitable diagram.
Ans:
Network topology refers to the arrangement of different elements (links, nodes,
etc.) in a computer network. It defines how devices are interconnected and how
data flows within the network.
.
Ans: Opportunities:
1. Networking: Social
media allows individuals and businesses to connect with others globally.
2. Marketing: Businesses
can reach a large audience through targeted advertising.
3. Information Sharing: Users
can share and access information quickly.
4. Community Building: Social
media helps in building communities around shared interests.
Threats:
1. Privacy Issues: Personal
information can be misused.
2. Cyberbullying: Users
can be harassed or bullied online.
3. Misinformation: False
information can spread rapidly.
4. Addiction: Excessive
use can lead to addiction and mental health issues.
C. What is meant by Online Payment? Write the different forms of e-payment in Nepal.
Ans: It refers to the process of transferring money electronically over the internet. It allows users to make transactions without the need for physical cash.
Mobile
Banking: Services like eSewa, Khalti, and IME Pay.
Internet
Banking: Services provided by banks for online transactions.
Credit/Debit
Cards: Payments made using card details.
Digital
Wallets: Prepaid accounts that store money for online transactions.
Ans: Cloud computing is the delivery of computing services (servers, storage, databases, networking, software, etc.) over the internet ("the cloud").
Services
Provided:
Infrastructure
as a Service (IaaS): Provides virtualized computing resources over the
internet.
Platform
as a Service (PaaS): Provides a platform allowing customers to develop,
run, and manage applications.
Software as a Service (SaaS): Delivers software applications over the internet, on a subscription basis.
E.
Define
Data and Information.
Ans: It is raw, unorganized facts and figures that need to be processed. It can be in the form of numbers, text, or symbols.Information is processed data that is organized, structured, and meaningful. It provides context and helps in decision-making.
F.
What is MS-Access? Write any features of
MS-Access.
MS-Access
is a database management system from Microsoft that combines the relational
Microsoft Jet Database Engine with a graphical user interface and
software-development tools.
Features:
User-Friendly
Interface: Easy to use with a graphical interface.
Data
Storage: Can store large amounts of data.
Querying: Allows
users to create queries to retrieve data.
Forms
and Reports: Enables the creation of forms for data entry and reports for
data presentation.
G.
Define
action query.
It is a type of query in a database that performs operations on the data, such as updating, deleting, or appending records. It changes the data in the database.
H.
What
is table? Write the basic components of table.
A
table is a collection of related data held in a structured format within a
database. It consists of rows and columns.
Basic
Components:
Rows
(Records): Each row represents a single record in the table.
Columns
(Fields): Each column represents a specific attribute of the data.
Primary
Key: A unique identifier for each record in the table.
Foreign Key: A field that links to the primary key of another table.
5. 5. Write down the output of the following
along with dry run table. 2
DECLARE
SUB TEST(A$)
CLS
|
iteration |
i |
B$ = MID$(A$, i, 1) |
C$ = C$ + B$ |
Updated C$ |
|
1 |
1 |
B$ = "P" |
C$ = "" +
"P" |
"P" |
|
2 |
2 |
B$ = "A" |
C$ = "P" +
"A" |
"PA" |
|
3 |
3 |
B$ = "B" |
C$ = "PA"
+ "B" |
"PAB" |
|
4 |
4 |
B$ = "S" |
C$ = "PAB"
+ "S" |
"PABS" |
|
5 |
5 |
B$ = "O" |
C$ =
"PABS" + "O" |
"PABSO" |
|
6 |
6 |
B$ = "N" |
C$ =
"PABSO" + "N" |
"PABSON" |
A$="PABSON"
CALL
TEST(A$)
END
SUB
TEST(A$)
FOR i=1
TO LEN(A$)
BS=MIDS(A$,i,1)
CS=C$+BS
NEXT
PRINT
C$
END
SUB
The output of the program is : PABSON
6. 6, Re-Write the given program after
correcting the bug: 2
REM to
display the data from sequential data file "marks.dat" having marks
in English more than 35.
CLS
OPEN
"marks.dat" FOR OUTPUT AS #1
WHILE NOT
EOF(2)
INPUT #1,
NS, ENG, NEP, SCI
ENG + NEP
+ SCI = TOT
IF TOT
> 35 THEN PRINT NS, ENG, NEP, SCI
NEXT
CLOSE
#1
END
Debugged Program
CLS
OPEN
"marks.dat" FOR OUTPUT AS #1
WHILE NOT
EOF (1)
INPUT #1,
NS, ENG, NEP, SCI
TOT= ENG +
NEP + SCI
IF ENG
> 35 THEN PRINT N$, ENG, NEP, SCI
END IF
WEND
CLOSE
#1
END
7. Study the
following program and answer the given questions: 2
DECLARE
FUNCTION GRADE (A)
CLS
INPUT
"ENTER A NUMBER"; B
C=GRADE(B)
PRINT
C
END
FUNCTION
GRADE(X)
WHILE
X<>0
R=X MOD
10
Z=Z+R
X=INT(X/10)
WEND
GRADE=Z
END
SUB
a.
How many parameters are used in the above
program?
One parameter (A or X) is used in the program.
b.
List the different library functions used in
the program.
The program uses the following library function
MOD: Modulus operation.
GROUP C (16 Marks)
8. Convert/Calculate as per the instruction: 4 × 1 =4
.jpg)
.jpg)
9. A. Answer
the following 4 × 2 =8
Write a program in QBasic that asks to enter
three different numbers then to find Product and Average of the numbers. Create
a user defined function PROD () to calculate product and sub procedure AVG() to
calculate average.
DECLARE FUNCTION PROD
(A, B, C)
DECLARE SUB AVG (A, B,
C)
CLS
INPUT "Enter first
number: ", A
INPUT "Enter second
number: ", B
INPUT "Enter third
number: ", C
PRINT "Product:
", PROD(A, B, C)
CALL AVG(A, B, C)
END
FUNCTION PROD (A, B, C)
PROD = A * B * C
END FUNCTION
SUB AVG (A, B, C)
AVG = (A + B + C) / 3
PRINT "Average:
", AVG
END SUB
9.B A sequential data file called "data.dat" has stored the data under the field name, product name, quantity and rate. WAP to display all the records calculating the total amount.
CLS
OPEN
"data.dat" FOR INPUT AS #1
WHILE NOT
EOF(1)
INPUT #1,
ProductName, Quantity, Rate
TotalAmount
= Quantity * Rate
PRINT
ProductName, Quantity, Rate, TotalAmount
WEND
CLOSE #1
END
10. Write a
program in C language to input a number and test whether it is odd or even. 4
#include<stdio.h>
#include<conio.h>
int main()
{
int n;
printf("Enter
any number: ");
scanf("%d",
&n);
if(n % 2= =0)
printf("%d is
even number", n);
else
printf("%d is
odd number", n);
return 0;
}
OR,
Write a program in "C" language to display
the series with their sum. 1,4,9, up to 10th terms.
#include <stdio.h>
int main() {
int i = 1;
printf("Series: ");
while (i
<= 10) {
printf("%d ", i * i);
i++;
}
return 0;
}
