SOLVED PABSON Kathmandu – Mid Terminal Examination 2082 – COMPUTER SCIENCE – SET B

 

 

SOLVED PABSON Kathmandu – Mid Terminal Examination 2082 – COMPUTER SCIENCE – SET B

 

Attempt all questions.

 

Group ‘A'(10 Marks)

 

1. Answer the following questions in one sentence:          (6´1=6)

a)   Name any two connectors used in computer network.

BNC and RJ-45 connectors are the any two connectors used in computer network

 

b) List any two examples of power protection device.

Any two examples of power protection device are volt guard and UPS

 

c)   What is social media?

Social media is an online platform that allows people to share information, ideas, and communicate with others.

 

d) Write any two application of Artificial Intelligence.

Any two applications of Artificial Intelligence are speech recognition and self-driving cars.

 

e)   What is database?

A database is an organized collection of data that can be easily accessed, managed, and updated.

 

f)   What is actual parameter in QBASIC?

An actual parameter in QBASIC is the real value or variable passed to a subroutine or function when it is called.

       

2.   Write appropriate technical term for the following: (2´1=2)

a)   A network device that connects dissimilar networks with different protocols. Gateway

b)   A system of paying for goods and services through an electronic medium. Online payment

 

3. Write the full form of the following:                   (2´1=2)

a) Wi-Fi → Wireless Fidelity
b) G2C → Government to Citizen  

 

Group ‘B' (24 Marks)

 

4. Answer the following questions:                         (9´2=18)

a)   What is communication? List the three basic elements of any communication system.

      The process of sending and receiving data and information between two or more than two people is known as communication.

      Three basic elements are: Sender, Medium, Receiver.

 

b)   What is digital footprint?

A digital footprint is the trail of data and information left behind by an individual's online activities which includes social media posts, website visits, online purchases, and other digital engagements

 

c)   What is biometrics? What does biometrics use for user authentication?

      Biometric is a technology that uses unique physical or behavioral characteristics, such as fingerprints, facial recognition, or voice patterns, to identify and authenticate individuals.

      It uses fingerprints, face recognition, iris patterns, or voice recognition for user authentication.

 

d)   Mention any one advantage and disadvantage of e-commerce.

 

Advantage: E-commerce allows to shop 24/7 from anywhere with an internet connection.

Disadvantage: Risk of online fraud and security issues.

 

 

 

e)   What are the goals of E-Government?

      The goals of E-Government are:

v Citizens can access government services and information conveniently from anywhere. 

v Reduces paperwork and manual processes, saving time and resources. 

v Promote transparency by making government actions and decisions visible to the public. 

 

f)   What is record? Why is primary key necessary in record?

A record is a row in a table which contains information about single items in a database. Record is complete set of information.

A primary key is necessary in a database record because it reduce and control duplication of the record in a table, sets the relationship between tables and identifies each record of a table uniquely.

 

g)   Differentiate between sorting and filtering.

 

Sorting	Filtering
The process of arranging all the records in a table either ascending or descending order based on field or fields is known as sorting.	Filtering is the process of viewing required record of a table that matches the specifies criteria.
Sorting affects the entire dataset.	Filtering only affects the data that is displayed.

 

h)   What is query? Mention the different types of action query.

Query is an object of database that is used to view, retrieve, change and analyze records from a table or multiple linked tables based on specified condition.

Types of action queries:

1.     Update Query

2.     Delete Query

3.     Append Query

4.     Make-Table Query

 

 

i)      What is report? Why it is important?

Report is one of the MS-Access database objects used to present information in an effective and organized format that is ready for printing.

It is important because it summarizes information for decision-making, analysis, and sharing results.

 

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

DECLARE SUB TEST(S$ )

CLS

E$ =" PABSON"

CALL TEST (E$)  

END

SUB TEST (S$)

FOR I = 1 to LEN (S$)

      IF i MOD 2 < > 0 THEN

          EE$ = EE$+LCASE$(MID$(S$,I,1))

ELSE

EE$=EE$+UCASE$(MID$(S$,I,1))

      END IF

       NEXT I

      PRINT EE$

END SUB

 

Dry Run Table

E$	S$	I = 1 to LEN (S$)	IF i MOD 2 < > 0?	Yes EE$ = EE$+LCASE$(MID$(S$,I,1))	No EE$=EE$+UCASE$(MID$(S$,I,1))	PRINT EE$
PABSON	PABSON	1 to 6 yes	1 mod 2<>0 1=0 Yes	p
		2 to 6 yes	2 mod 2=0 0=0 no		A
		3 to 6 yes	3 mod 2=0 1=0 yes	b
		4 to 6 yes	4 mod 2=0 0=0 no		S
		5 to 6 yes	5 mod 2=0 1=0 yes	o
		6 to 6 yes	6 mod 2=0 0=0 no		N
		7 to 6 no Loop exits				pAbSoN

 

The Output of the program:

pAbSoN

 

 

 

6.  Re-write the given program after correcting the bugs: (2)

      REM To check the supplied no. is odd or even

      DECLARE FUNCTION Check$ (X)

      CLS

      ACCEPT “ANY NUMBER:”; N

      CALL Check$ (X)

      END

      SUB Check$ (N)

      Y=2

      R= Y MOD N

      IF R=0 THEN

      C$= “EVEN”

      ELSE

      C$= “ODD”

      END

      C$=Check$

      END FUNCTION

 

 Debugged Program

REM To check the supplied number is odd or even

DECLARE FUNCTION Check$ (X)

CLS

INPUT "ANY NUMBER: "; N

PRINT Check$(N)

END

 

FUNCTION Check$ (X)

  Y = 2

  R = X MOD Y

    IF R = 0 THEN

        Check$ = "EVEN"

    ELSE

        Check$ = "ODD"

    END IF

END FUNCTION

 

7. Study the following program and answer the given questions:                                   (2´1=2)

DECLARE SUB TEST (B$)

CLS

INPUT W$

CALL TEST (W$)

END

SUB TEST (B$)

            FOR I =1 To LEN (B$)

                        PRINT RIGHT$(B$), i)

            NEXT I

END SUB

      Questions:

a)   Write the name of two built in functions used in the above program.

      The name of two built in functions used in the above program are LEN( ) and RIGHT$( ).

b)   List the formal parameters of the above program.

      The formal parameters of the above program is B$.

 

Group ‘C’ (16 Marks)

 

8.   Convert / Calculate as per the instruction:      (4´1= 4)

i) (231)₈ = (?)₁₀                             ii) (1D3)₁₆ = (?)₂ 

iii) (111001 - 11) + 111001          iv)(101101 ÷ 110)      

 

9. Answer the following.                                           (4´2= 8)

a)   WAP to calculate area of rectangle using SUB…. END SUB and

      area of circle using FUNCTION…. END Function. ‘

 

REM Area of Rectangle using SUB

DECLARE SUB AOR (L, B)

DECLARE FUNCTION AOC (R)

CLS

INPUT "Enter Length of Rectangle: "; L

INPUT "Enter Breadth of Rectangle: "; B

INPUT "Enter Radius of Circle: "; R

CALL AOR(L, B)

PRINT "Area of Circle = "; AOC(R)

END

 

SUB AOR (L, B)

    A = L * B

    PRINT "Area of Rectangle = "; A

END SUB

 

FUNCTION AOC (R)

    AOC = 22/7 * R ^ 2

END FUNCTION

 

 

b)   Write a program to ask a number and check it is exactly divisible by 4 and 6 using SUB……END SUB.

 

REM Check divisibility by 4 and 6

DECLARE SUB Check (N)

CLS

INPUT "Enter any number: "; N

CALL Check(N)

END

 

SUB Check (N)

    IF N MOD 4 = 0 AND N MOD 6 = 0 THEN

        PRINT N; " is divisible by both 4 and 6"

    ELSE

        PRINT N; " is NOT divisible by both 4 and 6"

    END IF

END SUB

 

 

10.       WAP to find sum of digits of a number using SUB….END SUB.  (4)

                                                                  [Hint: 456: 4+5+6=15]

 

REM Sum of digits using SUB

DECLARE SUB Sum (N)

CLS

INPUT "Enter a number: "; N

CALL Sum(N)

END

 

SUB Sum (N)

    S = 0

    WHILE N <> 0

        R = N MOD 10

        S = S + R

        N = N \ 10

    WEND

    PRINT "Sum of digits = "; S

END SUB

 

 

.                                               or

Write a program in QBASIC to display sum of first 10 natural numbers using FUNCTION…. END  FUNCTION.

 

 

REM Sum of first 10 natural numbers using FUNCTION

DECLARE FUNCTION Sum()

CLS

PRINT "Sum of first 10 natural numbers = "; Sum

END

 

FUNCTION Sum()

    S = 0

    FOR I = 1 TO 10

        S = S + I

    NEXT I

    Sum = S

END FUNCTION

 

?ÿ@