Solved SEE Boost Up Examination-2079 [Computer Science]

 

Solved SEE Boost Up Examination-2079 [Computer Science]

 

 

Candidates are required to give their answers in their own words as for as practicable. Credit shall be originality, not rote learning..

 

Group 'A'

 

1. Answer the following questions.

 

a) Write any two examples of full duplex modes of data transmission.

 

Ans: Any two examples of full duplex modes of data transmission are telephone and mobile.

 

b) List any two software security measures.

Ans: Any two software security measures are password and backup

 

c) Which data type is also known as logical data type in MS-Access?

Ans: Yes/No data type is also known as logical data type in MS-Access

 

d) Which query is used to view the data stored in database?

Ans: Select query is used to view the data stored in database

 

e) What will be the value of x in given c expression x=55 % 10?

Ans: The value value of x will be 5.

 

f) What is looping ?

Ans: Looping is a programming construct that repeatedly executes a block of code until a specified condition is met.

 

2. Write appropriate technical term: (2X1-2)

 

a) Digital marks created while using internet. Digital Footprint

 

 

b) The process of repeatedly executing some code until condition satisfies. Looping

 

3. Write full forms of the following:  (2X1=2)

 

bps: bits per second

 

VOIP: Voice Over Internet Protocol

 

Group 'B'

 

4. Answer the following questions: । (9X2-18)

 

a) Define computer network. List two demerits of computer network.

Ans: Computer network is a group of two or more computers and devices connected to each other through wired or wireless media to exchange data and information and share hardware, software and other resources.

Any two demerits of computer network are:

·       Computer network can be route for computer virus and malware transmission.

·       Skilled manpower is required to manage and operate computer network.

 

 

(b) Give any two advantage of E-mail over traditional mail.

Ans: Any two advantage of E-mail over traditional mail

Emails can be sent and received almost instantly, allowing for quick communication and faster decision making. Traditional mail, on the other hand, can take several days to arrive.

Emails can be sent from anywhere with an internet connection, and they can be easily organized and stored for future reference. Traditional mail requires physical transportation, which can be inconvenient and time-consuming.

 

c) Define computer security How antivirus helps to secure computer software?

Ans: Computer security refers to the measures taken to protect computer systems and networks from unauthorized access, theft, damage, and disruption.

An antivirus helps to secure computer software by detecting and removing malicious software, such as viruses, spyware, and Trojans, that can harm the computer or steal sensitive information.

 

d) Define E-Commerce? Write the name of any two E-commerce sites.

Ecommerce refers to the buying and selling of goods or services using the internet.

The name of any two E-commerce sites  are sastodeal and daraz.

 

e) What is Cryptography? How encryption helps in data protection?

Ans: Cryptography is the practice of securing communication and data by converting it into a code to prevent unauthorized access or manipulation.

Encryption helps in data protection by providing a secure way to store and transmit sensitive information.

 

f) What is database? List two advantages of DBMS

 

Ans: A database is an organized collection of related information that can be used for different purpose so that it can easily be accessed, managed, and updated.

Any two advantages of DBMS are:

·       It controls data redundancy which means duplication of data.

·       It allows sharing the existing data by different programs.

 

g) What is data redundancy? How can it be reduced in database?

Ans: Data redundancy refers to the repetition of data in a database, where the same data is stored in multiple places.

Data redundancy can be reduced in a database by using normalization techniques. Normalization is the process of organizing data in a database to minimize redundancy and improve data integrity.

 

h) Define primary key. Write any two uses of it.

Ans: A key that uniquely identifies each record in a database is primary key.

Any two uses of it are:

i) To reduce and control duplication of record in a table.
ii) To set the relationship between tables.

 

1) Differentiate between fields and records with an examples.

Record	Field
Record is complete set of information. Record is a collection of multiple related fields in a row which gives complete information about a person or thing. E.g.: Ram Chabahil 4468790	Field is a small unit of information. A column in a table is called field, and it contains a specific piece of information within a record. E.g.: Name, Address, Telephone

 

 

 

 

 

5) Write the output of the following program. Show dry run in table. [2]

 

DECLARE FUNCTION EXAM$(W$)

W$ = "COMPUTER"

PRINT EXAM$(W$)

FUNCTION EXAM$ (W$)

    FOR P = 1 TO LEN(W$)

        K$ = MID$(W$, P, 1)

        IF P MOD 2 = 0 THEN

            K$ = LCASE$(K$)

        ELSE

            K$ = UCASE$(K$)

        END IF

        S$ = S$ + K$

    NEXT P

    EXAM$ = S$

END FUNCTION

 

Dry Run

Variable	Variable	Loop Check	Variable	Variable	O/P
W$	P	1 to 8	K$	S$	CoMpUtEr
COMPUTER	1	1 to 8 Yes	C	C
	2	2 to 8 Yes	o	CoMpUtEr
	3	3 to 8 Yes	M
	4	4 to 8 Yes	P
	5	5 to 8 Yes	u
	6	6 to 8 Yes	T
	7	7 to 8 Yes	e
	8	8 to 8 Yes	R
	9	9 to 8 No Loop Exits

 

Output

CoMpUtEr

 

6) Rewrite the given program after correcting bugs,

REM PROGRAM DISPLAY RECORDS

OPEN INFO.DAT FOR INPUT AS #1

CLS

WHILE NOTEOF(2)

INPUT #1, NAME$,AGE,SALARY

DISPLAY NAME$, AGE, SALARY

LOOP WEND

CLOSE #1

END

Debugged Program

 

REM PROGRAM DISPLAY RECORDS

OPEN “INFO.DAT” FOR INPUT AS #1

CLS

WHILE NOT EOF(1)

INPUT #1, NAME$,AGE,SALARY

PRINT NAME$, AGE, SALARY

WEND

CLOSE #1

END

 

Study the following program and answer the given questions.

 

 

DECLARE FUNCTION ABC$(N$)

CLS

INPUT “ENTER ANY WORD”; W$

PRINT “THE RESULT STRING IS”; ABC(W$)

END

 

FUNCTION ABC$ (N$)

FOR I=1 TO LEN (N$)

P$=MID$ (N$,I,1)

R$=P$+R$

NEXT I

SHARED R$

ABC$=R$

END FUNCTION

 

7) Study the following program and answer the given questions. [2]

 

a) List the arguments and parameters used in above program

Ans: The argument used in the above program is W$ and parameter is N$.

 

b) What is the use of SHARED in above program?

Ans: The SHARED keyword in QBASIC is used to declare variables that can be shared among different subroutines in a program.

 

Group 'C'

5)Perform the operations as indicated.

 

a) (10111)₂-(?)₁₀

b) (CCA)₁₆ =  (?)₂

c) (1110 + 1110) X 11

d) (111001) ÷ (101)

 

 

9) Answer the following questions, [4x2=8j

 

a) Write a program in QBASIC that asks principal, time and rate of interest and calculate simple interest and amount. Create a user- defined function to calculate simple interest and sub-program to calculate amount. Hint: [S1-P*T*R/1001, (A-P+SI)

DECLARE FUNCTION INTEREST(P,T,R)

DECLARE SUB AMOUNT(P,I)

CLS

INPUT "ENTER PRINCIAL"; P

INPUT "ENTER TIME"; T

INPUT "ENTER RATE"; R

PRINT "SIMPLE INTEREST="; INTEREST(P, T, R)

CALL AMOUNT(P, I)

END

FUNCTION INTEREST (P, T, R)

SHARED I

    I = P * T * R / 100

    INTEREST = I

END FUNCTION

SUB AMOUNT (P, I)

    A = P + I

    PRINT "AMOUNT="; A

END SUB

b) Write a sequential data file called "abc.dat" has stored data under the field heading Roll No., Name, English, Nepali and Computer. Write a program to display all the information of those students whose marks in computer is more than 45.

 

OPEN “abc.dat” FOR INPUT AS #1

CLS

WHILE NOT EOF(1)

INPUT #1, R,N$,E,NE,C

IF C>45 THEN PRINT R, N$, E, NE, C

WEND

CLOSE #1

END

 

 

 

10) Write a c program to accept any three numbers and display their average.

 

#include<stdio.h>

int main()

{

 

  float num1, num2, num3;

  float sum, avg;

  printf("Enter three Numbers: ");

  scanf("%f %f %f",&num1, &num2, &num3);

  sum = num1 + num2 + num3;

  avg = sum / 3;

  printf("Entered numbers are: %.2f, %.2f and %.2f\n",

           num1, num2, num3);

   printf("Sum=%.2f\n", sum);

  printf("Average=%.2f\n",avg );

  return 0;

}

 

 

OR

 

Write a C program to find out the given number is odd or even

#include <stdio.h>

int main( ) {

    int num;

    printf("Enter an integer: ");

    scanf("%d", &num);

    if(num % 2 = = 0)

        printf("%d is even.", num);

    else

        printf("%d is odd.", num);

   

    return 0;

}