SOLVED Bhaktapur Municipality SEE Preparation Exam 2080

 Bhaktapur Municipality SEE Preparation Exam 2080

Class: 10

F.M.: 50

Subject: Opt. Computer Science

Time: 1hrs 30min

(Group 'A')

Answer the following questions in one sentence:

 

What is an intranet?

An intranet is a private computer network that uses the internet protocol to securely share any part of information of an organization

 

What is cyber bullying?

Cyberbullying refers to harassment or bullying that takes place through electronic devices and digital platforms, such as the internet, social media, or messaging apps.

 

While designing table structure which data types are suitable to store information about student's name and date of birth?

Student’s Name uses text data type and date of birth uses Date/Time data type

 

What is the field size of Yes/No field?

The field size of Yes/No field is 1 bit.

 

What is local variable?

A variable which is defined in a module and is not accessible to any other modules and its value is destroyed when execution of module is over known as local variable

 

Write the format specifier of basic data types of C language.

The format specifier of basic data types of C language are int (%d), char(%c), float(%f) and double (%fd)

 

 

Write appropriate technical term for the following:

 

The ability to understand natural language and is capable of thinking and learning itself. Artificial Intelligence

Buying and selling of goods through internet. E-commerce

Write the full form of the following:

G2G – Government to Government

LIFI – Light Fidelity

 

(Group 'B')

Answer to the following questions:

 

Mention differences between client/server architecture and peer-to-peer architecture of the network.

Client/server network	Peer-to-peer network
There is a specific server and specific clients connected to the server	Clients and server are not distinguished; each node act as client and server
The client request for service and server respond with the service	Each node can request for services and can also provide the services
The data is stored in a centralized server	Each peer has its own data.
The client-server are expensive to implement.	Peer-to-peer are less expensive to implement.

 

What is password policy? Write any two important criteria for creating a strong password.

A set of rules designed to enhance computer security by encouraging user to employee strong passwords and use them properly is called password policy.

Any two important criteria for creating a strong password are:

Mix characters, numbers and symbols. Also, mix small and capital letters.

Don't use a sequence like abcd or 1234 which are, again, easily guessable

 

What is a backup? Why is backup vital to computer security systems?

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

Backup is vital to computer security system in order to recover the data from being lost or damaged due to accidental or intentional harm.

 

What is Online Payment? Write the different forms of e-payment in Nepal.

Online payment refers to the payment for buying goods or services through the Internet using different online payment gateway.

E.g. eSewa Nepal, iPay, Khalti, e-banking

Define antivirus software with two examples.

Antivirus software is software designed to detect and remove virus from computer system and ensures virus free environment.

E.g. Kaspersky, NAV, MSAV, McAfee, NOD 32 etc

 

Differentiate between database and DBMS with example.

Database	DBMS
A collection of systematically organized inter-related data is called a database. The purpose of data base is to store, organize and retrieve data.	DBMS is a computerized system that stores data, processes them and provides information in an organized form.
E.g. Dictionary, Marks Ledger, Telephone Directory, Attendance Register etc	E.g. MS-Access, Oracle,  MySQL, Fox Pro etc

 

What is data sorting? Write the advantages of the sorted data.

The process of arranging all the records in a table either ascending or descending order based on field or fields is known as sorting.

The advantages of the sorted data are:

Sorting helps to organize data and make it easier to find and retrieve specific information.

Sorting can save time and improve efficiency by allowing users to quickly access the data they need

 

Write two differences between Select query and Action query.

Select query	Action query
A select query is the most common category and is used for extracting specific information from one or more tables in a database. It cannot make changes in tables	Action query is a query which makes changes to many records in just one operation
We use select query to group records and perform calculations on field values in the groups such as sum, count, average, minimum and maximum	We use action query to delete records, add records, and update records

 

List any two major differences between forms and reports.

Form	Report
Form is one of the MS-Access database objects which provides graphical interface to view, modify and add data in a table or multiple linked tables	Report is one of the MS-Access database objects used to present information in an effective and organized format that is ready for printing
Forms provide an easy-to-use interface for data entry and manipulation, improving data accuracy and completeness	Reports provide a formatted presentation of data that is easy to read and understand

 

Write the output of the given program: (Workout with a dry run)

 

DECLARE SUB SERIES ( )

CALL SERIES

END

 

SUB SERIES

X=1

FOR I=1 TO 4 STEP 1

PRINT X;

X=X+1

NEXT I

END SUB

 

Dry Run

X	I=1 TO 4	PRINT X;	X=X+1
1	1 to 4 yes	1	1+1=2
2	2 to 4 yes	2	2+1=3
3	3 to 4 yes	3	3+1=4
4	4 to 4 yes	4	4+1=5
	5 to 4 No Loop Exits

 

The output of a program is

1  2  3  4

Debug

Re- write the given program after correcting the bugs:

REM program to read data from the data file.

OPEN "STAFF.DAT" FOR OUTPUT AS #1

CLS

WHILE NOT EOF(#1)

WRITE #1, A$, B, C, D

PRINT A$, B, C, D

WEND

CLOSE "STAFF.DAT"

 

END

 

Debugged Program

REM program to read data from the data file.

OPEN "STAFF.DAT" FOR INPUT AS #1

CLS

WHILE NOT EOF(1)

INPUT #1, A$, B, C, D

PRINT A$, B, C, D

WEND

CLOSE #1

END

 

Study the following program and answer the given questions.

 

DECLARE FUNCTION TEXT$(A$)

CLS

INPUT "Enter any word"; T$

PRINT TEXT$(T$)

END

 

FUNCTION TEXTS(A$)

FOR I = LEN(A$) TO I STEP -1

B$=B$ + MID$(A$, I, 1)

NEXT I

TEXT$ = B$

END FUNCTION

List all the parameters used in the program given above.

Formal parameter is A$ and Actual Parameter is T$

 

List the variable used in the above program.

A$, T$, B$ and I are the variable used in the above program.

 

 

(Group 'C')

 

Convert/ Calculate as per the instruction:

 

i) (10111101), into Octal

 

Soln:

Converting Binary to octal

Binary value in four bits	010	111	101
Octal number	2	7	5

 

(10111101)₂ = (275)₁₆

 

ii) (4E6)16 = (?)8

Soln:

Converting hexadecimal to binary

4 = 0100

E = 1110

6 = 0110

=(010011100110)₂

Now, Converting Binary to octal

Binary value in four bits	010	011	100	110
Octal number	2	3	4	6

 

(4E6)16 = (2346)8

iii) ((10101-1110)2 × (10)2

	1	0	1	0	1
	-	1	1	1	0
			1	1	1
			×	1	0
			0	0	0
	+	1	1	1	×
		1	1	1	0

 

((10101-1110)2 × (10)2 = (1110)2

 

iv) (101110)2(1110)2 = (?)2

 

1110)	1	0	1	1	1	0	(11
	-	1	1	1	0
		1	0	0	1	0
		-	1	1	1	0
				1	0	0

 

Quotient = 11

Remainder = 100

 

Write a program in QBASIC that asks radius, and height of a cylinder and calculate its surface area and volume. Create a user- defined function to calculate surface area and sub program to calculate volume. [Hint: [V=pr2h, SA-2pr (h+r)]

 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

A sequential data file "Salary.dat" contains the information, employee-code, employee-name, post and basic salary. Write a program to display those records whose basic salary is greater than or equal to 15000 and post is "Officer". (४)

OPEN "Salary.dat " FOR INPUT AS #1

CLS

WHILE NOT EOF (1)

  INPUT #1, E, N$, P$, S

    IF UCASE$(P$) = “OFFICER” AND S>= 15000 THEN PRINT E, N$, P$, S

WEND

CLOSE #1

END

 

Write a program in C language to check whether the supplied number 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 7, 10, 13, 16........ up to 10.

#include <stdio.h>

int main()

{

    int  j, sum = 0, a=7;

    printf("The first 10 natural number is :\n");

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

    {

        sum = sum + a;

        printf("%d ",a);

        a=a+3;

    }

    printf("\nThe Sum is : %d\n", sum);

}