Solved SLC Supp. Computer Science 2070

SLC EXAMINATION 2070

1. Answer the following questions.

a)     What is computer network? Write any two reasons for computer network.

Ans: A group of interconnected computers through transmission media in order to communicate and share resources like hardware, data and software is called computer network.

The reasons of keeping computers on the network are

a)     To share hardware devices like printers, scanners, hard disks etc.

To share data, information and programs.

b)     What is communication channel?

Ans: Communication channel is a pathway through which data are transmitted in a network.

c)     What is multimedia? Write any two areas where multimedia is used.

Ans: Multimedia is the integration of multiple forms of media, which presents information in more interesting and understandable way.

Any two application areas of multimedia technology are videogame and advertisement.

d)     Write any four symptoms of computer virus.

Ans: The symptoms of computer virus are:
i) Program takes long time to load.
ii) The floppy disk or hard disk is suddenly accessed without a logical reason.
iii) Increased use of disk space and growth in file size.
iv) Corrupting the system data.

e)     What is computer security? Write any two protective measures of computer hardware.

Ans: 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 protective measures of computer hardware are

a) Insurance

b) Power protection device

2. Converted as indicated:

a)

       i.           (209)₁₀-(x)₂

2 | 209 | Remainder

2 | 104 | 1

2 | 52   | 0

2 | 26   | 0

2 | 13   | 0

2 | 6     | 1

2 | 3     | 0

2 | 1     | 1

2 | 0     | 1

(209)₁₀ = (11010001)₂

     ii.          (537)₈-(x)₂

Solⁿ:

Converting octal to binary,

5 = 101

3 = 011

7 = 111

(537)₈-(101011111)₂

b) Perform binary calculations:

i. 101 x 111

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

ii. 110111-1011

1	1	0	1	1	1
		1	0	1	1
1	0	1	1	0	0

3. Match the following:

a)     TCP/IP                                                i. Multimedia

b)     Back up                                   ii. Web address

c)     Sound card                              iii. Software security

d)     URL                                        iv. Protocol

v. RJ45

Answers

a)     TCP/IP                                                i. Protocol

b)     Back up                                   ii. Software security

c)     Sound card                              iii. Multimedia

d)     URL                                        iv. Web address

4. Choose and copy the best answer:

1.     Used to transfer file from one computer to another computer in Internet.
i. FAQ             ii. IRC             iii. FTP                        iv. TPF

Ans: FTP

2.     Media used to transfer data in forms of light?
i. Microwave   ii. Fiber optical   iii. Radio wave   iv. Satellite

Ans:Fiber Optical

3.     What is the route of virus transmission?
i. Monitor       ii. Flash drive iii. Mouse                   iv. Cable

Ans: Flash drive

4.     When was cyber law introduced in Nepal?
i. 2016 BS                   ii. 2061 BS         iii. 2040 BS  iv. 2015 BS

Ans: 2061 BS

5. Give appropriate technical terms for the following:

a.      Network sharing and exchanging information between different people. Computer network

b.     Secret group of character which helps to protect file from unauthorized person. Password

c.      A set of rules and procedures that govern transmission of messages. Protocol

d.     Learning through electronic media. CAL (Computer Aided Learning)

6. Write the full form of:

       i.          SMTP  : Simple Mail Transfer Protocol

     ii.          IRC      : Internet Relay Chat

   iii.          UTP     : Unshielded Twisted Pair

   iv.          HTTP  : Hyper Text Transfer Protocol

7. Write short answer of 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.     List out any four data types used in MS-Access.

Ans: Any four data types of MS-Access are:
i)Text
ii)Number
iii)Memo
iv)Currency

c.      Write any two advantages of Form.

Ans: The advantages of form are:

It provides an interactive platform for input of data into the database.

It helps to display data in more presentable form than a datasheet.

8. Write whether the following statements are true or false:

a)     Auto number data type is used to store data supplied by us. False

b)     Index makes sort process fast. True

c)     Update Query does not change the data of table. False

d)     Formatted document is also called report. True

9. Match the following:

a)      dBASE                                   i. OLE

b)     Primary key                            ii. Memo

c)     Photo                                       iii. DBMS

d)     Long text                                iv. Uniquely defined

v. Hyper links

Answers:

a)      dBASE                                   i. DBMS

b)     Primary key                            ii. Uniquely defined

c)     Photo                                       iii. OLE

d)     Long text                                iv. Memo

GROUP C (Programming)

10.

a)     What is looping?

Ans: The process of repeating a statement or statement blocks for number of times is called looping.

b)     Write any two data type used in C language.

The any two data type used in C language are

i) char

ii) int

c)     Write the function of following statements or commands.
i. CLOSE        : The CLOSE statement closes one or all open files.

ii. KILL           : The KILL statement deletes the file or files from the specified drive and directory.

11. Debug the given program:

a)     OPEN "STUDENT.DAT" FOR APPEND AS 1#
INPUT "NAME"; N$
INPUT "ADDRESS"; ADD$
INPUT "AGE"; AGE$
WRITE #1, N$, ADD$, AGE
          END# 1
           STOP

Debugged Program

OPEN "STUDENT.DAT" FOR APPEND AS #1
INPUT "NAME"; N$
INPUT "ADDRESS"; ADD$
INPUT "AGE"; AGE
WRITE #1, N$, ADD$, AGE
CLOSE # 1
 END

12. Write the output of the following programs:

DECLARE SUB Series ()

      CALL Series

END

SUB Series

      X = 0

      FOR K = 10 TO 4 STEP -2

                  A = K ^2

X = X + A

NEXT K

PRINT X

END SUB

            The output of the program is

           

216

13. Study the following programs and answer the question:

DECLARE FUNCTION rev$ (N$)

            INPUT "Any string"; N$

            PRINT rev$ (N$)

END

FUNCTION rev$ (N$)

            FOR X = LEN (N$) to 1 STEP -1

                        A$=MID$ (N$, X, 1)

                        B$ = B$ + A$

            NEXT X

            rev$ = B$

END FUNCTION

a.      List the library function used in the above program.

Ans: The library function used in the above program are LEN and MID$

b.     What will be the maximum value of X if the N$ is equal to "Computer".

The value of X will be 8 if N$ is equal to "Computer".

14.

a. WAP to calculate average of three numbers using FUNCTION Procedure.

DECLARE FUNCTION AVERAGE (A, B, C)

CLS

INPUT “ENTER FIRST NUMBER”; A

INPUT “ENTER SECOND NUMBER”; B

INPUT “ENTER THIRD NUMBER”; C

AV = AVERAGE(A, B, C)

PRINT “AVERAGE OF THREE NUMBERS”; AV

FUNCTION AVERAGE (A, B, C)

AVGR = (A + B + C) / 3

AVERAGE = AVGR

END FUNCTION

b. WAP to print the sum of the digits of a given numbers using SUB Procedure.

DECLARE SUB SUM (N)

CLS

INPUT "ENTER ANY NUMBER"; N

CALL SUM (N)

END

SUB SUM (N)

S = 0

WHILE N < > 0

R = N MOD 10

S = S + R

N = N \ 10

WEND

PRINT "SUM OF DIGITS"; S

END SUB

c. A sequential data file "RECORD.DAT" has records with field name, address, age and salary. WAP to display only those records whose age is greater than 26.

OPEN “RECORD.DAT” FOR INPUT AS #1

CLS

WHILE NOT EOF (1)

INPUT #1, N$, ADD$, A, S

IF A>26 THEN PRINT N$, ADD$, A, S

WEND

CLOSE #1

END