SET 15: PABSON (KASKI)

 

SET 15: PABSON 2081(Kaski)

GROUP 'A'

1. Answer the following questions in one sentence:             

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 refers to the payment for buying goods or services through the Internet using different online payment gateway 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 in the current directory in QBASIC.

f) List any two format specifier used in C language.
Ans: Any two format specifiers used in C language 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. Ans: Search Engine
b) A protocol responsible for uploading and downloading files. Ans: 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'

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

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

Ans: A network transmission mode refers to the direction and way of transmission of data from one location to another in a communication network.

The different types of data transmission(communication) mode are as follows:

1) Simplex Mode: Simplex mode is the transmission of data and information that takes place in only one direction. Examples: Radio, newspaper, television broadcasting.

2) Duplex Mode: Duplex mode is the transmission of data and information that flows in both directions. There are two types of duplex modes:
a) Half Duplex Mode: Half-duplex is a transmission mode where data flows in both directions but only one direction at a time. Examples: Walkie-talkie, wireless handsets.
b) Full Duplex Mode: Full-duplex is a transmission mode where data flows in both directions simultaneously on the same communication path. Examples: Mobile phones, Video Call.

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

Ans: 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 are:

a) Active Digital Footprint: Information a user shares intentionally, like posts, emails, or comments.
b) Passive Digital Footprint: Information collected automatically, like browsing history or location data.

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

Ans: 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.

Ans: E-Commerce (Electronic Commerce) is the process of buying and selling goods and services online using the Internet.

Any two types of E-Commerce are:

1) Business to Consumer (B2C): B2C is a type of e-commerce in which Businesses sell directly to individual customers. Example: Amazon – buy books, electronics, clothes.

2) Business to Business (B2B): Businesses sell products or services to other businesses. Example: Alibaba – supplies goods in bulk to retailers.

e) Why is mobile computing necessary at present? Write any two reasons.
Ans: Mobile computing is necessary in the present time because it allows people to access information and communicate anytime and anywhere using mobile devices. Any two reasons are:

a) It allows people to work and communicate from anywhere at any time.
b) It increases the productivity of users by reducing time and cost.

f) What is RDBMS? Give any two examples.

Ans: An RDBMS is a type of database management system that stores data in tables and allows relationships between tables using keys.

Any two examples of RDBMS are: MySQL and Microsoft Access.
g) Differentiate between computerized and non-computerized databases.

Computerized Database	Non-Computerized Database
A database where data is stored and managed using a computer and software.	A database where data is stored and managed manually using files or registers.
Example: Student records stored in MS-Access.	Example: Student records written in a register.
Data can be searched and updated very fast.	Data is searched and updated slowly.
Data is more secure with passwords and backup.	Data is less secure and can be easily lost or damaged.

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

Ans: Report is used in MS‑Access to present information in an effective and organized format that is ready for printing. Any two reasons of creating a report are:

1) It presents data in a clear and well‑organized format.

2) It makes printing of database information easy and professional.

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

Form	Table
Form is used for data entry, viewing, and editing records.	Table is used to store data in rows (records) and columns (fields).
It provides a user‑friendly interface for entering and modifying data.	It provides the raw structure where data is actually stored.

 

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

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

Ans: Dry run table:

A$	FOR I=LEN (A$) TO 1 STEP-4	I	T (before)	MID$(A$,T,I)	PRINT TAB(T); MID$(A$, T, I)
TECHNOLOGY	10 To 1 Yes	10	1	MID$("TECHNOLOGY", 1, 10) =TECHNOLOGY	(Column 1) TECHNOLOGY
	6 To 1 Yes	6	3	MID$("TECHNOLOGY", 3, 6) =CHNOLO	(Column 3) CHNOLO
	2 To 1 Yes	2	5	MID$("TECHNOLOGY", 5, 2) = NO	(Column 5) NO
	-2 To 1 No (Loop Exits)

The output of given program is:

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

Ans: 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.

Ans: The result when user inputs 12345 is 6.
b) List two local variables used in the above program.

Ans: Main module local variables: N, X, D, S   and Function PAB local variables: N, R, V

 

GROUP 'C'

8. Convert / calculate as per the instruction:                     

i)  Ans: 10100₂

ii)  Ans: 1111₂

iii) into base 8 Ans: 712₈

iv) into base 2 Ans: 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.  Hint:
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)

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

    Area = A

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

WHILE NOT EOF(1)

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

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

        PRINT "Student Name: "; SName$

        PRINT "Address: "; SAdd$

        PRINT "Date of Birth: "; Dob$

        PRINT

    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.

#include<stdio.h>

int main()

{

    float p, t, r, si, a;

    printf("Enter Principle: ");

    scanf("%f", &p);

    printf("Enter Rate: ");

    scanf("%f", &r);

    printf("Enter Time: ");

    scanf("%f", &t);

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

    a = p + si;

    printf("Simple Interest = %f\n", si);

    printf("Amount = %f", a);

    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, a = 1;

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

    {

        printf("%d ", a);

        a = a + 3;

    }

    return 0;

}