SEE QUALIFYING EXAM- 2075

PABSON, Kathmandu

SEE QUALIFYING EXAM-2075

Opt II. Computer

Group A

Computer Fundamental (22 marks)

1. Answer the following questions:                         (5×2=10)

a.  What is network interface card? Write down the advantage of it in a network.

     Ans: It is a card that connects computer within a network. The advantage is to present the platform for a communication between the computers within a network.

b.  What is search engine? For what it is used?

      Ans: Search engine is the website that allows the user to search the information based on keywords on combination of keywords. They are used to locate specific sites and information.

c.  What is the role of multimedia in an advertisement?

      Ans: The role of multimedia in advertisement is to promote any items and approach new user to   use it perfectly. 

d.  Why do the computer systems need regular maintenance?

     Ans: Computer system need regular maintenance to keep the computer hardware in good working condition and it also helps to find out problems in hardware and correct the problems before they cause several damages.

e.  List any two points to protect your computer from the virus.

     Ans: Any two points to protect your computer from the virus are
                i) Install a good antivirus program and update its virus definition file frequently.
                ii) Do not use pirated software.

2.  a. Perform the binary operation.                                   (2×1=2)

i. (1111 + 1101) – (1001)

            Solⁿ:

  1  1  1  1

+1  1  0  1

1 1 1  0  0

         -    1  0  0  1       

            1 0  0  1  1

                 (1111 + 1101) – (1001) = 10011

ii. 1101 ´ 11 ¸ 101

            Solⁿ:

                 1 1 0 1

   ´ 1 1
1 1 0 1

         1 1 0 1 ´

     1 0  0 1 1 1

            Now, Dividing

            101) 100111 ( 111

                     -101

                       1001

                        -101

                         1001
                           -101
                             100

            Quotient = 111

            Remainder = 100

     b. Convert as indicated.                                              (2×1=2)

      i. (235)₈ into decimal

      Solⁿ:

      Converting Octal into Decimal

         =2 ´8² + 3  ´ 8¹ + 5  ´ 8⁰

       =2´64 + 3´8 + 5´1

       =128 + 24 + 5

       =157

     
        (235)₈ = (157)10

     ii. (BA5)₁₆ into binary

      Solⁿ:

      Converting hexadecimal into Binary,

      B = 1011

      A = 1010

      5 = 0101

      =(101110100101)₂

            (BA5)₁₆ = (101110100101)₈

3. Match the following.                                                   (4 x 0.5 = 2)

Group A                          Group B

a.     Animation                               i. The creation and manipulation of picture images in the computer

b.     Graphics                                ii. A system that enables one or more users to move and react with  
                                             computer graphics

c.      Multimedia                  iii. The moving graphic images

d.     VR                                 iv. The combination of different media

Ans:
Group A                          Group B
     a.     Animation                     i. The moving graphic images
    b.     Graphics                                              ii. The creation and manipulation of picture images in the 
                                                computer graphics

c.      Multimedia                                          iii. The combination of different media

d.     VR                     iv. A system that enables one or more users to move and react with  
                                             computer graphics

4. Give the appropriate technical terms of the following:   2                                    (4×0.5=2)

a. A mode of transmission in which data flows in the both directions, but only one at a time.

Ans: Half Duplex Mode

b. Message sent electronically through computer network.

Ans: E-mail

c. A class of program that searches your hard drive and floppy disks for any known or potential virus.

Ans: Antivirus Software

           d.     The technique used to provide medical information and services through the internet.

Ans: E-medicine

6. Write the full forms of the followings.                           (4X 0. 5 = 2)

POP : Post Office Protocol

DVD : Digital Versatile Disk

      MBR  : Master Boot Record

VHF : Very High Frequency

4. Choose correct answer.                                      (4 x 0.5 = 2 )

      a. Opera and Firefox is a/an.................

      i. chat program                 ii. Web browser          

      iii. search engine               iv. None of the above

      b. The temperature in the computer system should be maintained between ..... to ....

      i.    21⁰ C to 24⁰ C             ii. 22⁰ C to 25⁰ C          iii.     23⁰ C to 26⁰ C     iv. None of above 

      c. Main component of multimedia

      i. Floppy disk           ii. Magnetic disk        iii. Sound card                                iv. All of the above

      d. Some of the methods of hardware protection are

      i. Password Policy                       ii. Security Lighting      iii. Scan disk    iv. All of the above

Group ‘B’

[Database Management System - 10 Marks]

7. Answer the following questions:                                   (3×2=6)

a.  What is an electronic database? List any two advantages of it.

     Ans: An electronic database refers to an organized collection of data stored in a computer in such a way that its content can be easily accessed. Any two advantages are:
      i) We can search data very easily.
     ii) Modification is very easy in comparison of manual database.

b.  What is DBMS? What are the applications of DBMS?

Ans: DBMS is a software that helps to extract, view, and manipulate data in an organized way. MS-Access and FoxPro are the applications of DBMS.

c.  What is a form and what are the uses of form in MS-Access?

Ans: Form is an object of MS-Access that helps to view, add and modify the content of a file. It gives a separate platform to handle data.

8. Choose the correct answer:                                           (4×0.5=2)

a. A field name can be upto 255 characters long. False
b. OLE is the data type of MS-Access. True.
c. Collecting multiple related fields is called report. True
d. Validation rule specifies the expression that checks the invalid data. True

9. Match the following.                                                  (4 x 0.5 = 2)

      Group A                     Group B

      Query                                              - view data

      Report                                             - Relationship

      One to One                                                 - Action query

      Delete Query                                    - Extract selected data

                                                                - Database software

     

      Group A                     Group B

          Query                              - Extract selected data

            Report                            -view data

            One to One                 -Relationship

             Delete Query                -Action query

                                               

Group C

[Programming-18 marks]

10. Answer the following questions.

a.  What is procedure? 

     Ans: Procedure is a section of code which performs one or more specific tasks and can be accessed from remote location. 

b.   Write down the name of different types of operators used by C language?

Ans: The name of different types of operators used by C language are Arithmetic, Relational,  Logical, Unary, Conditional and Assignment operator.

c.  Write the function of the following statements.

      i. NAME...AS:  Rename the data file.

      ii. LINE INPUT#: Read data assuming a single value.

11. Rewrite the given program after correcting the bugs.            2

REM to copy from old file to new file
OPEN "info.dat" for INPUT AS #1
OPEN "temp.dat" for OUTPUT AS #2
DO UNTIL EOF(1)
INPUT #2, n$, p$, d$, s
WRITE #1, n$, p$, d$, s
WEND
CLOSE #2, #2
END

Debugged program:

REM to copy from old file to new file
OPEN "info.dat" for INPUT AS #1
OPEN "temp.dat" for OUTPUT AS #2
DO UNTIL EOF(1)
INPUT #1,  n$, p$, d$, s
WRITE #2, n$, p$, d$, s
LOOP
CLOSE #1, #2
END

12.  Find the output of the given program.                        2

     

         DECLARE FUNCTION RESULT (N)
         N = 4
         PRINT RESULT (N)
         END
     
         FUNCTION RESULT (N)
         FOR I = 1 TO N
         T = I + 2
         D = D + T
         NEXT I
         RESULT = D
         END FUNCTION
     
      Ans: Output is:    

               18

13.     Study the following program and answer the following questions that follow:                                                                  2

DECLARE SUB SERIES(A, R, N)
CLS

INPUT "ENTER FIRST TERM"; X
INPUT "NUMBER OF TERMS TO BE GENERATED:"; Z
CALL SERIES (X,Y,Z)
END

SUB SERIES (A, R, N)
FOR I = 1 TO N
PRINT A
A=A*R
NEXT
END SUB

a. What will be the output if the user input 3, 2 and 4 for variables X, Y and Z variables?

Ans: The output will be
3
6
12
24

b. What type of parameter X, Y and Z are?

Ans: X, Y and Z are actual parameters.

14.

a.  WAP to convert Celcius temperature in Fahrenheit using FUNCTION.....END FUNCTION.                             3

Solution:

DECLARE FUNCTION TEMP(C)
CLS
INPUT "ENTER THE TEMPERATURE IN CELCIUS:"; C
PRINT "TEMPERATURE IN FAHRENHEIT="; TEMP(C)
END

FUNCTION TEMP(C)
TEMP = C*5/9+32
END FUNCTION

b. WAP to check whether the input number is palindrome or not using SUB.....END SUB.                                                                               3

Solution:

DECLARE FUNCTION CHECK(N)
CLS
INPUT "ENTER ANY NUMBER"; N
CALL CHECK(N)
END

SUB CHECK(N)
A=N
REV=0
WHILE N < > 0
R = N MOD 10
REV=REV*10+R
N=INT(N/10)
WEND
IF REV = A THEN
PRINT "IT IS PALINDROME"
ELSE
PRINT "IT IS NOT PALINDROME"
END IF
END SUB

c. Create a sequential data file "std.dat" to store names and marks obtained in English, Math Science subjects for few students.           3

                  

     

OPEN "std.dat" FOR OUTPUT AS #1
DO
CLS
INPUT"Enter your name"; N$
INPUT "Enter marks in English"; E
INPUT "Enter marks in Math"; M
INPUT "Enter marks in Science"; S
WRITE #1, N$, E, M, S
INPUT "Do you want to continue or not(y/n)"; ch$
LOOP WHILE UCASE$(ch$)="Y"
CLOSE #1
END

óóó