Sunday 24 November 2013

Solved SLC Computer Science 2069

Solved SLC Computer Science 2069


SLC Examination 2069 (2013)
Optional II [Computer Science]
Examinees are required to answer in their own words as far as practicable. Credit shall be given to clarity and originality, not rote learning.
Time: 1 hour 30 minutes                                                        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.




3. 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
                               

4. 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) 7. 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.
8. 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
Ans: Text
     d) Row is also called …………
          i) Record                  ii) Field                        iii) Database     iv) Table
Ans: Record


9. 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)
10.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.
11. 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

 
12. 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


13. 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$.

14. 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

***

No comments:

Post a Comment

MCQ Question Bank Microsoft PowerPoint