SLC Model Questions Set 1 (Solved)

Group A

Fundamental [22 marks]

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

a. "Computer network reduces the operation cost." Justify this statement.

Ans: Computer network reduces the operation cost as it allows to share software and hardware in the network, so extra hardware or software copies in no need to install for each and every computer in the network.

b. What is Internet? Give any two popular browser software.

Ans: Internet is the world-wide connection of millions of computer in a common protocol TCP/IP for communication.

Any two popular browser software are:

i) Google chrome                   ii) Internet Explorer

c. Write any four ethical principles that computer users have to follow.

Ans: Any four ethical principles that computer users have to follow are:

        i)            You should not use computer to harm other people.

       ii)            You should not destroy, steal and use the computer password of other people.

     iii)            You should not destroy, erase or edit the files of other people.

     iv)            You should not create virus and use it to harm.

d. Give any four preventive measures for computer software security.

Ans: Any four preventive measures for computer software security are:

        i)            Password security

       ii)            Backup

     iii)            Defrag

     iv)            Scandisk

e. What is computer virus? List any two antivirus software.

Ans: Computer virus is a man made self replicating small programs, which causes obstruction in the normal functioning of the computer.

Any two antivirus software are:

   i) Kaspersky Antivirus                                        ii) Noton Antivirus

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

  i) (634)₁₀ into Octal

  So, (634)₁₀ = (1172)₈

  ii) (10101011)₂ into Hexadecimal

 Answer: First converting (10101011)₂ into decimal

                1              0              1              0              1              0              1              1

                =1 x 2⁷ + 0 x 2⁶ + 1 x 2⁵ + 0 x 2⁴ + 1 x 2³ + 0 x 2² + 1 x 2¹ + 1 x 2⁰

                = 1 x 128 + 0 x 64 + 1 x 32 + 0 x 16 + 1 x 8 + 0 x 4 + 1 x 2 + 1 x 1

                = 128 + 0 + 32 + 0 + 8 + 0 + 2 + 1

                = 171                                   

     

                Now, Converting (171)₁₀ into hexadecimal

                                     

                   So, (10101011)₂ = (AB)₁₆

   b. Perform binary calculations:

   i) 10101 + 111 – 101

                10101

                  +111

                 11100

  – 101

10111

   So, 10101 + 111 – 101 = 10111

   ii) 101 x 11 ¸ 10

                101

                X11

                101

             101  .

             1010         

   So, 101 x 11 ¸ 10 = 101

               

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

a  a)  Web browser                                                        i) Reliable power protection device

b  b)  Cyber ethics                                                        ii) to share hardware and software resources

c  c)     UPS                                                                    iii) Internet explorer

    d)  Network                                                              iv) Moral principle

        v) Bridge

    Answer:

      a)      Web browser                                                        i) Internet explorer

      b)      Cyber ethics                                                        ii) Moral principle

      c)       UPS                                                                    iii) Reliable power protection device

      d)      Network                                                              iv) to share hardware and software resources

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

  a) Which is the network operating system?

    i) MS-DOS                       ii) MS-Access                     iii) Windows NT                 iv) MS-Excel

Ans: iii) Windows NT

  b) Which of the following is an unguided media?

   i) Infrared                         ii) fiber optic                       iii) Coaxial cable                                iv) Twisted pair cable

Ans: i) Infrared

  c) Which is not protocol?

   i) TCP/IP                            ii) IPX/SPX                           iii) NETBIOS/NETBUI       iv) Client/Server

Ans: iv) Client/Server

  d) Which is the Anti-virus program?

   i) PowerPoint                 ii) NAV                                  iii) Windows                       iv) Ms-Word

Ans: ii) NAV

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

a)      Number of bits that can be transferred per second over a given transmission medium.

Ans: Bandwidth

b)      The structure in which computers are connected in local area network.

Ans: LAN Topology

c)       A device that connects networks using the same communication protocols.

Ans: Bridge

d)      The combination of more than one media.

Ans: Multimedia

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

   a) URL – Uniform Resource Locator

   b) CD-ROM = Compact Disk – Read Only Memory

   c) UPS =  Uninterruptible Power Supply

   d) HTML = HyperText Markup Language

Group B

Database Management System (10 marks)

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

   a) List any four data types used in MS-Access table.

Ans: Any four data types used in MS-Access table are:

 i) Autonumber                 ii) Text                  iii) Number                         iv) Currency

   b) Differentiate between sorting and filtering.

Ans: The difference between sorting and filtering are:

Sorting	Filtering
Sorting is the process of arranging tables in database, either in descending or ascending order based on key field	Filtering is the process of displaying the specific and particular records according to the set criteria from the database or group of records.

   c) What is form? Write the importance of report.

Ans: Form is a database object on which we can place controls for taking actions or for entering, displaying and editing data in fields.

Report is important when data are required to be arranged, edited and need to be printed as hard copy output.

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

  i) The default value size of text field is ……………….

   a) 40                                   b) 50                                      c) 256                                    d) 64

Ans: 50

  ii) Which component of MS-Access is used to enter data?

   a) Query                           b) Forms                              c) Report                             d) Table

Ans: Form

  iii) ………………… is a database management system.

   a) dBase                            b) MSAV                              c) Excel                                 d) All of the above

Ans: dBase

  iv) A column in MS-Access table is ………….

   a) field                               b) query                               c) database                         d) record

Ans: field

9. Match the following groups:                 |4x0.5=2|

Group A                                                                               Group B

                         i.            Primary key                                            (    ) picture

                       ii.            OLE                                                        (    ) data type

                     iii.            Memo                                                     (    ) easy to search

                      iv.            Sort                                                         (    ) unique identification of record

 (    ) query

Answer:

Group A                                                                               Group B

                      i.            Primary key                                                (i.) unique identification of record

                    ii.            OLE                                                           (ii.) picture

                   iii.            Memo                                                       (iii.) data type

                   iv.            Sort                                                           (iv.) easy to search

Group C

QBASIC Programming (18 marks)

10.a) What does modular programming mean?                                                                              |1|

Ans: Modular programming is a programming technique that divides  a large block of program in to smaller sub program where each sub module has it own function.

   

      b) What is C language? Who developed it?                                                                               |1|

Ans: C is a general purpose computer programming language which combines the features of high level language and low level language, developed in 1972 by Dennis Ritchie.

11. Give the function of CLOSE and NAME statements.                                                               |1|

Ans: The function are as follow:

    Close  :  It is used to close all opened files.

                Name :  It is used to rename a file.

12. Debug the following program:                                                                                                    |2|

REM to reverse string

DECLARE FUNCTION REV$(ST$)

CLS        

INPUT "Enter a string";s$

LET r$ = rev$(st$)

PRINT "The string in reverse is ";r$

END

FUNCTION rev$(st$)

For I = LEN(st$) to 1

RV$ = RV$ + MID$(ST$,1,I)

NEXT I

RV$ = REV$

END FUNCTION

Ans: Program after debugging:

REM to reverse string

DECLARE FUNCTION REV$(ST$)

CLS        

INPUT "Enter a string";st$

LET r$ = rev$(st$)

PRINT "The string in reverse is ";r$

END

FUNCTION rev$(st$)

For I = LEN(st$) to 1  step -1

RV$ = RV$ + MID$(ST$,I,1)

NEXT I

REV$ = RV$

END FUNCTION

13. Find the output of the given program:

DECLARE SUB result ()

CLS

CALL result

END

SUB result

a = 11111

c = 5

while c >= 1

PRINT a;

a = a \ 10

c = c – 1

WEND

END SUB

                                      OUTPUT: 

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

DECLARE SUB STRIN(x$)

X$ = "COMPUTER"

END

SUB STRIN(x$)

L = LEN(x$)

FOR I = L to 1 STEP -2

PRINT MID$(x$,I,1);

NEXT 1

END SUB

a.       What will be the value of L if X$="NEPAL"?

Ans: The value of L will be 5.

b.      List out numeric and string variables used in the above program.

Ans: Numeric variables are : L and I

         String variables are : X$

15.a. Write a program to print the smallest number among the three numbers using FUNCTION……END FUNCTION statement.                                                                                                             |3|

DECLARE FUNCTION LOW(x,y,z)

CLS

INPUT "Enter any three numbers";x,y,z

PRINT "The smallest number is = ";Low(x,y.z)

END

FUNCTION LOW(x,y,z)

IF x<y AND x<z THEN

                S = x

ELSEIF y<z THEN

                S = y

ELSE

                S = z

END IF

LOW = S

END FUNCTION

     b. Write a program to print the series given below using SUB procedure                                         |3|

1, 3, 5, 7, 9, up to 15^th term.

DECLARE SUB ODD()

CLS

CALL ODD

END

SUB ODD()

O = 1

FOR J = 1 TO 15

PRINT O

O = O + 2

NEXT J

END SUB

     c. Write a program to create a sequential data file STUDENT.DAT" to store students name, class, roll no, telephone no and age.                                                                                                                                     |3|

OPEN "STUDENT.DAT" FOR OUTPUT AS #1

DO

INPUT "Enter Name";N$

INPUT "Enter Class";C

INPUT "Enter Roll No.";RN

INPUT "Enter Telephone No."; TN#

INPUT "Enter Age";A

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

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

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

CLOSE #1

END

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