Solved SLC Computer Science 2067

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.

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 makes presentation of related subject matter attractive.

d. Mention any four symptoms of computer virus.Ans: Any four 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?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.

3. Match the following:Group A                      Group B
a) Satellite                    a) Multimedia
b) HTTP                       b) Protocol
c) Online business       c) Unguided media
d) Fiber optics              d) E-commerce

Answers

Group A                      Group B
a) Satellite                    Unguided media
b) HTTP                       Protocol
c) Online business       E-commerce
d) Fiber optics              Guided media

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. Examples of DBMS are MS-Access and Oracle.

b) What is primary key?Ans: Primary key is a field that uniquely identifies the record. It is needed because it neither accepts duplicate values now null values.

c) Why is reporter created?

Ans: Report is created to print documents according to user’s specifications of the summarized 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
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