SEE (Grade Increment) 2080 (202) [SOLVED] SEE COMPUTER SCIENCE

 

SEE (Grade Increment) 2080 (2024) [SOLVED]

GI-3031

Opt. II Computer Science

 

Group 'A'

1. Answer the following questions in one sentence:

 a. Give the name of any two unguided transmission media

Ans: Microwave and Radio wave

 

b. Write any two benefits of e-governance service.

Ans: Any two benefits of e-governance service are:

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

·       E-governance systems promote transparency by making government actions and decisions visible to the public. 

 

c. Which type of query do you use to calculate the total marks of students from table in MS Access?

Ans: Select Query is used to calculate the total marks of students from table in MS Access

 

d. What is the maximum length of the field name in MS-Access?

Ans: The maximum length of the field name in MS-Access is 64 characters.

 

e. List the different types of procedures in Qbasic.

Ans: Sub Procedure and Function Procedure

 

f. Which format specifier do you use in C language for 'int' data type ?

Ans: %d format specifier is used in C language for 'int' data type.

 

2. Write appropriate technical term for the following:

a. Digital trails created while using internet. Digital Footprint

b. Data transmission in only one direction. Simplex Mode

 

3. Write the full form of the following:

(1) NIC – Network Interface Card

ii) OTP – One Time Password

 

4. Answer the following questions:

 

a) Define Bus topology? Write any two advantages of Bus topology

Ans: The type of topology in which all nodes and network devices are connected to single cable is called bus topology.

Any two advantages of Bus topology are:

l It is cost effective and cable required is least compared to other network topology.

l It is used in small networks and easy to expand networks.

 

b) What is cyber ethics? Write any two commandments for using computer.

Cyber ethics is a set of moral principles or code of conducts that regulate the use of computers systematically without making harm to other users.

Any two commandments for using computer are:

v Do not use a computer to publish fake information.

v Do not search the file or record of other people.

 

 

 

 

 

c) What is Backup? How it helps to secure data?

Backup is the system of copying data and programs into another location or creating a duplicate copy of it in a secured place.

A backup secures data by creating a duplicate copy stored separately from the original, protecting against data loss due to hardware failure, accidental deletion, cyber threats, and disasters. It ensures data can be restored if the original is compromised, maintaining data integrity and availability for recovery.

 

d)  Define e-commerce? Write any two names of Nepali e-commerce sites.

E-Commerce refers to electronic transactions such as buying, selling and exchanging of goods, services and information over computer communication network such as the Internet.

Any two names of Nepali e-commerce sites are daraz and hamrobazar.

 

e) What is social media? Write any one reason why it is popular now days.

Social media are online platforms like Facebook, Twitter, and Instagram that let users create, share, and interact with content while connecting with others.

It's popular now a days because it enables instant communication, allowing people to connect and share information globally in real-time.

 

f) Define DBMS with any two examples of it.

DBMS is a computerized system that stores data, processes them and provides information in an organized form.

Any two examples of DBMS are : MS-Access and Oracle

 

g) What is primary key? List any two advantages of it.

A primary key is a field or combination of fields in a table that uniquely identifies each record, and is used to establish relationships between tables and enforce data integrity.

Any two advantages of it are:

It sets the relationship between tables.

It reduces and controls duplication of record in a table.

 

h) What is query? List two types of it.

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.

The types of query are: Select Query and Action Query

 

i) Define report and mention any two uses of it.

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

Any two uses of report are:

·       Reports provide a formatted presentation of data that is easy to read and understand.

·       Reports enable users to summarize, analyze, and visualize data in meaningful ways.

 

5. Write down the output of the given program and show them in dry run table.

DECLARE FUNCTION Series (N)

CLS

A=2

PRINT "Sum of the series"; Series (A)

END

 

FUNCTION Series (N)

Sum=0

FOR J = 1 TO 4

Sum=Sum + N

N=N+3

NEXT J

Series= Sum

END FUNCTION

Dry Run

A	PRINT "Sum of the series"; Series (A)	N	FOR J = 1 TO 4	Sum=Sum + N	N-N+3	Series = Sum
2		2	1 TO 4 Yes	0+2=2	2+3=5
		5	2 TO 4 Yes	2+5=7	5+3=8
		8	3 TO 4 Yes	7+8=15	8+3=11
		11	4 To 4 Yes	15+11=26	11+3-=14
		14	5 To 4 No Loop Exits			26

 

The output of the program is:

Sum of the series 26

 

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

REM to display name, post and salary of 10 employees

OPEN "EMP.TXT" FOR IN AS #1

FOR I=10 TO 1

INPUT #1, Name$, Post$, Salary

DISPLAY Name$, Post$, Salary

NEXT I

CLOSE “EMP.TXT”

END

 

Corrected Program:

REM to display name, post and salary of 10 employees

OPEN "EMP.TXT" FOR INPUT AS #1

FOR I=1 TO 1 0

INPUT #1, Name$, Post$, Salary

PRINT Name$, Post$, Salary

NEXT I

CLOSE #1

END

 

7. Study the following program and answer the given questions:

DECLARE SUB SEE (A$)

A$="COMPUTER SCIENCE”

END

 

SUB SEE (A$)

L=LEN(A$)

FOR I=L TO 1 STEP-2

PRINT MID$ (A$, I, 1)

NEXT I

END SUB

a) Which statement should be added in the main module to execute the program?

Ans: CALL SEE(A$) should be added in the main module to execute the program

b) List out the variables used in the above program.

Ans: The variables used in the above program are: A$, L and I .

7. Convert/Calculate as per the instruction:

i) (10011011)₂ = (?)₈

 

Convert every 3 binary digits (from bit0) to octal digit (see conversion table below):

10011011

10 = 2

011 = 3

011 = 3

= 2 3 3

= (10011011)₂ = (233)₈

 

ii) (99)₁₀ = (?)₁₆

 

Divide by the base 16 to get the digits from the remainders:

Division by 16	Quotient	Remainder (Digit)
(99)/16	6	3
(6)/16	0	6

= (63)₁₆

(99)₁₀ = (63)₁₆

 

iii) (10110) ₂ x (101)2 = (?)₂

 

			1	0	1	1	0
				x	1	0	1
			1	0	1	1	0
		0	0	0	0	0	x
	1	0	1	1	0	x	x
	1	1	0	1	1	1	0

 

10110 × 101 = 01101110

 

iv) (101101)₂ / (11) ₂

 

11)	1	0	1	1	0	1	(1111
	-	1	1
		1	0	1
			1	1
			1	0	0
				1	1
					1	1
					1	1
					0	0

 

Q = 1111

R = 0

 

9. a)  Write a program in QBASIC that asks radius and height of a cylinder Create a User Defined Function to calculate total surface area and a Sub Program to calculate the volume of a cylinder.

[Hint: TSA=2pr (r+h) and Volume pr²h]

 DECLARE FUNCTION AREA(R, H)

DECLARE SUB VOL(R,H)

Cls

INPUT "Enter radius"; R

INPUT "Enter height"; H

PRINT AREA(R, H)

Call VOL(R, H)

END

 

FUNCTION AREA (R, H)

    AREA = 2 * 3.14 * R * (R + H)

END FUNCTION

 SUB VOL (R, H)

    V = 3.14 * R ^ 2 * H

    PRINT "Volume of cylinder"; V

END SUB

 b) Write a program to create a sequential data file "student.dat" to store 10 students name and obtain marks in four different subjects.

 

OPEN "student.dat" FOR OUTPUT AS #1

FOR I = 1 TO 10
INPUT "Enter Name"; N$
INPUT “Enter Marks in English”; E

INPUT “Enter Marks in Nepali”; NE

INPUT “Enter Marks in Maths”; M

INPUT “Enter Marks in Science”; S

WRITE #1, N$, E, NE, M, S

NEXT I
CLOSE #1
END

 

10. Write a program in C language that asks for an integer value and checks whether it is divisible by 7 or not.

#include<stdio.h>

#include<conio.h>

int main()

{

int n;

printf("Enter any number: ");

scanf("%d", &n);

if(n%7==0)

printf("%d is divisible by 7",n);

else

printf("%d is not divisible by 7",n);

return 0;

}

OR

 Write a program in C language to display the series with their sum 1, 4, 9, 16.... up to 10th term.

#include <stdio.h>

int main() {

    int i, t, s = 0;

    printf("Series: ");

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

        t = i * i; 

        printf("%d ", t);

        s += t; 

    }

    printf("\nSum of the series: %d\n", s);

    return 0;

}

 

***