.png)
PABSON, Lalitpur
SEE PRE-QUALIFYING
EXAMINATION-2080
Subject-Opt. II.
Computer Science
Full Marks: 50
Time:
2 hrs
Candidates
are required to write their answers according to the instructions given.
Attempt
all questions
Group
A [10 Marks]
1.
Answer the following questions in one sentence:
a)
What is mail server?
Ans:
A mail server is a computer system that is
dedicated to handling and managing the sending, receiving, and storage of
emails.
b)
Why do you connect your PC to the UPS?
Ans:
We connect PC to the UPS to control
fluctuation of electric voltage and provides enough backup electric power to
the computer system when there is power failure.
c)
What is AI?
Ans:
Artificial intelligence refers to
the simulation of human intelligence in machines that are programmed to think
and act like humans.
d)
Which object of DBMS is used to print information?
Ans:
The object of DBMS which is used to print information is report.
c)
List the types of procedures.
Ans:
The types of procedure are SUB Procedure and FUNCTION Procedure.
f)
Write a feature of C language.
Ans:
A feature is C language is it is mostly used to prepare system software.
2.
Write the technical term for the following statements:
a)
Device to convert analog signal into digital signal and, vice versa. MODEM
b)
Making data and information unreadable by unauthorized person. Encryption
3.
Write the full forms of the following:
a)
UPS - Uninterruptible Power Supply
b)
SMTP - Simple Mail Transfer Protocol
Group B
4.
Answer the following questions:
a)
What is communication channel? Mention its types with at least one example, each
Ans:
A channel or path through which data and information are
transmitted between connected devices in a network environment are called
communication channel.
Its types are:
Guided (Wired/bounded) communication media - Twisted Pair
Cable, Co-Axial Cable and Fiber Optic Cable
Unguided (Wireless/unbounded) communication media - radio wave,
microwave, satellite, infrared
b)
What is cyber-crime? List any two objectives of formulating cyber law in Nepal.
Ans:
Cybercrime refers to criminal activities or illegal actions that are conducted
or facilitated through the use of digital technology or the internet.
Any
two objectives of formulating cyber law in Nepal are :
-
To legalize the transaction through electronic media to control various types
of electronic frauds
-
To punish a person who does criminal activities through electronic means
especially on computers.
c)
Mention any four hardware security measures.
Ans:
Any four hardware security measures are :
a)
Regular
Maintenance
b)
Insurance
c)
Air
condition system
d)
Power
Protection device (Volt guard, Spike guard, UPS)
d)
What is e-commerce? Write its two limitations.
Ans:
E-commerce refers to the buying and selling of goods or
services using the internet.
Any
two limitations of e-commerce are:
Need to be careful about the quality of
product and service delivery.
We cannot do any
transaction without Internet access device.
e)
List the types of E-governance. Describe any one of them.
Ans:
The types of E-governance are:
· Government-to-Citizen(G2C)
· Government-to-business (G2B)
· Government-to-Government (G2G)
· Government-to-Employee (G2E)
Government-to-Citizen(G2C)
G2C-is transaction
between the government to citizens. It includes online registration of birth/
death/marriage certificates, filling of income taxes, electricity bills,
license renewals etc.
f)
What is DBMS? Write its two advantages.
Ans:
DBMS is a software that manages databases, allowing users to store, access, and
manipulate data in an organized and secure way.
Any
two advantages are:
It controls data redundancy which means
duplication of data.
It provides high security of data as well
as maintains accurate database
g)
Write a similarity and a difference between Number field type and Currency
filed type.
Ans:
similarity
and a difference between Number field type and Currency field type
Similarity:
Both store numerical
values: Both field types are designed to store numerical data.
Difference:
Currency
field type is specialized for handling monetary values by including specific
currency formats and precision, whereas the Number field type is more generic
and can store any numerical data without currency-specific formatting.
h)
What is primary key? Write two examples of primary key fields.
Ans:
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 examples of primary key fields are SEE Registration number, Username
i)
Why is query object used in MS-Access? Give two reasons.
Ans: Any two reasons
to use query object in MS-Access are:
Queries enable users to retrieve
specific data from tables or other data sources, based on specified criteria.
Queries
allow users to filter, sort, and group data in meaningful ways.
5.
Write the output of the given program showing the dry run table. (2)
DECLARE FUNCTION PRO(N)
CLS
A=2
FOR J=1 TO 5
X= PRO(A)
PRINT X
NEXT J
END
FUNCTION PRO(N)
N=N+2
PRO=N
END FUNCTION
Dry Run
|
A |
J=1
to 5 |
X |
N |
N=N+2 |
PRINT
X |
|
2 |
1 |
4 |
2 |
2+2=4 |
4 |
|
|
2 |
6 |
4 |
4+2=6 |
6 |
|
|
3 |
8 |
6 |
6+2=8 |
8 |
|
|
4 |
10 |
8 |
8+2=10 |
10 |
|
|
5 |
121 |
10 |
10+2=12 |
12 |
|
|
6
loop exits |
|
|
|
|
Output
of the program is
4
6
8
10
12
6.
Debug the following program
Rem
to add 5 records in data file HOSPITAL.TXT
OPEN
"HOSPITAL.TXT" FOR INPUT AS #5
FOR REP = 1 TO 5
INPUT "ENTER
PATIENT NAME":PN$
INPUT "ENTER
PATIENT ADDRESS":AD$
INPUT "ENTER
PATIENT AGE": A%
INPUT "ENTER
PATIENT GENDER":G$
STORE #5, PN$,AD$,A, G$
NEXT REP
CLOSE
#1
END
Debugged
Program
Rem
to add 5 records in data file HOSPITAL.TXT
OPEN
"HOSPITAL.TXT" FOR APPEND AS #5
FOR REP = 1 TO 5
INPUT "ENTER
PATIENT NAME":PN$
INPUT "ENTER
PATIENT ADDRESS":AD$
INPUT "ENTER
PATIENT AGE": A%
INPUT "ENTER
PATIENT GENDER":G$
WRITE #5, PN$,AD$,A%,
G$
NEXT REP
CLOSE
#1
END
7.
Read the following program and answer the given questions.
DECLARE
SUB AA (N$)
W$=CYBERCRIME"
CALL
AA(W$)
END
SUB
AA (N$)
R=LEN(N$)
\ 2
E$=RIGHT$(N$,R)
+ LEFT$(N$,R)
PRINT
E$
END
SUB
Questions:
a)
List the parameter(s) and argument(s) of the program.
Ans:
The parameter used in above program is N$ and argument used in above program is
W$.
b)
List all the string library functions from the program.
Ans:
The string library functions used from the program are LEN ( ), RIGHT$( ),
LEFT$( ).
8.
Convert/Calculate as per the instruction:
a)
(11100001)2 = (?)8
b)
(A2B)16 = (?)2
c)
(101) X (111)
d)
(110110)¸(110)
Group
C
9.
a. Write a program in QBASIC to define a function procedure to display the area
of sphere and sub procedure to display the volume of sphere where user need to
input radius in main module.
[Hint:
Area = 4*3.14*R^2, Volume = 4/3*3.14*R^3]
DECLARE SUB AREA (R)
DECLARE FUNCTION VOL(R)
CLS
INPUT “Enter Radius”; R
CALL AREA(R)
PRINT “Volume of sphere=”; VOL(R)
END
SUB AREA(R)
A=4*3.14*R^2
PRINT “Area of sphere=”; A
END SUB
FUNCTION VOL(R)
VOL=4/3*3.14*R^3
END FUNCTION
b.
A sequential data file 'PRODUCT.DAT contains the information regarding product
Id, Product name, Date of manufacturing and Price of some products. Write a
program to display all the records deducting the price by 20%, where price is
greater than or equal to Rs.1000. [4]
OPEN
“PRODUCT.DAT” FOR INPUT AS #1
CLS
WHILE
NOT EOF(1)
INPUT
#1, I, N$, D$, P
IF
P>=1000 THEN P=P-20/100*P
PRINT
I, N$, D$, P
WEND
CLOSE
#1
END
10.
Write a program using C language to input an integer then check whether the
integer is even or odd.
#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;
}
Write
a program using C language to generate the first 25 even numbers between 100
and 200.
#include
<stdio.h>
int
main() {
int i, count = 0;
printf("The first 25 even numbers
between 100 and 200 are:\n");
for (i = 100; count < 25; i += 2) {
printf("%d ", i);
count++;
}
printf("\n");
return 0;
}
