Solved SEE 2074 [Computer Science]

 Solved SEE 2074 [Computer Science]

Group A

Computer Fundamentals (22 Marks)

1. Answer the following questions: [5×2=10]
    a.  Define computer network.
        Ans: Computer network can be defined as a connection between computers and other
                 electronic devices to share the resources and information.
    b. Define Internet.
      Ans: A global computer network providing a variety of information and communication
               facilities is called internet.
    c. Write the importance of power protection device to protect computer system.
      Ans: The importance of power protection device to protect computer system are:
                i) To protect the hardware against damage from unexpected power failures.
                ii) To protect files and programs being corrupted due to sudden power failure.
    d. What is computer virus? Mention any two symptoms that can be seen when a computer is                     infected by computer virus.
          Ans: A computer program which is capable of copying itself and typically has a detrimental
                   effect, such as corrupting the system or destroying data. Or any other suitable answer.
                   Two symptoms of computer virus in a computer are:
                    i) Unexpected computer behavior
                    ii) Computer becomes slower
   e. What is cyber crime? Give any two examples.
        Ans: The criminal activities involving the information technology with the help of computer is
                 known as cyber crime.
                 Any two examples of cyber crimes are: software piracy and hacking

2.a) Perform the conversion as per the direction: [2×1=2]

  b) Perform the binary calculations: [2×1=2]


3. Match the following: [4×0.5=2]
     Group 'A'                       Group 'B'
   a) RJ 45 connector          i) Duplicate copy
   b) Backup                        ii) Multimedia
   c) Microphone                 iii) Twisted pair  cable
   d) Hub / switch                iv) Ring Topology
                                            v) Star Topology
Answers:

  Group 'A'                       Group 'B'
   a) RJ 45 connector          i) Twisted pair  cable
   b) Backup                        ii) Duplicate copy
   c) Microphone                 iii) Multimedia
   d) Hub / switch                iv) Star Topology
                                         
4. Select the best answer of the following: [4×0.5=2]
    a) Which of the following is not a network protocol?
         i) POP          ii) FTP         iii) TCP/IP        iv) NOS
         Ans: NOS
    b) Which of these software is used for photo editing?
         i) Ms-Excel          ii) Photoshop         iii) Power-Point       iv) MS-Word
         Ans: Photoshop
    c) Which device is used to connect multiple networks that use the same protocol
         i) Bridge          ii) NIC        iii) Switch       iv) Gateway
         Ans: Bridge
    d) Process of arranging the scattered files into a contiguous manner.
         i) Scandisk          ii) Backup         iii) Defragmentation        iv) Debugging
         Ans: Defragmentation

5. Write the appropriate technical terms of the following: [4×0.5=2]
   a) The physical layout of local area network.
       Ans: Topology
   b) The business conducted through internet.
       Ans: E-commerce
   c) The law which controls the crime which is done with the help of computer and Internet.
       Ans: Cyber law
   d) A computer or device which provides different services to other computers connected to the     
         network.
       Ans: Server

6. Write the full form: [4×0.5=2]
    a) SMTP: Simple Mail Transfer Protocol
    b) WAN : Wide Area Network
    c) URL : Uniform Resource Locator
    d) VOIP : Voice Over Internet Protocol

Group B

Database (10 Marks)

7. Answer the following questions: [3×2=6]
   a) Define database.
      Ans: Database can be defined as an organized collection of data which can be easily accessed,                     managed and updated.
   b) What is data redundancy? How can it be reduced in database?
       Ans: The repetition of same piece of data in a database in more than one location is called data                    redundancy. Data redundancy can be minimized by normalization of database.
   c) Mention any four data types that can be used in Ms-Access.
      Ans: Any four data types that can be used in Ms-Access are
               i) Text
               ii) Memo
               iii) Currency
               iv) Number

8. Select the correct answer: [4×0.5=2]
    a) Which if the following is not accepted by primary key?
         i) Number         ii) Text         iii) Null value        iv) None
         Ans: Null value
    b) Which is called rows in database table?
         i) Field          ii) Record         iii) Form       iv) None
         Ans: Record
    c) Which data type consumes the least storage space?
         i) Text          ii) Yes/No          iii) OLE object       iv) Memo
         Ans: Yes/No
    d) Which is the default data type of Ms-Access?
         i) Memo         ii) Number       iii) Text          iv) Auto number
         Ans: Text

9. Match the following: [4×0.5=2]
     Group 'A'                       Group 'B'
   a) Data                            i) Input, view, edit data
   b) Form                           ii) Formatted output
   c) Report                         iii) Collection of raw facts
   d) Table                          iv) Questions to the database
                                            v) Stores data in database

Answers:

Group 'A'                       Group 'B'
   a) Data                            i) Collection of raw facts
   b) Form                           ii) Input, view, edit data
   c) Report                         iii) Formatted output
   d) Table                          iv) Stores data in database

Group C

Programming (18 Marks)

                                       
10. a) What is formal parameter? [1]
      Ans: The variable which is used in the function definition is called formal parameter.
      b) List any two data types used in C programming language. [1]
      Ans: Any two data types used in C programming language are
               i) char
               ii) int
      c) Write the function of KILL and CLOSE statements. [1]
        Ans:   The function of KILL is to delete the file
                   The function  of CLOSE is to close any opened file

11. Re-write the given program after correcting the bugs: [4×0.5=2]

   REM TO find the factorial of a given number.
   DECLARE FUNCTION FACTO (N$)
   CLS
   INPUT "Enter a number"; X
   PRINT "The Factorial is: ", FACTO (N)
   END

   FUNCTION FACTO (N)
   F = 1
        WHILE N = 0
              F = F * N
              N = N - 1
        WEND
   F = FACTO
   END FUNCTION

Debugged Program:

REM To find the factorial of a given number
DECLARE FUNCTION FACTO (N)
CLS
INPUT "Enter a number", X
PRINT "The Factorial is :", FACTO (X)
END
FUNCTION FACTO (N)
F = 1
WHILE N > 0
F = F * N
N = N – 1
WEND
FACTO = F
END FUNCTION

12. Write the output of the following program: [2]

DECLARE SUB Display (T$)
CLS
T$ = "COMPUTER"
CALL Display (T$)
END

SUB Display (T$)
FOR C = 1 to LEN (T$) STEP 2
    D$ = MID$(T$, C, 1)
    PRINT D$;
NEXT C
END SUB

Output:
CMUE

13. Study the following program and answer the given questions: [2×1=2]

DECLARE FUNCTION SUM (N)
CLS
INPUT "Enter any number"; N
S = SUM (N)
PRINT "The Sum of individual digit is"; S
END

FUNCTION SUM (N)
   WHILE N > 0
       R = N MOD 10
       T = T + R
       N = N \ 10
   WEND
 SUM = T
END FUNCTION

a) State the purpose of suing variable S in line 4 in above program.
   Ans: Variable S is used to store the value returned by the function Sum.
b) Write the use of MOD in the above program.
    Ans: MOD is used to get the remainder of the division.

14. a) Write a program to calculate area of a circle using Sub......End Sub. [3]

            DECLARE SUB Area (r)
            CLS
            INPUT "Enter radius of circle", r
            CALL Area (r)
            END
         
           SUB Area (r)
             A = 3.14*r*r
             PRINT "Area of circle :" ; A
              END SUB

      b) Write a program using FUNCTION.....END FUNCTION to count the number of words in a                 sentence. [3]
       
           DECLARE FUNCTION WCount (S$)
           CLS
           INPUT "Enter a sentence", S$
           C = WCount (S$)
           PRINT "The number of words is :" ; C
           END

          FUNCTION WCount (S$)
          W = 1
          FOR I = 1 To LEN (S$)
          C$ = MID $ (S$, I,1)
           IF C$ = " " THEN W = W + 1
           NEXT I
          WCount = W
          END FUNCTION

      c) Write a program to store Roll no., Name, Class and Address of any five students. [3]

            OPEN "Student.dat" FOR OUTPUT AS #1
            FOR I = 1 TO 5
            INPUT "Enter Roll No.", r
            INPUT "Enter Name", n$
            INPUT "Enter Class", c
            INPUT "Enter Address", a$
            WRITE #1, r, n$, c, a$
             NEXT I
             CLOSE #1
             END

***

Answer Source of all SEE Questions 2074 : Click here

You can also download the SEE Questions 2074 by Clicking here