SLC Examination 2070

SLC Examination 2070 (2014) RE

1. Answer the following questions.

a) What is network topology ? Write any one advantage of star topology.

=> The arrangement or connection pattern of computers or nodes and other devices of the network is called network topology.

Advantage of star topology is it is easy to detect errors .

b) Give any two advantages of e-mail over traditional mail.

=> Advantages

• It is very fast compare to traditional mail.
• It allows to send and receive message across the world.

c) List any two main aims of formulating cyber law in Nepal.

=> Two main aims of formulating cyber law in Nepal are:

• Provides punishment who conducts cyber crime
• Provides legal status for various banking transaction through electronic media, which will be instrumental in boosting economic activities throughout the world via internet.

d) Give any two symptoms of virus attack.

=> Two symptoms of virus attack 

• Program takes long time to load
• Increased use of disk space and growth in file size

e) Give the importance of UPS to the computer system.

=> Importance of UPS to the computer system 

• It controls fluctuation of electric voltage
• Provides enough backup electric power to the computer system when there is power failure. 

2.a) Convert as instructed 

i) (BED)₁₆ into Binary

Hexa decimal value       = BED

Separated hexadecimal  =         B               E                D 

Binary equivalent value =    1011         1110            1101

            ∴ ( BED)₁₆           =  (101111101101)₂

ii) (1010111)₂ into Octal

Binary value                  = 1010111

Separated Binary value =  001    010     111

Octal value                     =   1           2             7

         ∴ (1010111)₂          =  (127)₈

b) Perform binary calculation 

i) 1010*10 

=10100

ii) 10101 / 11

=111

3. Match the following 

                           Group 'A'                     Group 'B'

      Combination of several media   ➡  Multimedia

                          POP                        ➡                               

                          UTP                        ➡

                          UPS                        ➡  Power protection device

4. Choose the correct answer :

 a) Which of the following is an audio output device ?

=> Speaker 

b) Which one is not a type of virus?

=>

c) Which one is bounded media?

=>

d) Which one is an operating system software?

=>

5.  Give appropriate technical terms for the following .

a) A program that can disinfect a file from virus. 

=> Antivirus program

b) A person who steals who steals or destroys other's data, information and program.

=>

c) A company that provides internet service.

=> ARPANET

d) A computer in a network which can provide a services to other computers.

=>

6. Write full forms of :

TCP/IP : Transmission Control Protocol / Internet Protocol

LAN : Local Area Network 

UPS : Ultra Power Supply 

FTP : File Transfer Protocol

7. Answer the following questions:

a) Define data and information.

=> Data can be numbers, letters or symbols representing facts and figures  which may or may not              give any sense.

     Information is an organized collection of related data, which gives a complete sense.

b) What is report? Give its importance. 

=> Report is an object of MS-Access which displays the output in an effective way to present the              data in a print format.

      Importance 

• It displays the information the way we want to view it.
• It present the information retrieved through queries or tables.

c) Name any four data types that can be defined in MS-Access.

=> Types 

• Text 
• Number 
• Memo
• Currency

8. Choose the correct answer.

a) The column in a database table are called
=> field

b) Which is the suitable data type to store video.
=>

c) Text data type can store maximum of ______   characters.
=>

d) Which of the following is a database application?
=>


9.Match the following :

     Group A                                         Group B
Indexing data                                               Searching  fast
form
field                                                              column on database
OLE object 


10. Answer the following questions:

a) What is variable?
=>
c) Give the functions of NAME and CLOSE statements:
=> NAME: The NAME statement renames a file on a diskette.
     CLOSE : It closes one or all open files.

11.Debug the given program:
DECLARE SUB Series ( )
CLC
EXECUTE Series
END

SUB Series
REM to generate 2 2 4 6 10 ..... upto the 10^th term.
P=2
Q=2
FOR 
Ctr=1 to 5
DISPLAY  P, Q,
P=P+Q
Q=P+Q
WEND
END Series( )

=>

12. Write the output of the following program:

DECLARE FUNCTION Area (L, B)
LET L = 10
LET B  = 5
PRINT "The Area = "; Area(L,B)
FUNCTION Area (L, B)
A=L*B
Area = A
END FUNCTION

O/P
=> The Area = 50


13. Study the following program and answer the given questions:

DECLARE FUNCTION Sum (A, B)
INPUT "Enter first number"; A
INPUT "Enter second number"; B
PRINT "The sum of the two numbers ="; Sum (A, B)
END

FUNCTION Sum (A, B)
S = A + B
Sum=S
END FUNCTION

a) List the numerical variables used in the above program.
=>
b) Will the program run if the first line (i.e. DECLARE....) is deleted?
=>

14. a) Write a program using Function...End Function to get temperature in Celsius from the user and then print the temperature in Fahrenheit. [ Hint : F=98 c/5+32]

=> DECLARE FUNCTION TEMPERATURE (C)
CLS
INPUT "Enter temperature in Celsius "; C
PRINT "Temperature in Fahrenheit = ";TEMPERATURE (C)
END

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

b) Write a program using SUB .... END SUB to get a word from the user and then print it in reverse order.

=>

c) A sequential data file called 'Marks.dat' contains Name, English, Nepali, Maths and science fields. Write a program to display all the contents of that data file.
=>