Solved SLC Supp. Computer Science 2071

SLC Supplementary 2071

1. Answer the following questions.

a) What is computer network? List any two advantages of computer network.
Ans: A group of interconnected computers through transmission media in order to communicate and share resources like hardware, data and software.

Any two advantages of computer network are as follows:
i) The computers on a network can share hardware devices like printer, hard disk, scanner etc.
ii) File can be transferred from one computer to another in a network.

b) What is antivirus? Name any two examples of antivirus software
Ans: Antivirus software is software designed to detect and remove virus from computer system o ensure virus free environment.

Any two examples of antivirus software are:
i) Kaspersky           ii) NOD32      

c) What is hardware security? Name any two software security measures
Ans: The security given to the various hardware tools or equipment from being lost or damaged due to accidental or intention is known as hardware security.

Any two software security measures are:

i) Password

ii) Backup

d) Give the importance of MODEM to the computer network.

Ans: The importance of MODEM to the computer network is that it transfers data from one computer to another through telephone line and access internet as well as performs modulation and demodulation process.

e) What is internet?
Ans: Internet is an interconnection of several thousands of computers of different types belonging to the various networks all over the world.

2a. Convert as instructed

i) (74)₈ to decimal

Solⁿ:

=7×8¹ + 4×8⁰

=7×8 + 4×1

=56 + 4

= 60

(74)₈ = (60)₁₀

ii) (FAC)₁₆ into binary

Solⁿ:

Converting hexadecimal to binary,

F = 1111

A = 1010

C = 1100

(FAC)₁₆ =(111110101100)₂

b. Perform the binary calculations.

i) 111×11

		1	1	1
		×	1	1
		1	1	1
	1	1	1	×
1	0	1	0	1

111×11 = 10101

ii) 1 0 1 – 1 1

1	0	1
-	1	1
	1	0

101-11 = 10

3. Match the following.

            Group A                                  Group B

a)     Node                                 i) Workstation

b)     Server                               ii) HTTP

c)     Coaxial cable                    iii) Repeater

d)     Protocol                            iv) Main computer

v) communication media

Answers:

            Group A                                  Group B

a)     Node                                 i) Workstation

b)     Server                               ii) Main computer

c)     Coaxial cable                    iii) communication media

d)     Protocol                            iv) HTTP

4. Select the correct answer.

a) Which refers to the communication media?

       i) UTP cable               ii) Fiber optic             iii) Microwave                        iv) All of the above

Ans: All of the above

b) Which one is not a type of virus?

       i) Message carrying virus                  ii) Boot Sector virus               iii) System Infector

iv) Special purpose application infector

Ans: Special purpose application infector

c) E-commerce

       i) is a type of business                        ii) is a type of virus                iii) Both (i) and (ii)

       iv) None of the above

Ans: is a type of business

d) Which one is an example of unbound media?

       i) UTP cable               ii) Microwave transmission               iii) Fiber optic cable

       iv) All of the above

Ans: Microwave

5. Give appropriate technical terms for the following:

a) Physical layout of LAN. Topology

b) A card through which a computer is connected to the network. NIC (Network Interface Card)

c) Network of networks. Internet

d) The moral principles that control cyber crime. Computer ethics

6. Write the full form of:

a) SMTP     : Simple Mail Transfer Protocol

b) NOS       : Network Operating System

c) ISP          : Internet Service Provider

d) ICT         : Information and Communication Technology

Group B [Database Management]

7. Answer the following questions:

a) What is database?

Ans: Database is a collection of related and organized information that can be used for different purpose.

b) What is report? Write its importance.
Ans: Report is an object of database which displays the output in an effective way to present the data in a printed format.

The importance of report is that it prints documents according to user’s specifications of the summarized information through query or table.

c) What is Primary key?
Ans: Primary key is a field that uniquely identifies the record which neither accepts duplicate values nor null values.

8. Match the following.

a) MS-Access             i) Data entry and editing interface.

b) Query                      ii) Electronic spreadsheet

c) Record                    iii) Tool to retrieve data from one or more than one tables

d) Form                       iv) Database management software

                                    v) Collection of related fields

Answers

a) MS-Access             i) Database management software

b) Query                      ii) Tool to retrieve data from one or more than one tables

c) Record                    iii) Collection of related fields

d) Form                       iv) Data entry and editing interface.

                                   

9. Write whether the following statements are true or false.

a) Table is not the data type of MS-Access. True

b) MS-Access is not a spreadsheet software. True

c) Index increases the speed of query and sort operations. True

d) Primary key accepts null value. False

Group C [Programming]

10a) Define variable

            Ans: The data item whose value changes during the execution of a program is called variable.

b) Name any two data types used in C language.

Ans: The name of any two data types sued in C language are char and int

c) Write the functions of NAME and CLOSE statements.

            i) NAME : The NAME statement renames a file on a diskette.

            ii) CLOSE: The CLOSE statement closes one or all open files.

11a. Re-write the given program after correcting the bugs:

DECLARE SUB FIBO ( )

CLS

EXECUTE FIBO

END

SUB FIBO

REM Program to generate 2, 2, 4, 6, 10…upto 10^th terms.

A=2

B=2

FOR Ctr =  5 TO 1

DISPLAY A; B;

A=A+B

B=A+B

NEXT Ctr

END FUNCTION

Debugged Program

DECLARE SUB FIBO ( )

CLS

CALL FIBO

END

SUB FIBO

REM Program to generate 2, 2, 4, 6, 10…upto 10^th terms.

A=2

B=2

FOR Ctr =  5 TO 1 STEP-1

PRINT A; B;

A=A+B

B=A+B

NEXT Ctr

END SUB

12. Write the output of the following program:

DECLARE FUNCTION test (N)

CLS

FOR Ctr = 1 TO 3

READ N

Sum = Sum + test (N)

NEXT Ctr

PRINT “The result=”; Sum

DATA 3, 2, 1

END

FUNCTION test (N)

Test = N^2

END FUNCTION

The output will be:

The result = 14

13. Study the following program and answer the given questions:

            DECLARE FUNCTION JPT (N)

            FOR ctr = 1 TO 6

            READ N

            J = JPT (N)

            Sum = Sum + J

            NEXT ctr

            PRINT Sum

            DATA 10, 20, 30, 40, 50, 60

            END

            FUNCTION JPT (N)

            IF N MOD 2 = 0 THEN JPT = N

            END FUNCTION

           

a)     What is name to the function used in the above program?

Ans: The name of the function used in the above program is JPT

b)     How many times the function will be executed in the above program?

Ans: The function will be executed six times.

14a) Write a program using FUNCTION …END FUNCTION to calculate and display the volume of a cylinder. [Hint: volume of cylinder =  PR²H]

DECLARE FUNCTION VOLUME (R)

CLS

INPUT “ENTER RADIUS”; R

PRINT “VOLUME OF SPHERE ”; VOLUME(R)

END

FUNCTION VOLUME (R)

VOLUME = (4 / 3) * 3.14 * R ^ 3

END FUNCTION

b) Write a program using SUB…END SUB to print the first ten odd numbers.

DECLARE SUB DISPLAY ( )

CLS

CALL DISPLAY ( )

END

SUB DISPLAY ( )

A = 1

FOR I = 1 TO 10

PRINT A

A = A + 1

NEXT I

END SUB

c) A sequential data file called ‘Marks.dat’ has stored data under the field heading Roll No., Name, English, Nepali and Maths. Write a program to display all the information of those students whose marks in Nepali is more than 50.

OPEN “Marks.dat’ FOR INPUT AS #1

CLS

WHILE NOT EOF (1)

INPUT #1, R, N$, E, NE, M

IF NE > 50 THEN PRINT N$, E, NE, M

WEND

CLOSE #1

END