PABSON PRE BOARD EXAM COMPUTER SCIENCE CLASS 10 SOLVED SET

 

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

 d.      Which query is used to make mass changes in the data stored in the database?

Ans: The UPDATE query is used to make mass changes in the data stored in a database.

 e.      What is Primary Key?

Ans: A Primary Key is a unique identifier for each record in a database table, ensuring that no two records have the same value.

 f.       Write any two types of operators used in C language.

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

 (b) A website used to search for specific words on the Internet.

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.

 Star Topology: In a star topology, al devices are connected to a central hub or switch. Each device has a dedicated connection to the hub. If one device fails, it does not affect the rest of the network. However, if the central hub fails, the entire network goes down.

 

.

 B.      Write any four opportunities and threats of social media.

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.

 Forms of e-payment in Nepal:

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.

 D.    What is cloud computing? What are the services provided by cloud computing.

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

 

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 10^th terms.

#include <stdio.h>

 

int main() {

    int i = 1;

 

    printf("Series: ");

    while (i <= 10) {

        printf("%d ", i * i);

        i++;

    }

 

    return 0;

}

 

 www.milanabaral123.blogspot.com