SOLVED National PABSON Kathmandu SEE PRE-QUALIFYING EXAMINATION-2080

 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;

}