Wednesday, January 11, 2017

SLC Model Questions Set 4 (Solved)

SLC Model Questions Set 4 (Solved)
Group A
Fundamental [22 marks]
1. Answer the following questions: |5x2=10|
a. What do you mean by communication media? Write any two examples of guided media.
Ans: `Communication media is an electronic path used to transmit data from one device to another device. Any two examples of guided media are twisted pair and coaxial cable.

b. Define e-mail. List out any two importance of e-mail.
Ans: E-mail is an electronic method of sending and receiving message. Any two importance of email are:
          i) It is cheaper, faster and free of cost.
          ii) An e-mail can be send to number of person to any part of the world any time.

c. Write any two positive and any two negative impact of computer in our society.
Ans: Any two positive impact of computer in our society are:
      i) Computer is extensively used in education field to teach students in an efficient way.
      ii) Communication is cheaper, faster and reliable

      Any two negative impact of computer in our society are:
      i) Cyber crime increasing day by day, because people using computer for criminal activity.
      ii) Unemployment increasing, because computer can do work of many people.

d. What is computer virus? Give any two symptoms of computer virus.
Ans: Virus is a destructive computer program that can make lot of damages to computer hardware and software if succeed to infect computer system. Any two symptoms of computer virus are:
      i) Computer take longer time to boot.
      ii) Appearance of unknown file and messages.

e. What is Backup? Write the importance of backup system.
Ans: Backup is a method of making duplicate copy of file which can be used in the event of data loss or corrupt due to intentional or accidental reason. The importance of backup system is to use extra copy in case if original file is lost or damaged.

2.a. Convert as instructed:           |2x1=2|
  i) (450)10 into Binary
Answer:  


                Hence, (450)10 = (111000010)2

  ii) (111101)2 into Octal
 Answer:   Binary digits in 3 bits group –    111    101
                    Equivalent octal digits –                 7         5             
Hence, (111101)2 = (75)8

   b. Perform binary calculations:
   i) 10111 x 110
  Solution:     10111
                          x110
                        00000
                      10111
                    10111    .
                  10001010
Hence, 10111 x 110 = 10001010

   ii) 101101 ¸ 101
  Solution:            
                        Hence, Quotient = 1001 and Remainder = 0

               
3. Match the following pairs:                                                                                                     |4x0.5=2|
       a)      Cyber ethics                                         i) graphics, text, sound
      b)      Virus                                                    ii) main computer
      c)       Server                                                 iii) moral principle
      d)      Multimedia                                         iv) damage data
       v) Internet
    Answer:
      a)      Cyber ethics                                          i) moral principle
      b)      Virus                                                    ii) damage data
      c)       Server                                                 iii) main computer
      d)      Multimedia                                         iv) graphics, text, sound

4. State whether the following statements are True or False:                                     |4x0.5=2|
a)      MAN connects two or more LAN together.
Ans: True
b)      Dialup connection is the easiest way to connect a computer to the internet.
Ans: False
c)       Cyber space is a virtual space used in ICT.
Ans: True
d)      I Love You is a kind of antivirus used in ICT.
Ans: False

5. Give the suitable technical terms of the followings: |4x0.5=2|
a)      Doing business through online.
Ans: E-commerce
b)      The secret word, phrase that gives user access to a particular program.
Ans: Password
c)       The computer that acts the central authority on a network.
Ans: Server Computer
d)      Intentionally, gaining unauthorized access to an information system.
Ans: Hacking

6. Give the full form of the followings: |4x0.5=2|
   a) FTP– File Transfer Protocol
   b) Wi-Fi -  Wireless Fidelity
   c) CPAV-  Central Point Antivirus
   d) ISP= Internet Service Provider
Group B
Database Management System (10 marks)
6. Answer the following questions:                        |3x2=6|
   a) Define field and record with example.
Ans:   Field is a column in a table that store data item for a record. Example : Name, Address, Salary etc.
            Record is a set of related field of information about an entity. Example: Name- Ram, Address – Nijgadh-7, Salary-7000 etc

   b) What is table? Write its importance in database creation.
Ans: Table is an important object in database that contains data in the form of rows and column,
          The importance of table in database is that it is basic building block for database from which information can be retrieved using appropriate program.

   c) What is primary key? Write the use of primary key.
Ans: Primary key is a set of attributes that uniquely identify the records in the table.
          The use of primary key is that it doesn't allow null or duplicate value in the field as used in creating relationship between multiple tables.

8. State whether the following statements are True or False:                                     |4x0.5=2|
e)      The extension of MS-Access is .dbf.
Ans: False
f)       In query calculation also can be done.
Ans: True
g)      We cannot insert picture in database.
Ans: False
h)      With the help of wizard also we can create a form.
Ans: True

9. Match the following groups:                                                                                                 |4x0.5=2|
Group A                                                            Group B
                     i.            Currency field                                                      a ) 1 GB
                   ii.            YES/No field                                                       b ) 255 characters
                  iii.            OLE field                                                            c ) 1 bit
                 iv.            Text field                                                             d) 1 MB
           e ) 8 bytes
Answer:
Group A                                                                               Group B
                     i.            Currency field                                                    a ) 8 bytes
                   ii.            YES/No field                                                      b ) 1 bit
                  iii.            OLE field                                                              c ) 1 GB
                 iv.            Text field                                                             d) 255 characters

Group C
QBASIC Programming (18 marks)
10.a) Define user defined function                                                                                         |1|
Ans: User define function is a block of statement declared by the user to perform a specific type of task.
   
      b) Why is C called middle level language?                                                                     |1|
Ans: C is called middle level language because programmer can write the program in both low level language and high level language.
         
11. Write down the function of INPUT and PRINT statements.                                   |1|
  Ans: The function are as follow:
INPUT :  To accept value from the users.
                PRINT : To display final output on the screen.

12. Debug the following program.                                                                           |2|
REM to input any five no and display the sum of entered no.
CLS
                DECLARE FUNCTION sum(n())
DIM n(5)
FOR x = 1 to 5
ENTER "Input no = ";n(x)
NEXT x
su = sum(n())
print "Sum=";sum
END

FUNCTION sum(n())
s = 0
FOR x = 1 to 5
s = s + n(x)
NEXT x
s = sum
END FUNCTION

Ans: After debugging the program.
REM to input any five no and display the sum of entered no.
CLS
                DECLARE FUNCTION sum(n())
DIM n(5)
FOR x = 1 to 5
INPUT "Input no = ";n(x)
NEXT x
su = sum(n())
PRINT "Sum=";su
END

FUNCTION sum(n())
s = 0
FOR x = 1 to 5
s = s + n(x)
NEXT x
sum = s
END FUNCTION

13. Write the output of the given program.                                                                                         |2|
DECLARE SUB res(st$)
CLS
DATA 4, 6, 11, 1, 3, 7, 5, 13
CALL res(st$)
END
SUB res(st$)
st$ = "BOOKREADKEYED"
FOR x = 1 to 8
READ n
PRINT MID$(st$, n, 1)
NEXT x
END SUB

Ans: OUTPUT –

14. Read the following program and answer the following questions:                                    |2|
DECLARE SUB res(a$)
CLS
a$ = "KATHMANDU"
CALL res(a$)
END

SUB res(a$)
L = LEN(a$)
FOR x = L to 1 STEP -2
PRINT MID$(a$, x, 1);
NEXT x
END SUB

a.       What will be the value of L in the second loop if a$ = "POKHARA"?
Ans: The value of L in the second loop will be 5.

b.      What happen if we remove the statement line "CALL res(a$)" ?
Ans: If we remove the statement line "CALL res(a$)" then the program cannot invoke sub module and generate error message.

15.a. Write a program to check whether entered number is perfect cube or not using SUB …… END SUB statement.|3|
            DECLARE SUB pcube(N)
            CLS
            INPUT "ENTER ANY NUMBER";N
            CALL pcube(N)
END

SUB pcube(N)
P = N^(1/3)
IF P = INT(P) THEN
PRINT "NUMBER IS PERFECT CUBE"
ELSE
PRINT "NUMBER IS NOT PERFECT CUBE"
END IF
END SUB

     b. Using FUNCTION …… END FUNCTION. Write a program to convert given Nepali currency into US dollar. [Hints 1US$ = 98 NC]                                                                                                       |3|
            DECLARE FUNCTION convert(NC)
CLS
            INPUT "ENTER NEPALI CURRENCY";NC
            PRINT "EQUIVALENT US DOLLAR = "; convert(NC)
            END        

            FUNCTION convert(NC)
            USD = NC / 98
            convert = USD
            END FUNCTION

     c. A sequential data file named "STUDENT.DAT" contains name, class, roll no and address of the students. Write a program to display all the students' records whose name starts from the alphabet "B" or "b".                                              |3|
          OPEN "STUDENT.DAT" FOR INPUT AS#1
          PRINT "NAME", "CLASS", "ROLL NO.", "ADDRESS"
          DO WHILE NOT EOF(1)
          INPUT #1, N$, C, R, ADD$
          IF UCASE$(LEFT$(N$,1))="B" THEN
          PRINT N$, C, R, ADD$
END IF
LOOP
CLOSE #1
END


**********************



No comments:

Post a Comment