COMPUTER SCIENCE SLC 2067 - Solved

SLC Examination-2067(2011)
Computer Fundamental (22 marks)

1. Answer the following questions:
a. Write any two examples of data communication.
Ans: Any two examples of data communication are
1. E-mail
2. Telephone

b. What do you mean by web browser?
Ans: Web browser is a computer program that access web pages and displays them on the user computer.Eg. Google Chrome, Mozilla firefox etc.

c. Write any four advantages of multimedia.
Ans: Any four advantages of multimedia are:
i) It makes teaching / learning easier in classroom.
ii) It makes easy to share views, ideas and thoughts among various people.
iii) It can store data and information for longer period.
iv) It can widely be used in marketing and advertisements.

d. Mention any four symptoms of computer virus.Ans: Any four symptoms of computer virus are:
i) Slow in operation
ii) Unnecessary appearance of shortcuts
iii) Files or program crashing
iv) Frequent restart

e. What is computer security
?Ans: The protection 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.There are two types of computer security namely: hardware security and software security.

4. Choose the correct answer:
a) Which is not a communication media?
i) Wire ii) Microwave iii) Satellite iv) NIC
NIC

b) Which is web browser software?
i) Window 2007 ii) Internet Explorer iii) Windows NT iv) All of the above
Internet Explorer

c)In which topology network devices are connected through hub?
i) Ring topology ii) Bus topology iii) Star topology iv) None of the above
Star topology

d) Which is not related to Internet?
i) ISP ii) TCP/IP iii) WWW iv) UPS
UPS

5. Give appropriate technical terms of the following:
a) An internet tool that helps to upload/download the file.
FTP (File Transfer Protocol)
b) Making duplicate copy of file for security purpose.
Backup
c) A set of rules that governs how computer exchange information over computer network.
Protocol
d) An integrations of audio, video, graphics and text.
Multimedia

6. Write the full forms:
a) URL : Uniform Resource Locator

b)ISP : Internet Service Provide

c)ASCII : American Standard Code for Information Interchange

d)bps : bits per second

Group B-Database
7. Answer the following questions:
a) Define DBMS with examples.
Ans: DBMS is a software which is used to manage data, manipulate them and provide the information for maintaining database in systematic way. Examples of DBMS are MS-Access and Oracle.

b) What is primary key?
Ans: Primary key is a field that uniquely identifies the record which neither accepts duplicate values now null values. It is necessary in databse to control data redundancy.

c) Why is reporte created?
Ans: Report is created
i. to print documents according to user’s specifications
ii.to summarize information through query or table.

8. Choose the best answer:
a) Which is not a type of query?
i) Search ii) Select iii) Update iv)All of the above
Search

b) The storage size of data and time is :
i) 4 bytes ii)6 bytes iii)8 bytes iv)10 bytes
8 bytes

c) Collecting multiple related fields is called:
i)Records ii)Table iii) Forms iv)Query
Records

d) The data type appropriate to store salary is:
i)Memo ii)Currency iii)Text iv) Auto number
Currency

9. Match the following:
a)OLE a)Report
b) Data entry b) Picture
c)Indexing c) Table
d)Formatted printout d)Fast searching
e)Form

Answers

a)OLE Picture
b) Data entry Form
c)Indexing Fast searching
d)Formatted printout Report


Group C-Programming
10. i) What is procedure?
Ans: Procedure is a block of statement that solves a particular problem. Example: Function Procedure and Sub procedure.

ii) Write any two characteristics of C language.
Ans: Any two characteristics are :
i) It is a high level language with some features of low level language.
ii) It is mostly used to prepare system software.

iii) Write the function of:
INPUT
Ans: It reads data from the sequential data file.

MKDIR
Ans: It creates a subdirectory which is used to manage files.

11. Write the output of the following program.
DECLARE SUB RESULT(N$)
N$ = "SCIENCE"
CALL RESULT(N$)
END
SUB RESULT (N$)
B = LEN(N$)
COUNT = 1
WHILE COUNT <= B X$ = X$ + MID$(N$, COUNT, 1) COUNT = COUNT + 2 WEND PRINT X$ END SUB

12. Rewrite the given program after correcting the bugs.
REM to display all the records from sequential Rem data file ABC.DAT
OPEN “ABC.DAT” FOR OUTPUT AS # 1
DO WHILE NOT EOF(“ABC.DAT”)
INPUT # 1,N$,A
PRINT N$,A
CLOSE 1
END

Debugged Program

REM to display all the records from sequential Rem data file ABC.DAT
OPEN “ABC.DAT” FOR INPUT AS # 1
DO WHILE NOT EOF (1)
INPUT # 1,N$,A
PRINT N$,A
LOOP
CLOSE #1
END


13. Read the program given below and answer the following questions.
DECLARE SUB SUM(N)
INPUT”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”;S
END SUB

i) In which condition the statements within the WHILE….WEND looping statement will not be executed?
Ans: When the value of N becomes 0 or when the condition becomes false the statements within the WHILE….WEND looping statement will not be executed

ii) Will the output be the same if we place “/” instead of”\” in the above program.
Ans: No, the output will not be same if we place “/” instead of”\” in the above program.


14. i) Using FUNCTION…END FUNTION, write a program to calculate the average of three numbers.


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
END

FUNCTION AVERAGE (A, B, C)
AVGR = (A + B + C) / 3
AVERAGE = AVGR
END FUNCTION

ii) Using SUB…END SUB, write a program to test whether the given number is completely divisible by 3 or not.
DECLARE SUB CHECK (N)
CLS
INPUT “ENTER ANY NUMBER”; N
CALL CHECK (N)
END
SUB CHECK (N)
IF N MOD 3 = 0 THEN
PRINT N; IS DIVISIBLE BY 3”
ELSE
PRINT N; IS NOT DIVISIBLE BY 3”
END IF
END SUB

iii) A sequential data file “EMP.DAT” contains name, post and salary fields of information about employees. Write a program to display all the information of employees along with tax amount (also tax is 15% of salary).
OPEN “EMP.DAT” FOR INPUT AS #1
CLS
PRINT “NAME”, “POST”, “SALARY”, “TAX”
WHILE NOT EOF(1)
INPUT #1, N$, P$, S
T = 15 / 100 * S
PRINT N$, P$, S, T
WEND
CLOSE #1
END