SOLVED PABSON KASKI SEE Preparatory Examination – 2082 Subject: Optional II (Computer Science)

 

PABSON KASKI SEE Preparatory Examination – 2082

Subject: Optional II (Computer Science)
Time: 2 Hours
Full Marks: 50

 

Group “A” (10×1 = 10 Marks)

 

1. Answer the following questions in one sentence: [6×1 = 6]

 

a) Name the topology having true point-to-point connections.
Ans: The topology having true point-to-point connections is Mesh topology.

 

b) Define online payment.
Ans: Online payment is an electronic method of paying money through the internet using digital services like cards, wallets, or bank transfer.

 

c) Which object of MS-Access is used to retrieve data from the table?
Ans: Query is used to retrieve specific data from a table based on defined criteria.

 

d) Name the logical data type in MS-Access.
Ans: The logical data type in MS-Access is Yes/No.

 

e) What is the function of FILES statement?
Ans: The FILES statement is used to display the list of files and sub-directories in the current directory.

 

f) List any two format specifier used in C language.
Ans: Two format specifiers are %d (integer) and %c (character).

 

2. Write appropriate technical term for the following: [2×1 = 2]

a) The website that search information for specified keywords in WWW. Search Engine
b) A protocol responsible for uploading and downloading files. FTP (File Transfer Protocol)

 

3. Write the full form of the following: [2×1 = 2]

a) PaaS = Platform as a Service
b) STP = Shielded Twisted Pair

 

Group “B” (12×2 = 24 Marks)

4. Answer the following questions: [9×2 = 18]

a) What is network transmission mode? Explain with example.

A network transmission mode refers to the direction and method of data flow between two devices in a communication network.

Types with Examples:

1. Simplex Mode -Data flows in one direction only.
   Example: Keyboard sending data to a computer, television broadcast.
2. Half-Duplex Mode - Data flows in both directions, but not at the same time.
   Example: Walkie-talkie communication.
3. Full-Duplex Mode - Data flows in both directions simultaneously.
   Example: Telephone or video call communication.

b) Who is Digital Citizen? List types of footprint.

A digital citizen is a person who uses digital technologies such as the internet, computers, and mobile devices responsibly, safely, and ethically to communicate, learn, and participate in society.

Types of footprint:

Active Digital Footprint - Information that a user intentionally shares online, such as social media posts, comments, emails, and online form submissions.

Passive Digital Footprint - Information that is collected automatically without the user’s direct knowledge, such as browsing history, cookies, IP address, and location data.

c) What is 2F authentication? Explain with an example.

Two-Factor Authentication (2FA) is a security mechanism in which a user must provide two different types of authentication factors to verify their identity before gaining access to a system. It adds an extra layer of security beyond just a username and password.

Example: When a user logs into an email account, they first enter their password. Then, an OTP (One Time Password) is sent to the user’s registered mobile number. The user enters the OTP to complete the login process. This confirms the user’s identity using two factors.

d) What is E-commerce? Write any two types of e-commerce.
E-commerce (Electronic Commerce) refers to buying and selling goods or services using the internet.

Types of E-commerce (any two):

1. B2C (Business to Consumer) - Transactions between a business and an individual customer.
   Example: Online shopping from Amazon or Flipkart.
2. B2B (Business to Business) - Transactions between two businesses.
   Example: A wholesaler selling products to a retailer online.

 

e) Why is mobile computing necessary at present? Write any two reasons.
Mobile computing is necessary at present because it allows users to access information and services anytime and anywhere using mobile devices. Any two reasons are:

1. Mobility and Convenience - Users can work, communicate, and access data while on the move without being tied to a fixed location.
2. Real-time Access to Information - Mobile computing enables instant access to emails, online services, cloud data, and applications, which is essential in today’s fast-paced world.

 

f) What is RDBMS? Give any two examples.

An RDBMS is a type of database management system that stores data in the form of tables (relations) consisting of rows and columns, and uses keys to maintain relationships between tables.

Any two examples of RDBMS:

1. MySQL
2. Oracle

g) Differentiate between computerized and non-computerized databases.

Computerized Database	Non-Computerized Database
Data is stored and managed using computers and software.	Data is stored manually in registers, files, or paper records.
Fast data retrieval and processing.	Data retrieval is slow and time-consuming.
Requires less physical storage space.	Requires large physical storage space.
Easy to update, modify, and search data.	Difficult to update and search data.
More secure with passwords and access control.	Less secure and prone to loss or damage.

 

 

h) Why is report object used in MS-Access? Write any two reasons.

A report object in MS-Access is used to format, summarize, and present data from tables or queries in a structured and readable form.

Any two reasons:

1. To present data in a formatted manner - Reports allow data to be displayed with headings, grouping, totals, and proper layout.
2. To print data easily - Reports are mainly used for generating print-ready outputs such as invoices, summaries, and official records.

i) List any two major differences between form and table.

 

Form	Table
Used to enter, view, and edit data in a user-friendly way.	Used to store data in rows and columns.
Provides a customized layout with controls like text boxes and buttons.	Has a fixed structure with fields and records.

 

 

5. Write down the output of the given program. Show with dry run in table. [2]

DECLARE SUB OUT(A$)

CLS

A$="TECHNOLOGY"

CALL OUT (A$)

END

 

SUB OUT (A$)

T=1

FOR I=LEN (A$) TO 1 STEP-4

PRINT TAB (T); MID$(A$, T, I)

T=T+2

NEXT I

END SUB

 

Dry Run Table

Pass	I (Loop Var)	T (Start Pos)	MID$(A$, T, I)	Output	New T
1	10	1	"TECHNOLOGY" (Start 1, Len 10)	TECHNOLOGY	3
2	6	3	"CHNOLO" (Start 3, Len 6)	CHNOLO	5
3	2	5	"NO" (Start 5, Len 2)	NO	7

Output

TECHNOLOGY

     CHNOLO

           NO

 

 

6. Re-write the given program after correcting the bugs: [2]

REM Program to display all those records whose address is "KTM" and post is "MANAGER"

 

OPEN "Employee.dat" FOR OUTPUT AS #10

PRINT "NAME","ADDRESS","POST","SALARY"

WHILE NOT EOF(10)

WRITE #10,NS,ADS,POS,Sa#

IF UCASES(ADS)="KTM" AND UCASES(POS)="MANAGER" THEN

PRINT #10,NS,ADS,POS,Sa#

ENDIF

WEND

CLOSE #101

END

 

Debugged Program

REM Program to display records with address KTM and post MANAGER

OPEN "Employee.dat" FOR INPUT AS #10

CLS

PRINT "NAME", "ADDRESS", "POST", "SALARY"

WHILE NOT EOF(10)

    INPUT #10, N$, AD$, PO$, Sa#     

    IF UCASE$(AD$) = "KTM" AND UCASE$(PO$) = "MANAGER" THEN

        PRINT N$, AD$, PO$, Sa#      

    END IF                           

WEND

CLOSE #10                             

END

 

 

7. Study the following program and answer the given questions: [2×1 = 2]

DECLARE FUNCTION PAB(N)

CLS

INPUT "ENTER A MULTI-DIGIT NUMBER";N

X=PAB(N)

WHILE X<>0

D=X MOD 10

IF D MOD 2=0 THEN S=S+D

X=X\10

WEND

PRINT "RESULT =";S

END

 

FUNCTION PAB(N)

DO WHILE N<>0

R=N MOD 10

V=V*10+R

N=N\10

LOOP

PAB=V

 

END FUNCTION

a) Find the result when user inputs 12345.

The result when user inputs 12345 is 6.

b) List two local variables used in the above program.

D and X (used in the main module), or R and V (used in the FUNCTION module).

 

Group “C” (4×4 = 16 Marks)

8. Convert / calculate as per the instruction: [4×1 = 4]

i)  Answer: 10100₂

ii)  Answer: 1111₂

iii) into base 8 Answer: 712₈

iv) into base 2 Answer: 100011000011₂

 

 

9.

a) Write a program in QBasic to find the area and volume of cuboid.
Use function routine to calculate area of cuboid and Sub procedure to calculate volume of cuboid.

DECLARE FUNCTION Area(l, b, h)

DECLARE SUB Volume(l, b, h)

CLS

INPUT "Enter Length, Breadth, Height: ", l, b, h

PRINT "Total Surface Area = "; Area(l, b, h)

CALL Volume(l, b, h)

END

 

FUNCTION Area(l, b, h)

    Area = 2 * (l * b + b * h + l * h)

END FUNCTION

 

SUB Volume(l, b, h)

    V = l * b * h

    PRINT "Volume = "; V

END SUB

 

b) A sequential data file named “PABSON.DAT” contains few records of students like SName$ (Student’s Name), SAdd$ (Student’s Address) and Dob$ (Date of Birth). Write a program to read all the records from the file and print records of only whose name starts with “P” alphabet.

 

OPEN "PABSON.DAT" FOR INPUT AS #1

CLS

PRINT "Student Name", "Address", "Date of Birth"

WHILE NOT EOF(1)

    INPUT #1, SName$, SAdd$, Dob$

    IF UCASE$(LEFT$(SName$, 1)) = "P" THEN

        PRINT SName$, SAdd$, Dob$

    END IF

WEND

CLOSE #1

END

 

 

 

 

 

10. Write a program in ‘C’ language to input principle, rate and time and calculate simple interest as well as amount. [4]

#include <stdio.h>

 

int main() {

    float p, t, r, si, amt;

    printf("Enter Principle: ");

    scanf("%f", &p);

    printf("enter time: ");

    scanf("%f", &t);

    printf("enter rate: ");

    scanf("%f", &r);

   

    si = (p * t * r) / 100;

    amt = p + si;

    printf("simple interest = %.2f\n", si);

    printf("total amount = %.2f", amt);

    return 0;

}

 

OR

Write a program in ‘C’ language to print the given series: 1 4 7 10 13 …… 10ᵗʰ term

 

#include <stdio.h>

int main() {

    int i, t = 1;

    for(i = 1; i <= 10; i++) {

        printf("%d ", t);

        t = t + 3;

    }

    return 0;

}