SOLVED National PABSON Kathmandu SEE PRE-QUALIFYING EXAMINATION-2080
Sub-Computer Science
Group A
(10 Marks)
1. Answer the following questions in One sentence:
a) What is
web server?
Ans: A web server is a computer that serves requested
HTML web pages, files or data to users or client computers over the internet or
local network.
b) List out
any two applications of internet.
Ans: Any two applications of internet are E-mail and
E-Commerce
c) What is
the extension of MS-Access 2007?
Ans: The extension of MS-Access 2007 is .accdb.
d) What is
report in MS-Access?
Ans: Report is an
object of Ms-Access which is used to present information in an effective and
organized format that is ready for printing.
e) What is
Modular programming?
Ans: Modular programming is a technique
used to divide program into many small, manageable, logical and functional
modules or blocks.
f) Write
down any two data type used in C-programming?
Ans: Any two data type used in C-programming are int
and char.
2. Write appropriate technical term for the following 2×1=2
a
Private networks that allow organizations to share information and resources
among the internal users.
Intranet
b.
The process of arranging the fragmented file in computer. Defragmentation
3. Write the full form of the following 2×1=2
a
FTP – File Transfer Protocol
b.
IoT – Internet of Things
Group B
(24 Marks)
4. Answer the following questions: 9×2-18
a. What is network topology? Write down the advantages of BUS
topology
Ans:
Network topology is the cabling structure of interconnected computers in LAN.
Advantages
of bus topology are:
It is cost effective and cable required is
least compared to other network topology.
It is easy to expand network.
b. What is cyber-crime? Explain with example.
Ans:
Cybercrime refers to criminal activities or illegal actions that are conducted
or facilitated through the use of digital technology or the internet.
Eg.
Hacking. Computer hacking means stealing and destroying other data,
information, files and program.
c. How password policy protects computer software and data? Explain
Ans: Password secures the data by
protecting the data from unauthorized access. By
implementing and enforcing a robust password policy, organizations and software
systems can significantly reduce the risk of unauthorized access, data
breaches, and cyberattacks. It's an essential element in safeguarding sensitive
information and maintaining the security and integrity of computer software and
data.
d. Write down the advantages and disadvantages of e- commerce.
Ans: The advantages and
disadvantages of e- commerce are:
Advantages
of E-commerce
It makes
buying/selling possible 24/7.
There are no
geographical boundaries for e-business. Anyone can order anything from anywhere
at any time.
Disadvantages
of E-commerce
Lack of personal
touch. We cannot touch the goods physically.
Technical failure
may affect the business system.
e Define e-governance. List out the advantages of e- governance.
Ans:
E-Governance
refers to the use of the digital technology by government to enhance the
delivery of public services and engage with citizens more effectively.
The
advantages of e- governance are:
Citizens
can access government services and information conveniently from anywhere.
It reduces
paperwork and manual tasks, which can lead to faster decision-making and
service delivery.
f. What is DBMS? Give Example
Ans: DBMS is a software that manages
databases, allowing users to store, access, and manipulate data in an organized
and secure way.
E.g.,
MS-Access, Oracle, Fox pro, dBase etc.
g. What is data sorting? Last any two advantages of using it
Ans: Sorting refers to the process of
organizing data in a specific order (ascending or descending) based on one or
more fields in a table, query, or report.
The advantages of sorting 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.
h. What is form? Explain.
Ans: Form is a database object that
provides a graphical interface for users to view, enter, and edit data from one
or more tables, queries, or other data sources. Forms provide an easy-to-use
interface for data entry and manipulation, improving data accuracy and completeness.
Forms can be linked to other objects, such as tables or queries, to simplify
data management
i. List out the data type
used for the following data in MS Access
Student' Name, Students' Roll Number,
Address, Fee paid
Ans;
The data type used for the following data in MS Access are:
Studnent
Name Text
Student’s
Roll Number – Autonumber
Address
– Memo, Fee
Paid - Currency
5. Write down the output of the following along with dry run table.
2
DECLARE
SUB SENDUP(S$)
E$=
“NPABSON"
CALL
SENDUP(E$)
END
SUB
SENDUP(S$)
FOR
i = 1 to LEN(S$) STEP 1
IF
i MOD 2<>0 THEN
EE$=EE$+LCASE$(MIDS(S$,I,1))
ELSE
EE$=EE$+UCASE$(MIDS(S$,I,1))
END
IF
NEXT
i
PRINT
EE$
END
SUB
Dry Run
|
E$ |
S$ |
i=1
to LEN(S$) |
i
MOD 2 <>0 |
E$ |
|
NPABSON |
NPABSON |
1
to 7 |
1
MOD 2 <>0 1<>0
Yes |
n |
|
|
|
2
to 7 |
2
MOD 2 <>0 0<>0
No |
n+P=nP |
|
|
|
3
to 7 |
3
MOD 2 <>0 1<>0
Yes |
nP+a nPa |
|
|
|
4
to 7 |
4
MOD 2 <>0 0<>0
No |
nPa+B nPaB |
|
|
|
5
to 7 |
5
MOD 2 <>0 1<>0
Yes |
nPaB+s nPaBs |
|
|
|
6
to 7 |
6
MOD 2 <>0 0<>0
No |
nPaBs+O nPaBsO |
|
|
|
7
to 7 |
7
MOD 2 <>0 1<>0
Yes |
nPaBsO+n nPaBsOn |
|
|
|
8
to 7 loop exits |
|
|
The output of the program is :
nPaBsOn
6. Re-Write the given program after correcting the bug: 2
REM
display records of students from Data file
OPEN
"Stdinfo.dat" FOR OUTPUT AS #1
PRINT
"ROLL", NAME",
"ADDRESS", "CLASS" , "SECTION"
DO
WHILE NOT EOF
INPUT
#1, RN. N$, AD$, CL, S$
PRINT
RN, NS, ADS, CL, S$
NEXT
STOP
#1
END
Debugged Program
REM
display records of students from Data file
OPEN
"Stdinfo.dat" FOR INPUT AS #1
PRINT
"ROLL", NAME",
"ADDRESS", "CLASS" , "SECTION"
DO
WHILE NOT EOF (1)
INPUT
#1, RN. N$, AD$, CL, S$
PRINT
RN, NS, ADS, CL, S$
WEND
CLOSE #1
END
7. Study the following program and answer the given questions:
DECLARE
SUB TEST (B$)
CLS
INPUT
W$
CALL
TEST(W$)
END
SUB
TEST (B$)
FOR
I=1 To LEN (B$)
PRINT
RIGHT$(B$, i)
NEXT
I
END
SUB
a. Write the names of two built in functions used in the above
program
Ans:
the names of two built in functions used in the above program are LEN ( ) and
RIGHT$ ( )
b. List the real parameters of the above program
Ans:
The real parameters of the above program is W$
GROUP C (16 Marks)
8. Convert/Calculate as per the instruction: 4x14
1)
(315)→(7)2
ii)
(A4B)16 – ( ? )8
(1011)
× (101) + (1001)
(10111)
¸ (101)
9. Answer the following
a. WAP to calculate area of rectangle using SUB...END SUB and arca
of circle using FUNCTION...END Function.
DECLARE
SUB AREA (L, B)
DECLARE
FUNCTION ARE (R)
CLS
INPUT
“ENTER LENGTH”; L
INPUT
“ENTER BREADTH”; B
INPUT
“ENTER RADIUS”; R
CALL AREA
(L, B)
PRINT
“AREA OF CIRCLE ”; ARE(R)
END
SUB AREA
(L, B)
A = L * B
PRINT
“AREA OF RECTANGLE=”; A
END SUB
FUNCTION
ARE (L, B)
ARE = 3.14
* R ^ 2
END
FUNCTION
b. Write a program to create a file "info.dat" and Store
the name address and mobile number of 5 peoples
OPEN
"info.dat" FOR OUTPUT AS #1
FOR
I = 1 TO 5
INPUT
"Enter Name"; N$
INPUT
"Enter Address"; A$
INPUT
“Enter mobile number”; M#
WRITE
#1, r, N$, A$, M#
NEXT
I
CLOSE
#1
END
10. Write a program in C language to input a number and test whether
it is odd or even. 4
#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;
}
