Solved SEE 2079 Computer Science

  

Solved SEE 2079 Computer Science

SEE 2079

Opt II. [Computer Science]

1. Answer the following questions in one sentence.

a) What is network protocol?

Ans: A network protocol refers to a set of rules and standards that govern the communication between devices or computers on a network.

b) What is e-commerce?

Ans: E-commerce refers to the buying and selling of goods and services over the internet.

c) What is the default size of text field in MS-Access?

Ans: The default size of a text field is 50 characters in MS-Access.

d) Which data type is used to store photo in MS-Access?

Ans: The data type used to store photos is called an OLE Object data type.

e) What is looping?

Ans: Looping is a programming concept that allows a set of instructions to be repeated multiple times in a program.

f) List any two data types used in C-programming language.

Ans: Any two data types used in C-programming language are char and int.

2. Write appropriate technical term for the following:

a) A program that can disinfect a file from virus. Antivirus software.

b) Learning through the electronic media. E-Learning.

3. Write the full form of the following:

a) G2G – Government to Government

b) ISP – Internet Service Provider

4. Answer the following questions:

a) What is network topology? List any two types of network topology.

Ans: Network topology refers to the physical or logical layout of a computer network. Any two types of network topology are bus topology and star topology.

b) What is antivirus software? Name any two popular antivirus software.

Ans: Antivirus software is a type of program designed to detect, prevent, and remove malicious software (malware) from computers and other devices. Any two popular antivirus software are Kaspersky and Norton Antivirus.

c) Define cyber law and cyber crime.

Ans: Cyber law is a type of law that governs the use of the internet, computers, and related technologies. Cyber crime refers to criminal activities that are committed using computers or the internet.

d) Define virtual reality. Write any two areas where virtual reality is used.

Ans: Virtual reality is a technology that creates a computer-generated environment that users can experience and interact with using specialized hardware such as head-mounted displays. Any two areas where virtual reality is used are Gaming and Education and Training.

e) What is password? Write any two importance of password protection.

Ans: A password is a secret code that you use to verify your identity and access your accounts or devices. Any two importance of password protection are:

- to protect your passwords because it helps to keep your personal information and accounts safe from unauthorized access.

- to ensure security and privacy, as well as prevent hacking, identity theft, and other cybercrimes.

f) What is DBMS? Write four objects of MS-Access.

Ans: DBMS is a software system that helps users to store, retrieve, and manage data in an efficient and organized way. Any four objects of MS-Access are Table, Form, Query and Report.

g) What are validation text and validation rule?

Ans: Validation text is the message that appears when a user enters invalid data into a field. Validation rule is a condition that must be met in order for data to be accepted into a field.

h) What is form? Write any two advantages of it.

Ans: A form is an object of MS-Access which provides a graphical interface that allows users to interact with the data in a database. Any two advantages of form are:

- It provide a user-friendly interface for users to input and display data.

- It can include validation rules that help ensure that data entered into fields meets specific requirements.

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

Ans: A record refers to a collection of related data fields that are organized and stored together. A primary key is necessary in a database record because it helps to ensure the accuracy and integrity of data in a database by ensuring that each record is unique and identifiable.

5. Write down the output of the given program:

DECLARE SUB Series(A)

CLS
A=20

CALL Series(A)

END

SUB Series(A)

FOR K=1 to 5

PRINT A;

A=A+10

NEXT K

END SUB

Dry Run

Variable	Variable	Loop Check	Output
A	K	1 to 5	20 30 40 50 60
20	1	1 to 5 yes
30	2	2 to 5 yes
40	3	3 to 5 yes
50	4	4 to 5 yes
60	5	5 to 5 yes
70	6	6 to 5 no Loop exits

 Output

20 30 40 50 60

6. Re-Write the given program after correcting the bugs:

REM program to make a word reverse

DECLARE FUNCTION Rev$(N$)

CLS

LNPUT “Enter a word”; N$

DISPLAY “Reversed is”; Rev$(N$)

END

EUNCTION Rev$(N$)

FOR K=LEN$(N$) To 1 STEP-1

B$=B$+MID$(N$,1,K)

NEXT K

B$=Rev$

END FUNCTION

Debugged Program

REM program to make a word reverse

DECLARE FUNCTION Rev$(N$)

CLS

INPUT “Enter a word”; N$

PRINT “Reversed is”; Rev$(N$)

END

FUNCTION Rev$(N$)

FOR K=LEN (N$) To 1 STEP-1

B$=B$+MID$(N$,K,1)

NEXT K

Rev$=B$

END FUNCTION

Study the following program and answer the given questions:

DECLARE FUNCTION SUM(N)
CLS
INPUT “Enter any number”; N

X=SUM(N)

PRINT “The sum of individual digit is “; X

END

FUNCTION SUM(N)

WHILE N<>0

R=N MOD 10

S=S+R

N=INT(N/10)

WEND

SUM=S
END FUNCTION

a) Write the function of INT.

Ans: The INT function is used to round down a number to the nearest integer value.

b) How many times does the WHILE ….WEND loop repeat if the value of N is 123?

Ans: The WHILE ….WEND loop repeats 3 times if the value of N is 123.

8. Convert/Calculate as per the instruction:

a) (10110011)₂ – (?)₁₆

b) (410)₁₀ = (?)₂

c) (1001 + 110)₂ – (1000)₂

d) (10110)₂ ¸ (101)₂

9. a) Write a program in QBASIC that asks radius of a circle to calculate its area and circumference. Create a user defined function to calculate area and sub program to calculate circumference.

[Hint A= Pr², C= 2Pr]

b) A sequential data file called “Record.dat” has stored data under the field headings: Roll No., Name, Gender, English, Nepali, Maths and Computer. Write a program to display all the information of those students whose marks in English is more than 40.

c) Write a program in C language that asks any two numbers and displays the greatest among them.

Write a program in C-Langauge to display the series with their sum. 1,2,3,4….upto 10^th terms.