SLC Examination 2069 SOLVED

Print This Page
  Full Marks: 50

                                                                                                Pass Marks:20

Attempt all the questions.
Computer Fundamental (22 marks)

  1. Answer the following questions:

a) Write any four advantages of computer network.

Ans: Any 4 advantages of computer network are as follows:
i) Computer in a network can access network connected hardware devices like printer, disk drives, etc.
ii) Information can be exchanged rapidly in computer network.
iii) Computers in a network environment can be updated from any computer.
iv) Software packages can be shared between network connected computers.

b) What is internet? Write the name of any two E-commerce sites.

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

c) What is computer ethic?

Ans: Computer ethics is the set of moral principles or code of conducts that should be followed by computer user.

d) What is hardware security? Write 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 intentional harm is hardware security.

Any two software security measures are:

i) password

ii) backup

e) What is computer virus?

Ans: Computer virus is a program written by the programmer with the intention of destroying and damaging the data and programs residing in the computer system.

 

1

2

 

 

 

 

Match the following:

Group A                      Group B
a) RJ-45                       a) Multimedia
b) WAN                       b) Duplicate copy
c) Back up                   c) Fiber optic cable
d) microphone             d) Twisted pair cable
e) Internet

Answers

Group A                  Group B
a) RJ-45                  a) Twisted pair cable
b) WAN                  b) Internet
c) Back up               c) Duplicate copy
d) microphone         d) Multimedia

Select the best answer:

a) Which is not unguided media?
i) Fiber optics          ii) Microwave  iii) Infrared      iv) Radio wave

Ans: Fiber optics
b) Which is the internet service?
i) IRC          ii) Telnet          iii) E-mail         iv) All of the above

Ans: All of the above
c) Which is not related to multimedia?
i) Printer                  ii) Sound card  iii) Microphone                        iv) CD-ROM

Ans: Printer
d) Which virus infects boot sector files?
i) Macro virus          ii) Multipartite virus     iii) Boot sector virus

iv) Program virus

Ans: Boot sector virus

5. Give appropriate technical terms:

a) Business through internet.

Ans: E-commerce
b) The software that protects computer virus.

Ans: Antivirus Software
c) Physical layout of LAN.

Ans: Topology
d) A sector word that gives user access to a particular program or computer

system.

Ans: Password

6. Write the full forms of:

a) VOIP           =          Voice Over Internet Protocol            

b) MAN           =          Metropolitan Area Network

c) UTP             =          Unshielded Twisted Pair

d) WWW         =          World Wide Web

Group B 

Database(10 marks) 

Answer the following questions:


a) What is database? Give two examples.

Ans: Database is a collection of related and organized information that can be used for different purpose.
Two examples of database are:
i) Dictionary
ii) Telephone Directory

b) Write any two types of primary key.

Ans: The uses of Primary key are:
i) To reduce and control duplication of record in a table.
ii) To set the relationship between tables.

 

c) What is query?

Ans: Query is an object of  Ms-Access which extracts and arranges information from a table.

Choose the best answer:
a) Which of the following is not a database application?
i) Oracle                 ii) Foxpro         iii) MS-Access     iv) MS-Excel

Ans: MS-Excel
b) Memory space consumed by a currency data type maximally is …………
i) 2 bytes                  ii) 4 bytes         iii) 8 bytes        iv) 1 GB

Ans: 8 bytes
c) The default data type of MS-Access is:
i) Number    ii)Text              iii) Memo         iv) Auto number

AnsText
d) Row is also called …………
i) Record                  ii) Field                        iii) Database     iv) Table

AnsRecord

Match the following:

Group A                           Group B
i) OLE                             a) Data Entry
ii) Hyperlink                   b) Formatted  Hardcopy
iii) Report                                   c) 1 GB

iv) Form                           d) Up to 255 characters

e) Up to 2048 characters

            Answers

Group A                      Group B
i) OLE                          1 GB      ii) Hyperlink                Up to 2048 characters
iii) Report                    Formatted  Hardcopy

iv) Form                       Data Entry

 

Group-C

Programming(18 marks)

a) What is meant by mode of data file?

Ans: Mode of data file means opening a sequential file for one of the three modes of operation like output mode, input mode and append mode.

b) Write any two characteristics of ‘C’ language.

Ans: The 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.

c) Write the function of the following statements:
i) NAME

Ans: The NAME statement renames a file on a disk.

ii) KILL

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

Write the output of the following program

DELARE SUB NUMBER()

CLS

CALL NUMBER

END

SUB NUMBER

N=3

C=1

WHILE C<=5

PRINT N

N=N*10+3

C=C+1

WEND

END SUB

 

ANS:

3

33

333

3333

33333

 

Rewrite the given program after correcting the bugs:

REM display Records of students From Data File

OPEN “STDREC.DAT” FOR INP AS #1

PRINT “ROLL”,”NAME”,”ADDRESS”,”CLASS”,”SECTION”

DO WHILE NOT EOF

INPUT #1,RN,N$,AD$,CL,S$

PRINT RN,N$,AD$,CL,S$

NEXT

CLOSE #1

END

Debugged Program

REM display Records of students From Data File

OPEN “STDREC.DAT” FOR INPUT AS #1

PRINT “ROLL”, ”NAME”, ”ADDRESS”, ”CLASS”, ”SECTION”

DO WHILE NOT EOF (1)

INPUT #1, RN, N$, AD$, CL, S$

PRINT RN, N$, AD$, CL, S$

LOOP

CLOSE #1

END

Study the following program and answer the given questions:DECLARE SUB EXAM(N$)

CLS

INPUT “Enter word”;WO$

CALL EXAM(WO$)

END

SUB EXAM (N$)

FOR I = 1 TO LEN (N$)

PRINT RIGHT$(N$,I)

NEXT I

END SUB

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

Ans: The names of two built-in functions used in above program are LEN( ) and RIGHT$( ) .

b) List the real parameter in the program.

Ans: The real parameter used in the above program is WO$.

a) Write a program to find the numbers of vowels in an input string using ‘FUNCTION…..END FUNCTION’.

DECLARE FUNCTION COUNT (S$)

CLS

INPUT “ENTER ANY STRING”; S$

PRINT “TOTAL NO. OF VOWELS= “; COUNT(S$)

END

FUNCTION COUNT (S$)

VC = 0

FOR I = 1 TO LEN(S$)

B$ = MID$(S$, I, 1)

C$ = UCASE$(B$)

IF C$ = “A” OR C$ = “E” OR C$ = “I” OR C$ = “O” OR C$ = “U” THEN

VC = VC + 1

END IF

NEXT I

COUNT = VC

END FUNCTION

b) Write a program using sub procedure module to print the series 1,1,2,3,5,8.. up to ten terms.

DECLARE SUB SERIES ( )

CLS

CALL SERIES

END

SUB SERIES ( )

A = 1

B = 1

FOR I = 1 TO 10

PRINT A;

C = A + B

A = B

B = C

NEXT I

END SUB

c) Write a program to create a data file ‘teldir.dat’ to store Name, Address and Telephone number of employees according to the need of the user.

OPEN “teldir.dat” FOR OUTPUT AS #1

DO

CLS

INPUT “ENTER NAME”; N$

INPUT “ENTER ADDRESS”; A$

INPUT “ENTER TELEPHONE NUMBER”; T#

WRITE #1, N$, A$, T#

INPUT “DO YOU WANT TO CONTINUE(Y/N)”; CH$

LOOP WHILE UCASE$(CH$) = ”Y”

CLOSE #1

END

 

Leave a Reply