Computer Science (Optional
II)
SEE (New Model Question SOLVED)
|
Time: 1 hr 30 Min
|
Full Marks:50 |
Group 'A' (10 Marks)
1. Answer
the following questions in one sentence. [6×1=6]
a) What
is the Internet?
Ans:
The Internet is a global wide
area network that
connects computer systems across the world.
b) What
is browser?
Ans:
a browser is a software program to present and explore content
on the World Wide Web.
c) Which
is the logical data type of MS Access?
Ans:
Yes/No is the logical data type of MS Access.
d) Which
view is used to modify a table in MS Access?
Ans:
Design View is used to modify a table in MS Access.
e) What
is structure programming language?
Ans:
Structure programming is a approach in which the program is made as a single
structure. It means that the code will execute the instruction by instruction
one after the other.
f) Write
any two data types of C language.
Ans:
int, and float are data types used in C language.
2. Write
appropriate technical terms for the following: [2×1=2]
a. Crimes
committed using electronic devices and cyber space.
Ans:
Cyber crime
b. A
malicious program of computer that damages data and software.
Ans:
Computer virus
3. Write
the full forms of the following: [2×1=2]
a. UTP : Unshielded
Twisted Pair
b. WWW : World
Wide Web
Group 'B' (24 Marks)
4. Answer
the following questions. [9×2=18]
a) What
is computer network? Write any two disadvantages of it.
Ans:
Interconnections of two or more than two computers with the help of wire or
wireless is known as computer network.
Following
are the disadvantages of computer network.
i)
Lack of data security and privacy
ii)
Chances of spreading virus and malware.
b) What
is cyber ethics? Write any two cyber ethics.
Ans:
Cyber ethics is the study of moral legal and social issue involving cyber
technology
Following
are the following two cyber ethics.
i) Do
not access any data, systems or networks without authority or permission
ii)
Do not threaten, harass, stalk or abuse anyone.
c) What
is hardware security? Write the role of UPS in hardware security.
Ans:
Hardware security is the protection of physical devices from threats that would
facilitate unauthorized access to enterprise systems.
The
primary functions of UPS is to provide battery
backup when the electrical power fails or drops to an unacceptable voltage
level. It ensures that your electrical equipment gets a consistent current so
damage, such as database corruption can be avoided.
d) What
is e-banking? Write any two uses of it.
Ans:
Electronic Banking is simply the use of electronic and telecommunications
network for delivering various banking products and services. Through
e-banking, a customer can access his account and conduct many transactions
using his computer or mobile phone.
Following
are the uses of e-banking.
i)
Online bill payment
ii)
Easy to apply online loan.
Ans:
Cloud computing is the delivery of computing services including servers,
storage, databases, networking, software, analytics and intelligence over the
Internet.
Following
are the two cloud service provider.
i)
IBM cloud services
ii)
Microsoft Azure
f) What
is database management system? Give two examples.
Ans:
A database management system (DBMS) is a software package designed to define,
manipulate, retrieve and manage data in a database.
Examples:
MS-Access, Oracal, SQL, dBase etc.
g) Define
field and record.
Ans:
Field: A field is a
combination of one or more related characters or bytes and is the smallest unit
of data a user accesses.
Record:
A record is a group of related fields.
h) What
is report? Write its use.
Ans:
A database report is the formatted result of database queries and
contains useful data for decision-making and analysis.
Following
are the uses of report.
i)
Reports enable you to format your data in an attractive and informative layout
for printing or viewing on screen.
ii)
Reports are often used to present a big-picture overview, highlighting main
facts and trends.
i) Define
form. Write any two uses of it.
Ans:
Forms is a database object that you can use to enter, edit or display data from
a table or query.
Following
are the uses of form.
i) It
is used to data entry purpose.
ii)
We can use form to control access to data, such as which fields of data are
displayed.
DECLARE SUB OUTPUT1 (A)
CLS
N=135
CALL OUTPUT1(N)
END
SUB OUTPUT1(A)
DO WHILE A<>0
R= A MOD 10
T=T+R
A=A\10
LOOP
PRINT T
END SUB
Dry
Run
|
Variable n |
Variable a |
Condition DO WHILE a<>0? |
Variable r |
Variable t |
|
135 |
135 |
Is
135 <> 0? Yes |
R=
135 mod 10=5 |
T=0+5=5 |
|
135 |
A=135\10=13 |
Is
13 <> 0 ? Yes |
R=13
mod 10=3 |
T=5+3=8 |
|
135 |
A=13\10=1 |
Is
1<> 0? Yes |
R=1
mod 10=1 |
T=8+1=9 |
|
135 |
A=1\10=0 |
Is
0 <> 0? No Exit
from loop |
|
|
6. Re-write
the given program after correcting the bugs. [2]
REM to create a new data file
CLS
OPEN "ABC.DAT" FOR INPUT AS #1
DO
INPUT "Enter Name, Roll No and Total. "; N$,R,T
INPUT #1, N$, R,T
INPUT "Supply more records Y/N"; CS
LOOP WHILE UCASE$(Y$)="Y"
CLOSE #1
END
Debugged
program
REM to create a new data file
CLS
OPEN "ABC.DAT" FOR OUTPUT AS #1
DO
INPUT "Enter Name, Roll No and Total. "; N$,R,T
WRITE #1, N$, R,T
INPUT
"Supply more records Y/N"; C$
LOOP WHILE UCASE$(C$)="Y"
CLOSE #1
END
7. Study
the following program and answer the given questions. [2×1=2]
OPEN "EMP.DAT" FOR INPUT AS#1
DO
INPUT #1, N$, A$, S
IF
UCASE$(A$)="KATHMANDU" THEN
PRINT
N$, A$, S
END
IF
LOOP WHILE NOT EOF(1)
CLOSE #1
END
a) Write the use of statement "INPUT#1,
N$,A$,S" in the above program.
Ans: This statement is used to read the data
from the data file.
b) What happens if you remove
"UCASE$" from the above program.
Ans: If we remove he statement UCASE$ from
the above program the address "KATHMANDU" which are stored in capital letter are not
displayed on the screen.
Group 'C' (16 Marks)
8. Convert / Calculate as per the instruction. [4×1=4]
i) (ABC)16=(?)8
9.a)
Write a program in QBASIC that allows a
user to input length, breadth and height and then calculate the area of four
walls by using FUNCTION…END…FUNCTION. Hint: [A=2H(L+B)]
[4]
DECLARE FUNCTION area (l,
b, h)
CLS
INPUT "enter
length"; l
INPUT "enter
breadth"; b
INPUT "enter
height"; h
PRINT "Area of four
walls"; area(l, b, h)
END
FUNCTION area (l, b, h)
area = 2 * h * (l + b)
END FUNCTION
b) Write a program to create a sequential data file
named "employ.dat" to store Name, Post, Address and Salary for the
number of employees. The program should terminate on user's choice.
[4]
OPEN
“employ.dat” FOR OUTPUT AS #1
CLS
top:
INPUT
“enter name of employee”;n$
INPUT
“Enter address of employee$
INPUT
“Enter salary”;s
WRITE
#1, n$,a$,s
INPUT
“Do you need more records”;ch$
IF
UCASE$(ch$)= “Y” THEN GOTO top
CLOSE
#1
END
10.
Write a program in C language to input a number and then check whether the
number is positive or negative or zero. [4]
#include<stdio.h>
#include<conio.h>
main()
{
int n;
printf("enter any
number\n");
scanf("%d",&n);
if(n>0)
printf("positive");
if(n<0)
printf("Negative");
if(n==0)
printf("zero");
getch();
}
OR
Write
a program in C language to display the series 1,1,2,3,5,8 ... up to 10th terms.
[4]
#include<stdio.h>>
#include<conio.h>
main()
{
int x,a=1,b=1;
for(x=1;x<=5;x++)
{
printf("%d\t%d\t",a,b);
a=a+b;
b=a+b;
}
return 0;
}
Also Read: SEE solved question paper of computer science 2078(2022)
.png)
.png)
.png)
%202080%20(2024)%20Optional%20II%20Computer%20Science%20Solution.png)
.png)
No comments:
Post a Comment