SOLVED PABSON
SEE
PRE-QUALIFYING EXAM-2079
Subject:
Opt. II Computer
Full
Marks: 50
Candidates
are required to write their answers according to the Time: 1:30 Hrs.
instructions given.
Group
'A'
1.
Answer the following questions in one sentence. [6x1=6]
a)
Write two examples of bounded media.
Ans:
Any two examples of bounded media are Twisted Pair Cable and Fiber Optic Cable
b)
Write two methods for hardware security.
Ans:
Any two methods for hardware security are Insurance and Regular
maintenance of computer hardware.
c)
What is M-Commerce?
Ans:
The
online transactions through the wireless handheld devices such as mobile phone,
laptop, palmtop, tablet, or any other personal digital assistant is called
M-Commerce.
d)
List two examples of DBMS.
Ans:
Any two examples of DBMS are MS-Access and Oracle.
e)
What is modular programming in Q-Basic programming?
Ans:
Modular
programming is a technique that divides a program into many small, manageable,
logical and functional modules or blocks.
f)
What is C language?
Ans:
C language is a structured programming language that divides program into many
functions.
2.
Write the technical term for the following statements. [2x1=2]
a)
The fake attempt to obtain sensitive information such as username, password by
disguising oneself as a trustworthy entity. Phishing
b)
The technology to encode file or message. Encryption
3.
Write the Full Forms of the following: [2x1=2]
a)
URL - Uniform Resource Locator
b)
ADSL - Asymmetric Digital Subscriber Line
Group
'B' [9x2=18]
4.
Answer the following questions:
a)
"Computer network reduces the operation cost". Justify the statement.
Computer
Network reduces expenses of an office because computer on a network share
different hardware devices like printers, scanners, hard disk etc. And sharing
those hardware devices will reduces the expense of an office. For example if
there are twenty computers in an office, now for printing the data there is no
need to buy twenty printers individually rather than simple network the
computer and connect the printer on the network which helps in sharing of the
one printer among twenty computers which reduces the cost of buying nineteen
printers individually.
b)
What is computer security? Write two measures to protect it.
The
security given to the computer for the protection of hardware, software and
data from being lost or damaged due to accidental or intentional harm is known
as computer security.
Any
two measures to protect it are Insurance and Password.
c)
What is e-governance? Write any two advantages of e- governance,
The use of ICT and its application by the government for the
provision of information and public services to the people is called
e-governance.
Any two advantages of e-governance are :
a)
Speed - Electronic
technologies make communication better, and faster. It will take very less time
for any policy, or scheme to reach to the people.
b)
Transparency
- The use of e-governance helps make all functions of the
business transparent. All the information of each and every policy will
be directly available to the citizens.
d)
What is E-commerce? Write any two advantages of it.
Ecommerce
refers to the buying and selling of goods or services using the internet.
Any
two advantages of it are:
a)
It makes buying/selling possible 24/7.
b)
It makes buying selling procedure faster,
as well as easy to find products.
e).
How does IOT help in our daily life? Explain.
With
the use of IOT, accessing information is easy; we can control a device that is
miles apart in real time. Communication between the connected devices becomes
more transparent and easier.
There
are smartwatches and many other wearables that monitor our health
conditions on a real-time basis. So if some medical urgency is needed such
devices can initiate the necessary actions like alerting the family members,
calling an ambulance, etc.
f)
List any four data types of MS-Access. Also mention its function.
Any four data types of MS-Access
are:
i) Text - It
is used for storing text or combination of text and numbers. It can store up to 255 characters.
ii) Date/Time – Stores date and time
iii) Memo - It is used for storing lengthy text and numbers. It can store up to
65,535 characters.
iv) AutoNumber - Unique value generated by Access for each new record.
g)
Define field and record in database.
Record is a collection of
multiple related fields in a row which gives complete information about a
person or thing. E.g.: Ram Chabahil 4468790
A
column in a table is called field, and it contains a specific piece of
information within a record. E.g.: Name, Address, Telephone
h)
What is primary key? Write its importance.
A
key that uniquely identifies each record in a database is primary key.
Its
importance are:
To
reduce and control duplication of record in a table.
iTo set the relationship between tables.
i)
What is query in MS-Access? List different types of query in MS-Access.
Query is an object of Ms-Access
which extracts and arranges information from a table in a manner that is
specified.
The different types of query are:
i) Select query
ii) Action query
In action query, we have update query, append query, delete query and
make-table query.
5.
Write the output of the given program showing the dry table. [2]
DECLARE
SUB series()
CLS
CALL
series
END
SUB
series()
A=11111
C=5
WHILE
C>=1
PRINT
A;
A=A\10
C=C-1
WEND
END
SUB
Dry
Run
|
Variable |
Variable |
Condition Check |
Output |
|
A |
C |
C>=1 |
|
|
11111 |
5 |
5>=1 Yes |
11111 1111 111 11 1 |
|
1111 |
4 |
4>=1 Yes |
|
|
111 |
3 |
3>=1 Yes |
|
|
11 |
2 |
2>=1 Yes |
|
|
1 |
1 |
1>=1 Yes |
|
|
0 |
0 |
0>=1 No Loop Exits |
|
Output
11111 1111
111 11 1
6.
Debug the following program.
REM
to store name, address in the file "store.dat"
CLS
OPEN
"store.dat" FOR INPUT AS #1
DO
INPUT
"Enter name"; name$
INPUT
"Enter address"; address
WRITE
name$, address$
INPUT
"do you want to continue"; ans$
LOOP
WHILE UCASE$(ans$)="Y"
CLOSE
#2
END
Debugged
program.
REM
to store name, address in the file "store.dat"
CLS
OPEN
"store.dat" FOR OUTPUT AS #1
DO
INPUT
"Enter name"; name$
INPUT
"Enter address"; address$
WRITE
#1, name$, address$
INPUT
"do you want to continue"; ans$
LOOP
WHILE UCASE$(ans$)="Y"
CLOSE
#1
END
7.
Read the following program and answer the given questions: [2]
DECLARE
SUB string(x$)
CLS
X$=“COMPUTER"
CALL
string(X$)
END
SUB
string(x$)
L=LEN(X$)
FOR
A = L to 1 step -2
PRINT
MID$(x$.A,1);
NEXT
A
END
SUB
Questions:
a)
What is the value of L in the above program?
Ans:
The value of L in the above program is 8.
b)
List the numeric and string variable in the above program.
Ans:
Numeric variable = L, A
String
Variable = X$,
Group
C
8.
Convert the following as indicated. [4x1=4]
i)
(CAB)16 into binary
ii)
(767)8 into decimal
i)
(1110111)2 + (1011)2-(11)2
iv) (10111101)2 ÷(101)
9.
Answer the following questions: [4x2=8]
a)
Write a program to calculate total surface area of a cylinder using function
procedure and volume using sub procedure. [Hint: Total surface area-2 pr(h+r), Volume=pr2h] [4]
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)
A sequential data file "employee.dat" contains name, address, age and
salary of employees. WAP to display all the information whose address is
'Kathmandu' and salary is greater than 50000. [4]
OPEN
"employee.dat" FOR INPUT As #1
CLS
WHILE
NOT EOF(1)
INPUT #1, N$, A$, AG, S
If UCASE$(A$) = "KATHMANDU" AND S
> 50000 THEN
PRINT N$, A$, AG, S
END IF
WEND
CLOSE
#1
END
10.
Write a program in C programming to find the reverse of an input number. [4]
#include
<stdio.h>
int
main()
{
int n, s = 0, r;
printf("Enter any number: ");
scanf("%d", &n);
while (n != 0)
{
r = n % 10;
s = s * 10 + r;
n /= 10;
}
printf("Reversed number = %d", s);
return 0;
}
OR
Write
a C program to input three different numbers and check whether the input number
is positive, negative or zero. [4]
#include
<stdio.h>
int
main()
{
int n;
printf("Enter any number: ");
scanf("%d", &n);
if(n > 0)
printf("Number is POSITIVE");
else if(n < 0)
printf("Number is NEGATIVE");
else
printf("Number is ZERO");
return 0;
}
|
|
|
