SLC Model Questions Set 3 (Solved)

SLC Model Questions Set 3 (Solved)

Group A

Fundamental [22 marks]

1. Answer the following questions: |5x2=10|

a. What is computer network? Write any two services provided by computer network.

Ans: The interconnection of computers through wire or without wire in order to share software, hardware and resources is called computer network.

          Any two services provided by computer network are:

          i) Sharing of software and hardware that reduces the cost of operation.

          ii) Cheap means of communication, that allow to send or receive information at very fast speed.

b. Define Internet. Write any two advantages of internet in the society.

Ans: Internet is an interconnection of millions of computers all over the world for communication.

          Any two advantages of internet in the society are:

          i) Global communication facilities.

          ii) Online business possible.

c. What is multimedia? Write any two hardware required to make PC multimedia capable.

Ans: Multimedia is the combination of the different media such as text, graphics, audio, video and animation to make presentation more attractive and effective. Any two hardware required to make PC multimedia capable are:

      i) Speaker                      ii) CD-ROM

d. What is antivirus software? Give any two examples of antivirus software.

Ans: The program that is used to detect and disinfect the virus from the computer system is called as antivirus. Any two examples of antivirus software are:

      i) Kaspersky antivirus                               ii) AVG antivirus

e. Write any four methods to maintain hardware security.

Ans: Any four measures to protect computer hardware are:

          i) Regular maintenance                       ii) Power protection  device

          iii) Insurance                                            iv) Protection from theft

2.a. Convert as instructed:           |2x1=2|

  i) (CAB)₁₆ into Decimal

Answer:  

                = C x 16² + A x 16¹ + B x 16⁰

                = 12 x 256 + 10 x 16 + 11 x 1

                = 3072 + 160 + 11

                =3243

  ii) (534)₈ into Binary

 Answer:   Octal number –                                5      3       4

                    Equivalent octal binary digits – 101  011  100

Hence, (534)₈ = (101011100)₂

   b. Perform binary calculations:

   i) Divide 111 by 10

  Solution:  

Hence, Quotient = 11 and Remainder = 1

   ii) 1011 + 1010 - 101

  Solution:            1011

                             +1010

                                10101

- 101

10000   

               

3. Match the following pairs:                                                                                                     |4x0.5=2|

      a)      Modem                                           i) Internet account provider

      b)      ATM                                              ii) Internet language

      c)       ISP                                                iii) Internet component

      d)      LAN                                              iv) Online banking

 v) Bus topology

    Answer:

      a)      Modem                                         i) Internet component

      b)      ATM                                            ii) Online banking

      c)       ISP                                              iii) Internet account provider

      d)      LAN                                            iv) Bus topology

4. Select the correct answer from the given options:                      |4x0.5=2|

  a) The unique address of web page or file on the internet is called ………….

    i) URL                                                ii) browser                          iii) protocol                         iv) HTTP

Ans: i) URL

  b) Which of the following is cyber crime?

   i) piracy                             ii) hacking                            iii) data didling                   iv) All

Ans: iv) All

  c) Multimedia is used in …………….

   i) education                     ii) entertainment             iii) virtual reality                iv) All of the above

Ans: iv) All of the above

  d) Which virus infects the various parts of operating system?

   i) boot sector                  ii) worms                             iii) macro                              iv) system infector

Ans: i) boot sector

5. Give the suitable technical terms of the followings: |4x0.5=2|

a)      Online postal service.

Ans: E-mail

b)      A network which extended beyond 100 km.

Ans: WAN (Wide Area Network)

c)       The policies, procedures, tool and techniques designed to protect computer assets.

Ans: Cyber law

d)      The scattering of the part of the same disk file over different location.

Ans: Fragmentation

6. Give the full form of the followings: |4x0.5=2|

   a) TCP/IP– Transmission Control Protocol/Internet Protocol

   b) ADSL -  Asymmetric Digital Subscriber Line

   c) WAN -  Wide Area Network

   d) CVT = Constant Voltage Transformer

Group B

Database Management System (10 marks)

6. Answer the following questions:                        |3x2=6|

   a) What is database? Write any two importance of database.

Ans:  A database is a single organized collection of structured data, stored together to serve multiple applications.

            Any two importance of database are:

            i) Database allows to store related data in electronic form about a particular organization or   company.

            ii) Database allows to share data among different users in the network.

   b) What is form? Write the advantages of form over table.

Ans: A form is a MS-Access object used to enter new record and to edit existing record from the table.

          The advantages of form over table are:      

                            i)            Forms are easier to enter data and perform calculation.

                          ii)            Forms allow editing of data using macros or visual base procedures.

   c) Define data type. Write any two data type that can be used to store string data.

Ans: Data type is an attribute that determine how much data can be stored in a particular field. Any two data type that can be used to store string data are:

          i) Text                         ii) Memo

8. State whether the following statements are True or False:                                     |4x0.5=2|

a)      MS-Excel is DBMS program.

Ans: False

b)      Logical field has the size 1 bit.

Ans: True

c)       Query is the source of table.

Ans: False

d)      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.            MS-Access                                                 a) data type

                         ii.            Primary key                                                b) data base

                       iii.            Report                                                        c) DBMS

                       iv.            Hyperlink                                                   d) unique identification of record

     e) object of MS-Access

Answer:

Group A                                                                               Group B

                             i.            MS-Access                                                         a ) DBMS

                          ii.            Primary key                                                        b ) unique identification of record

                        iii.            Report                                                                 c ) object of MS-Access

                         iv.            Hyperlink                                                            d) data type

Group C

QBASIC Programming (18 marks)

10.a) What is nested loop.                                                                                                          |1|

Ans: A loop within another loop is called nested loop.

   

      b) Write any two data types of C language.                                                                   |1|

Ans: Any two data types of C language are:

          i) int                             ii) float

11. Write down the function of the following statements.                                                          |1|

     i) SHELL                                           ii) RMDIR

Ans: The function are as follow:

SHELL :  To open DOS prompt temporarily.

                RMDIR : To remove an empty sub directory from a disk.

12. Rewrite the following programs with correcting the bugs.                                                    |2|

REM Program to input any number from the user and display its factors.

DECLARE SUB fact(n)

                CLS

INPUT "Enter number="; n

DEMAND fact(n)

END

SUB fact(n)

CLS

PRINT "Factors of"; n; "are=";

FOR x = 1 to n

R = n MODE x

If r = 0 then PRINT r;

NEXT x

SUB END

END

Ans: After debugging the program.

REM Program to input any number from the user and display its factors.

DECLARE SUB fact(n)

                CLS

INPUT "Enter number="; n

CALL fact(n)

END

SUB fact(n)

CLS

PRINT "Factors of"; n; "are=";

FOR x = 1 to n

r = n MOD x

If r = 0 then PRINT x;

NEXT x

END SUB

13. Write the output of the given program.                                                                               |2|

DECLARE FUNCTION num (a)

s = 0

FOR x = 1 to 5

READ n

s = s + num(n)

NEXT x

PRINT s

DATA 1, 2, 3, 4, 5

END

FUNCTION num(a)

Num = a^2

END FUNCTION

                                                Ans: OUTPUT –

14. Read the following program and answer the following questions:                                    |2|

DECLARE SUB ser(x,y)

CLS

CALL ser (4,4)

END

SUB ser(x,y)

CLS

c = 0

FOR a = 1 to 5

PRINT x;

c = x + y

x = y

y = c

NEXT a

END SUB

a.       List the argument used in sub procedure.

Ans: The arguments used in sub procedure are: (4,4)

b.      What will be value of variable "C" when loop completes fourth time?

Ans: The value of variable "C" when loop completes fourth time is 32.

15.a. Write a program to display the series using SUB procedure 8, 18, 32, 50 …. Upto 10^th term.|3|

DECLARE SUB ser()

CLS

CALL ser

END

SUB ser()

s = 2

FOR I = 1 to 10

PRINT (s^2)*2

s = s + 1

NEXT I

END SUB

     b. Write a program to display the total no. of characters available in input string using FUNCTION procedure.                                                                                                                                  |3|

DECLARE FUNCTION COUNT(n$)

CLS

INPUT "Enter string"; n$

PRINT "The total no. of characters are = "; COUNT(n$)

END

FUNCTION COUNT(n$)

FOR I = 1 to LEN(n$)

c = c + 1

NEXT I

COUNT = c

END FUNCTION

     c. Write a program to create a data file named "Record.inf" to store name, roll no, class and address of students. Make option for further continue or not.                                            |3|

OPEN "STUDENT.DAT" FOR OUTPUT AS #1

DO

INPUT "Enter Name"; N$

INPUT "Enter Roll no."; RN

INPUT "Enter Class"; C

INPUT "Enter Address"; A$

WRITE #1, N$, RN, C, A$

INPUT "Do you want to add more records (Y|N)"; CH$

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

CLOSE #1

END

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