SEE New Model Computer Science Questions 2077

Computer Science

SEE  Model Question

Time: 1 hr 30 min

F.M. : 50

Group ‘A’ (10 Marks)

 

1.     Answer the following questions in one sentence.          [6×1=6]

 

a.     What is search engine?

A search engine is a software program or script available through the Internet that searches documents and files for keywords and returns the results of any files containing those keywords.

 

b.     What is the business done through internet?

The business done through internet is e-commerce.

 

c.      Which data type is used to store alpha numeric characters or special symbols in MS-Access?

Text data type is used to store alpha numeric characters or special symbols in MS-Access.

 

d.     Which view is used to modify a table in MS-Access?

Design view is used to modify a table in MS-Access

 

e.     What is modular programming?

Modular programming is a technique used to divide program into many small, manageable, logical and functional modules or blocks.

 

f.      Write any two features of C language.

Any two features of C language are:

v It is easy to learn and implemented C language

v Occupies less memory

 

 

2.     Write appropriate technical terms for the following:   [2×1=2]

a.      Law that governs the legal issues of cyberspace.

Cyber Law

b.     The smallest unit to represent information on a quantum computer.

Qubit (Quantum bit)

 

3.     Write the full forms of the following:                            [2×1=2]

a.      STP: Shielded Twisted Pair

b.     WAP: Wireless Application Protocol

 

Group ‘B’ [24 Marks]

 

4.     Answer the following questions.                                     [9×2=18]

 

a.     What is computer network? Enlist any two advantages of it.

A computer network means two or more computers connected with each other to share data, hardware, software and other resources.

Any two advantages of computer network are:

a)     Computer in a network can access the network-connected hardware devices like printers, disk drives, etc.

b)     Data in a network environment can be updated from any computer. Updated data can be accessed by all computers on the network.

 

 

 

b.     What is computer ethics? Write any two of them.

Cyber ethics can be defined as to follow the rules and regulation of computer technology and not to harm other computer users knowingly or unknowingly.

Any two cyber ethics are:

                           i.          You should not spread false and illegal information.

                         ii.          You should not destroy, erase or edit personal or group records.

 

c.      What is software security? Write any two measures of hardware security.

The security given to the machine and peripheral hardware from theft and from electronic intrusion (interruption) and damage is called software security.

Any two measures of hardware security are:

v Insurance

v Power Protection Device

 

d.     What is m-commerce? Write any two important services.

The online transactions through the wireless handheld devices such as mobile phone, laptop, palmtop, tablet, or any other personal digital assistant are called m-commerce.

Any two important services are:

v Buy and sell goods and services

v Access emails

 

e.     What is IoT? Write any two importance of it.

IoT is a technology that connects all electronic devices together and prompts them to exchange information without any human intervention.

Any two important of IoT are:

a)     Communication between the connected devices becomes more transparent and easier.

b)     Transferring data packets over a network reduces both time and money.

 

f.      What is database? Give any two examples.

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. E.g. Dictionary and Telephone Directory.

 

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

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

Any two advantages of primary key are:

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

 

h.     What is data sorting? List any two advantages of using it.

Sorting is the process of arranging the record in ascending or descending order according to a given field or fields.

Any two advantages of sorting are:

i) It helps to find specific information quickly.
ii) It helps to arrange data in alphabetical order.

 

i.       What type of work is done in MS-Access using form and query object.

Form is an object of Ms-Access which provides graphical interface to enter data into the tables or multiple linked tables.

Query is an object of Ms-Access which extracts and arranges information from a table in a manner that is specified.

 

5.     5.     Write the output of the given program: Show with dry run in table.                     [2]

DECLARE SUB SHOW(A)

CLS

N=87

CALL SHOW(N)

END

 

SUB SHOW(A)

DO

B=A MOD 6+3

IF B MOD 4=0 THEN GOTO AA

PRINT B;

AA:

A=A-10

LOOP WHILE A>=50

END SUB

 

Dry run table

N	A	B=A MOD 6 + 3	IS B MOD 4=0 ?	PRINT B	A=A-10	WHILE A>=50
87	87	87 MOD 6 + 3 =3 + 3 = 6	6 MOD 4=0 ? 2 = 0 No	6	87-10=77	77>=50 YES
	77	77 MOD 6 + 3 5+3=8	8 MOD 4=0? 0=0 YES		77-10=67	67>=50 YES
	67	67 MOD 6+3 1+3=4	4 MOD 4=0? 0=0 YES		67-10=57	57>=50 YES
	57	57 MOD 6+3 3+3=6	6 MOD 4=0? 2=0 NO	6	57-10=47	47>=50 NO Loop Exits
	47

 

The output of the program is:

6   6

 

6.     Re-write the given program after correcting the bugs:                             [2]

REM to add record in an existing file

CLS

OPEN “Record.Dat” FOR OUTPUT AS #1

AA:

INPUT “Enter Name, Class and Roll No.”; Nm$, Cl, Rn

INPUT #2, Nm$, Cl, Rn

INPUT “More records”; Y$

IF UCASE$(Y$)=”Y” THEN GOTO aa

CLOSE “Record.dat”

END

 

Debugged program:

REM to add record in an existing file

CLS

OPEN “Record.Dat” FOR APPEND AS #1

AA:

INPUT “Enter Name, Class and Roll No.”; Nm$, Cl, Rn

WRITE #1, Nm$, Cl, Rn

INPUT “More records”; Y$

IF UCASE$(Y$)=”Y” THEN GOTO AA

CLOSE #1

END

7.     Study the following program and answer the given questions.                   [2×1=2]

OPEN “Detail.dat” FOR INPUT AS #1

OPEN “Temp.dat” FOR OUTPUT AS #2

INPUT “Enter name of the students”; S$

FOR I=1 TO 10

INPUT #1, Nm$, Cl, A

IF S$< >Nm$ THEN

WRITE #2, Nm$, Cl, A

END IF

NEXT I

CLOSE #1, #2

KILL “Detail.dat”

NAME “Temp.dat” AS “Detail.dat”

END

a.     What is the main objective of the program given above?

The main objective of the program given above is to delete the record according to the entered name.

b.     Do you get any problem in the above program if “Kill” statement is removed? Give reason.

Yes, the program will display the error message and it won’t delete the record.

8.     Convert / Calculate as per the instruction.                                                  [4×1=4]

a.      (11001101)₂ = (?)₁₆

Soln:

Converting Binary to octal

Binary value in four bits	1100	1101
Octal number	C	D

 

(11001101)₂ = (CD)₁₆

 

b.     (524)₁₀ = (?)₂

Soln:

		Remainder
2	524
2	262	0
2	131	0
2	65	1
2	32	1
2	16	0
2	8	0
2	4	0
2	2	0
2	1	0
2	0	1

 

(524)₁₀ = (1000001100)₂

 

a.      (1010)₂ × (110)₂ – (1011)₂ = (?)₂

 

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

 

(1010)₂ × (110)₂ – (1011)₂ = (110001)₂

 

 

 

a.      (10110)₂ ¸ (101)₂

101)	1	0	1	1	0(	100
	-1	0	1
	0	0	0	1	0
					-0
				1	0

 

Quotient=100

Remainder=10

 

 

9.     a. Write a program in QBASIC that asks length, breadth and height of room and calculate its area and volume. Create a user defined function to calculate area and sub-program to calculate volume. Hint: [A=L×B], [V=L×B×H]

 

DECLARE FUNCTION AREA(L,B)

DECLARE SUB VOL(L,B,H)

CLS
INPUT “Enter Length”; L

INPUT “Enter Breadth”; B

INPUT “Enter Height”; H

PRINT “Area of room=”; AREA(L,B)

CALL VOL(L,B,H)

END

 

FUNCTION AREA(L,B)

AREA = L * B

END FUNCTION

 

SUB VOL(L,B,H)

V=L*B*H

PRINT “Volume of Room=”; V

END SUB

 

b. A sequential data file called “Record.txt” has stored data under the field heading Roll No., Name, Gender, English, Nepali, Maths and Computer. Write a program to display all the information of those students whose gender is “F” and obtained marks in computer is more than 90.

 

OPEN “Record.txt” FOR INPUT AS #1

CLS

WHILE NOT EOF(1)

INPUT #1, R, N$, G$, E, N, M, C

IF UCASE$(G$)=”F” AND C>=90 THEN

PRINT R; N$; G$; E; N; M; C

END IF

WEND

CLOSE #1

END

 

10.  Write a program in C language that asks a number and check whether it is odd or even.

 

#include<stdio.h>

#include<conio.h>

int main()

{

int n;

printf("Enter any number: ");

scanf("%d", &n);

if(n%2==0)

printf("%d is even number", n);

else

printf("%d is odd number", n);

return 0;

}

 

 

OR

 

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

#include<stdio.h>

#include<conio.h>

int main()

{

int i, s=0;

i=1;

while(i<=5)

{

    printf("%d \n", i);

    s = s + i;

    i++;

}

print("%d \n Sum=", s);

return 0;

}

 

 

***