SOLVED SEE MODEL SET 1 2080

 SOLVED SEE MODEL SET 1 2080

Optional II [Computer Science]

Time : 2 hrs.                                                                                          Full Marks: 50

Group ‘A’

1.    Answer the following questions in one sentence:                                         6×1=6

a)    Which device is used to connect PC with telephone line?

Ans: MODEM is used to connect PC with telephone line.

b)   What is the vision of IT Policy of Nepal 2072?

Ans: The vision of IT Policy of Nepal 2072 is “to transform Nepal into information and knowledge-based society and economy”.

c)    Which view is used to modify a record in MS-Access?

Ans: Datasheet view is used to modify a record in MS-Access

d)   What is the default field size of “AutoNumber” data type?

Ans: The default field size of “AutoNumber” data type is 4 bytes.

e)    List the modes of operations for opening a sequential file.

Ans: The modes of operations for opening a sequential file are INPUT, OUTPUT and APPEND mode.

f)     Write the name of two selection statement used in C language.

Ans: The name of two selection statement used in C language are if and select

 

2.    Write appropriate technical term for the following:                                   2×1=2

a)    The network security systems that monitor and controls the traffic flow between the Internet and private network. Firewall

b)    An intelligent device that has ability to determine the best possible path for data transmission. Router

 

3.    Write the full form of the following:                                                   2×1=2

a)    PaaS – Platform as a Service       

b)    EFT – Electronic Fund Transfer

 

Group B

4.    Answer the following questions:                                                                   9×2=18

a)    Mention differences between client/server architecture and peer to peer architecture of the network.

Ans: The difference between client/server architecture and peer to peer architecture of the network are:

Client/server architecture	Peer to peer architecture
Client/ server network is a type of network model where at least one computer is designed as a server and other computers on the network called clients or workstations	Peer-to-Peer network is a type of network model where all the computers have equal responsibilities on the network.
It provides central security administration and the network administrator is responsible for data security and other resources management of the network.	It lacks centralized network administration, where the network administrator needs to manage security on each computer. It provides no reliable security and might put data in higher risks.

b)   What is a digital footprint? Share your thoughts about cyberbullying.

Digital footprint is a trace of data that is created while using the Internet. 

Cyber bullying is a kind of harassment using mobiles or computers. Cyberbullying can cause depression, anxiety, loneliness, and in severe cases, make people want to hurt themselves or think about ending their lives. To stop cyberbullying, we need to teach, support, and help those affected.

c)    What is Online Payment? Write any four forms of e-payment in Nepal.

Ans: Online payment refers to the payment for buying goods or services through the Internet using different online payment gateway.

E.g. eSewa Nepal, iPay, Khalti, e-banking, etc.

 

d)   What are security threats? Write down any four possible threats to computer security.

Security threats refers to a risk which can potentially harm computer systems and organization.

Any four possible threats to computer security are:

—  Internal: The threats include fire, unstable power supply, humidity in the rooms housing the hardware, etc.

—  External: These threats include Lightning, floods, earthquakes, etc.

—  Human: These threats include theft, vandalism of the infrastructure and/or hardware, disruption, accidental or intentional errors.

—  Unauthorized access to computer systems resources such as data.

 

e)    How can public get benefited from the e-governance services?

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. Public 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. Public gets cheaper, more effective, and speedy communications. Public can pay their taxes online.

 

f)     What is MS-Access? Give any two examples of DBMS.

Microsoft Access is a relational database management system (RDBMS) that allows users to store, organize, and manage large amounts of data. Examples of DBMS are: MS-Access and Oracle.

 

g)    What is foreign key? Why is it important to specify primary key in database?

A foreign key in MS Access is a field that establishes a relationship between two tables by referencing the primary key of another table. It important to specify primary key in database because it reduces and controls duplication of record in a table. It sets the relationship between tables.

 

h)   What is filtering. List any two advantages of sorting.

Filtering is an option that selects the required records and displays the result.

Any two 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.

 

i)      Differentiate between Select query and Action query.

The difference between Select query and Action query are:

Select Query	Action Query
A select query is a type of query used to retrieve and display data from one or more tables or queries, based on specified criteria or selection rules, such as filtering or sorting.	An action query is a type of query used to perform a specific action on a set of records, such as adding, deleting, updating, or appending records in a table or query based on specified criteria or selection rules
It doesn't modify the data in any way; it only fetches and displays information.	It modifies or manipulates data in a database like add, update, delete.

 

5.    Write the output of the given program. Show with dry run in table.           2

DECLARE SUB SERIES()

CLS

CALL SERIES

END

 

SUB SERIES( )

X#=11111

FOR I= 1 TO 5

PRINT X#^2

X# = (X# - 1) / 10

NEXT I

END SUB

 

Dry Run

X#=11111	I=1 to 5	PRINT X#^2	X#=(X#-1)/10
	1 to 5 Yes	123454321	(11111-1)/10=1111
1111	2 to 5 Yes	1234321	(1111-1)/10=111
111	3 to 5 Yes	12321	(111-1)/10=11
11	4 to 5 Yes	121	(11-1)/10=1
1	5 to 5 Yes	1	(1-1)/10=0
0	6 to 5 No Loop Exits

 

The output of the program is:

123454321

1234321

12321

121

1

6.    Re-write the given program after correcting the bugs:                               2

 

REM To find the sum of even digits of multi digits number

DECLARE FUNCTION SUM (N)

CLS

ACCEPT “ENTER MULTI-DIGITS NUMBER  ”; NUM

PRINT “SUM  = ” ; SUM(N)

END

 

FUNCTION SUM(N)

WHILE N=0

R= N MOD 10

IF R MOD 2 = 0 THEN S=S+R

N = N \ 10

WEND

SUM (N) =S

END FUNCTION

 

Debugged Program

REM To find the sum of even digits of multi digits number

DECLARE FUNCTION SUM (N)

CLS

INPUT “ENTER MULTI-DIGITS NUMBER  ”; NUM

PRINT “SUM  = ” ; SUM(NUM)

END

 

FUNCTION SUM(N)

WHILE N < > 0

R= N MOD 10

IF R MOD 2 = 0 THEN S=S+R

N = N \ 10

WEND

SUM =S

END FUNCTION

 

7.    Study the following program and answer the given questions:           2×1=2

DECLARE  SUB EXAMSEE (A$)

INPUT "Enter any string", B$

CALL EXAMSEE (B$)

END

 

SUB EXAMSEE(A$)

FOR I= LEN (A$) TO 1 STEP-1

PRINT LEFT$(A$,1)

NEXT I

END SUB

 

a) Write the names of two built in functions used in the program.

Ans: The two built in functions used in the program are: LEN( ) and LEFT$( )

b) List the real parameter and formal parameter in the program.

Ans: The real parameter is B$ and formal parameter is A$

8.    Convert/Calculate as per the instruction:                      4×1=4

i) (1011000101)₂ = (?)₁₆                        

ii) (4816)₁₀ = (?)₈

iii) (1011)₂ × (110)₂ – (1011)₂ = (?)₂

iv) (1011010)₂ ÷ (111)₂

 

9.    a) Write a program in QBASIC that asks radius of a circle and calculate its curved surface area and volume of hemisphere. Create a user - defined function to calculate volume of hemisphere and sub procedure to calculate curved surface area. [CSA=2pr², Volume=  ]                                   4

 

DECLARE FUNCTION VOL(R)

DECLARE SUB CSA(R)

CLS

INPUT “Enter Radius”; R

PRINT “Volume of hemisphere=”; VOL(R)

CALL SCA(R)

END

FUNCTION VOL(R)

VOL = 2/3*22/7*R^2

END FUNCTION

 

SUB CSA(R)

C=2*22/7*R^2

PRINT “Curved surface area=”; C

END SUB

 

b) A sequential data file called “rec.dat” has several records having fields name, roll and class. Write a program to copy all the records of class 10 into a newly created file “new.dat”.                        4

 

OPEN "rec.dat" FOR INPUT AS #1

OPEN "new.dat" FOR OUTPUT AS #1

CLS

WHILE NOT EOF (1)

  INPUT #1, N$, R, C

IF C = 10 THEN WRITE #2, N$, R, C   

WEND

CLOSE #1, #2

END

 

 

10. Write a program in C language to ask a number and check whether it is a multiple of 5 or not.   4

 

#include <stdio.h>

int main()

{

   int num;

   printf("Enter a number: ");

   scanf("%d", &num);

   if (num % 5 == 0)

{

       printf("%d is a multiple of 5.\n", num);

   } else

{

       printf("%d is not a multiple of 5.\n", num);

   }

 

   return 0;

}

OR

          Write a program in ‘C’ language to display the series 2, 8, 18, 32,……… up to 10^th terms.

 

#include <stdio.h>

int main()

{

    int i,a=2,b=6;

    for(i=1;i<=10;i++)

{

printf("%d ", a);

a=a+b;

b=b+4;

}

    return 0;

}