Important Questions


Group “A”
1.      Answer the following questions:                                          (5*2=10)
a)      Write any two example of data communication.
b)      What do you mean by web browser?
c)      Write any four advantages of multimedia.
d)     Mention any four symptoms of computer virus.
e)      What is computer security?
2.      a) Convert as instructed:                                                      [2*1=2]
i.(AC3)­16 into Decimal            ii. (110010)2 into Octal
b) Perform the binary Calculation: [21=2]
i.1111-101                            ii.Divide 1010 by 10
3.      Match the following:
Group'A'                                             Group'B'
a)      satellite                                 i) Multimedia
b)      HTTP                                   ii) Protocol
c)      Online business                    iii) Unguided media
d)     Fiber optics                          iv) E-commerce
4.      Choose the correct answer of the following:[40.5=2]
a)      Which is not a communication Media?
i. Wire                      ii. Satelite                   
iii. Microwave             iv. NIC
b)      Which is a web browser software?
i.Windows 2007       ii.Internet Exploer
iii.Windows NT          iv.All of the above
c)      In which topology network devices are connected through hub?
i.Ring topology                       ii. Bus topology
iii.Star topology          iv.None of the above
d)     Which is not related to internet?
i.ISP                ii.TCP/IP         iii. WWW        iv.UPS
5.      Write the appropriate technical terms of following:
a.       An internet tool helps to upload/download the file.
b.      Making duplicat copy of file for security purpose.
c.       A set of rules that governs how computer exchange information over computer Network.
d.      An integration of Audio, Video, Graphics and Text.
6.      Write the full form:
(i) URL                       (ii) ISP             (iii) ASCII       (iv) BPS
Group "B"[10 marks]
Database
7.      Answer the following questions:(3*2=6)
a.       Define DBMS with example.
b.      What is primary key?
c.       Why is report created?
8.      Choose the correct answer:                                                  ( 4*0.5=2)
a.       Which is not a type of query?
i.Search           ii. Select          iii.Update        iv. All of the above
b.      The storage size of data and time is………………..
i.4Bytes                       ii.6Bytes          iii.8Bytes         iv.10Bytes
c.       Collecting multiple related fields is called……………..
i.Records         ii. Table           iii.Forms                      iv. Query
d.      The data type appropriate to store salary is …………………
i.Memo            ii. Currency     iii.Text                         iv. Auto number
9.      Match the following:  (4*0.5=2)
Group'A'                                                         Group'B'
a.       OLE                                                i.Report
b.      Data Entry                                      ii.Picture
c.       Indexing                                         iii. Table
d.      Formatted Printour                         iv. Fast searching
v. Form
Group"C"[18 marks]
C Programming
10.  Answer the following question. (3*1=3)
a) what is procedure?
b) Write any two charachteristics of C Language.
c) Write the function of the following command/statements:
(i) INPUT                    (ii) MKDIR



11.  Write the output of given program:
DECLARE SUB number ()
CLS
CALL number
End
SUB number
N=3
C=1
WHILE C<=5
PRINT N
N=N*10+3
C=C+1
WEND
END SUB
12.  Rewrite the given program after correcting the bugs.                   2
REM to display all the records from sequertial Rem data file ABC.DAT OPEN”ABC.DAT” FOR OUT PUT AS# 1 DO WHILE NOT EOF (“ABC.DAT”)
INPUT # 1, N$,A
PRINT N$,A
CLOSE
END
13.  Read the program given below and answer the questions:           2
DECLEARE SUB(N)
INPUT”ANY NUMBERS”:N
CALL SUM(N)
END
SUB SUM(N)
WHILE N< >0:R=N MOD 10
S=S+R
N=N\10
WEND
PRINT”SUM”;S
END SUM
a.       In which condition the statements within the WHILE…………..WEND looping statement will not be executed?
b.      Will the output be same if the place “\” instead of “/” in the above program?
14.  a) Using FUNCTION…….END FUNCTION write a program to calculate the average of three numbers.                                                3
b) Using SUB………….END SUB write a program to test whether given number is completely divisible by 13 or not.
c) A sequential data file “EMP.DAT” contains name,post and salary fields of information about employees. Write a program to display all the information of employees along with tax amount also (Tax is 15 of salary) .






Group “A”
1.      Answer the following questions:                                          (52=10)
a)      Define LAN topology. Draw the Bus topology.
b)      What is multimedia? Name any two fields where multimedia is used.
c)      Give two advantages of e-mail over traditional mail.
d)     Write any two ways of protecting computer science.
e)      What is antivirus? Name any two antivirus software.
2.      a) Convert as instructed:                                                      [21=2]
i.(7AF)­16 into Binary   ii. (1101101)2 into Octal
b) Perform the binary Calculation: [21=2]
i.1111+11                             ii.Divide 110 by 10
3.      Match the following:
Group'A'                                             Group'B'
a)      Pictures in motions               i) Guide media
b)      TCP/IP                                 ii) Animation
c)      U.T.P                                    iii) Random Access Memory
d)     Volatile memory                  iv) CD-ROM
v) Protocol used in internet
4.      Choose the correct answer of the following:[40.5=2]
a)      E-commerce is………………………….
i.A type of business                         ii.a type of virus                     
iii.both (i) and (ii)                                iv. None of the above
b)      E-mail is a/an………………………………..
i.organization which controls internet       ii.protocol to access internet
iii.service of internet                                 iv.none of the above
c)      Which one is not a type of virus?
i.message carrying virus                      ii. Boot sector virus
iii.system infector                    iv.special purpose application infector
d)     Which one is an example of bounded media?
i.fiber optics    ii.microwave transmission      
iii.laser transmission    iv.infrared transmission
5.      Give the appropriate technical terms of the following:
a.       Network of networks
b.      A device which can convert analog signal to digital codes and vice versa.
c.       An electric device that supply electric current when electricity is cut off.
d.      A company that provides the internet facility.
6.      Write the full form:
(i) FTP             (ii) NIC                       (iii) WAN        (iv) WWW
Group "B"[10 marks]
Database
7.      Answer the following questions:(3*2=6)
a.       What is database? Name any two database software.
b.      Name any four data types that can be defined in MS-ACCESS.
c.       What is a report? Give its importance.
8.      Match the following:  (4*0.5=2)
Group'A'                                                        Group'B'
a.       MS-ACCESS                     i.DATA entry and editing interface
b.      Query                                  ii.Electronic spreadsheet software
c.       Record                                iii. Tool to retrieve data from one or
 More than one tables
d.      Form                                   iv. Data base management software
v. Collection of related fields
9.      State wheather the following statements are true or false:   40.5=2
a)      A query is used to select the fields and records from many tables.
b)      MS-ACCESS is not a spreadsheet software.
c)      Index increases the speed of the query and sort operations.
d)     The primary key field can also be left empty.
e)      Group"C"[18 marks]
f)       C Programming
10.  Answer the following question. (3*1=3)
a)      what is loop?
b)      Name any two data types used in C language.
c)      Give functions of NAME and CLOSE statement.




11.  Rewrite the given program correcting the bugs:                            2
DECLARE SUB Series ()
CLS
EXECUTE Series
END
SUB Series()
REM program to generate 1 1 2 3 5…………up to the 20th
terms
A=1
B=1
FOR ctr = 10 TO 1
DISPLAY A ; B ;
            A = A+B
            B = A+B
            NEXT ctr
END Series
12.  Rewrite the output of the following program.                                2
DECLARE FUNCTION Area (L,B)
CLS
LET L =100
LET B =20
LET ans = area (L,B)
PRINT “The area =”, ans
END
FUNCTION Area (L,B)
ar = L*B
Area = ar
END FUNCTION
13.  Analyze the program given below and answer the questions:      2
DECLARE FUNCTION Prod(A,B)
CLS
INPUT “Enter first number”: A
INPUT “Enter second number”: B
PRINT “The product of the two number=”;Prod(A,B)
END
FUNCTION Prod (A,B)
P = A*B
Prod = p
END FUNCTION
a.       List all the numerical variables used in the program.
b.      List the local variables used in the program.
14.  a) Write a program using FUNCTION……………….END FUNCTION to get a word from the user and then print the world in reverse order.
b) Write a program using SUB…………..END SUB to get radius of a circle and then print its circumference.
c) A sequential data file called ‘MARKS.DAT,contains ROLLNO,NAME,English, Nepali and Mathes fields. Write a program to display all the contents of the data file.



*****************Thank You***********************

Comments

Post a Comment

Popular posts from this blog

File Handling Important questions and Solutions

Image
                                            Jaya Ganeshya 1.     A sequential data file “std.dat” contains Name, class, Roll No. and Address of some students. Write a program to read records and display only those students record whose name starts with alphabet “A” of “a”. 2.     Create a sequential data file “std.dat” to store Name and Mark obtained in English, Math and Science subjects for a few students. 3.     A sequential data file called “MARKS.DAT” contains Roll no. Name, English,Nepali and Maths fields. Write a program to display all the contains of the data file. 4.     Write a program to create a sequential data file “Employee.Dat” to store employees’ Name, Address, Age, Gender and Salary. 5.     A da...
Read more

Test Result 2077/78

ROLL Name GPA 1) AADARSHA SAPKOTA A+ 2) AADITYA SUBEDI B+ 3) AAKANCHHYA POUDEL B+ 4) AAKRITI REGMI B+ 5) AASHIK ADHIKARI B+ 6) AAYUSHMA LAMICHHANE B+ 7) ABIGEL BISHWOKARMA B+ 8) ABIRAL PANTHI A 9) AJAYA ARYAL A+ 10) AKARSHAN POUDEL A 11) AMAN SHRESTHA B 12) AMAN TIWARI B 13) AMIT RANA C+ 14) ANISH TAMANG B 15) ANISH GURUNG B 16) ANJALI ARYAL A+ 17) ANJALI GANDHARBA B 18) ANKITA LAMICHHANE B+ 19) ANU ROKA MAGAR C+ 20) ANUP KANDEL B 21) ANURAG SUBEDI B 22) AONE WAIBA C+ 23) APSON BARAILI B+ 24) ARJUN PUN C+ 25) ASHIKA B.K C+ 26) ASHIM ADHIKARI B+ 27) ASMITA NEPALI C+ 28) BADAL JAISHI B+ 29) BHOJ BAHADUR RINJALI C+ 30) BIBAS THAPA CHHETRI A 31) BIBEK GODAR B 32) BIDHYA ACHARYA A 33) BIJAYA PARIYAR B+ 34) BIMAL CHAND B+ 35) BINA TIWARI B+ 36) BINISHA CHHETRI B+ 37) BINITA TAMANG B+ 38) BIPIN BASTOL...
Read more

Full Form

Full Form 1.       ABC-   Atanasoff Berry Computer 2.       ADSL-   Asymmetric Digital Subscriber Line 3.       AI-    Artificial Intelligence 4.       ANSI-   American National Standards Institute 5.       ARP-  Address Resolution Protocol 6.       ARPANET-   Advance Research Project Agency Network 7.       ASCC-   Automatic Sequence Controlled Calculator 8.       ATM-  Automatic Teller Machine 9.       ASCII-  American Standard Code For Information Interchange 10.   AVI-  Audio Viedo Interleave 11.   BASIC-  Beginner’s All purpose Symbolic Instruction Code 12.   BBS-  Bulletin Board System 13.   ...
Read more