HSC IT question paper March 2015


Q.1 Fill in the Blanks: [10 marks]

1. To see the limitation of the website and functional features we test the website o different _______________________ Answer-: Browsers
2. ____________________ attribute sets the value to the URL of the document to be loaded into the frame. Answer-: src
3. Target = ________________ will open a link in top frame of the browser window. Answer-: _top
4. _________ means authentication of any electronic records by a subscriber by the means of an electronic method. Answer-: Digital signature
5. __________ is the art of determining what is right and wrong and then doing the right thing. Answer-: Ethics
6. ____________ is the use of information and communication technology to present variety of offerings available in a market segment. Answer-: Electronic Market
7. The _________ layer includes the network applications through which the user interacts. Answer-: Application
8. ____________ provides an interface from a computer to the transmission media. Answer-: Network card
9. When several records in one table are related to several records in another table is called ___________ relationships. Answer-: Many to Many
10. To create purchase order __________ key is used. Answer-: Alt+F4

Q.2 True or False: [10 marks]

1. Target=_top will open the page in top frame of browser window. Answer-: TRUE
2. Cyber crime refers to all the legal and regularly aspects of internet and WWW. Answer-: FALSE
3. As per IT act cheques cannot be in electronic form. Answer-: TRUE
4. Deletion of data is considered as intentional threats. Answer-: TRUE
5. Order and Delivery are the part of presale phase trade cycle. Answer-: FALSE
6. In Ring topology, failure of one computer can affect the whole network. Answer-: TRUE
7. The default selection of Data type is Text Answer-: TRUE
8. If database name is not mentioned, database is stored by database.accdb name. Answer-: TRUE
9. Sales voucher includes all cash sale transactions. Answer-: FALSE
10. User can delete groups from multiple alternation mode. Answer-: TRUE

Q.3 A Multiple Choice Questions (Select 1 Answer): [10 marks]

1. A web ____________ is a software program that runs on a networked computer. Answer-: a

a) server Space b) peripheral
c) site Space d) page

2. __________ style sheet is mainly used when the style to applied to many pages. Answer-: c

a) inline Space b) internal
c) external Space d) none

3. Usemap attribute is used with _______ tag. Answer-: c

a) <area> Space b) <map>
c) <img> Space d) <body>

4. Correct syntax for adding background image ________ Answer-: c

a) <body src=image.gif> Space b) <body image=image.gif>
c) <body background=image.gif> Space d) <img src=image.gif>

5. <blink> tag works in __________________ browser. Answer-: b

a) Internet Explorer Space b) Netscape Navigator
c) Google Chrome Space d) Mozilla Firefox

6. _____________ gives the protection to original work. Answer-: d

a) accesses Space b) addressee
c) user Space d) copyright

7. Private key means ___________ Answer-: a

a) key of a keypair used to create a Digital Signature. Space b) key used by the known persons.
c) key used to operate the number of accounts. Space d) key used to verify digital signature

8. Online trading and auctions are called as ______________ Answer-: a

a) E-market Space b) E-Commerce
c) EDI Space d) Traditional Commerce

9. EDI stands for ___________ Answer-: b

a) Electronic Data Interface Space b) Electronic Data Interchange
c) Electronic Data Interference Space d) Electronic Data Information

10. ___________ is a barrier between two networks. Answer-: a

a) Firewall Space b) Encryption
c) Password Space d) Digital certificate

Q.3 B Multiple Choice Questions (Select 1 Answer): [10 marks]

1. UDP stands for _____________ Answer-: b

a) User Digital Protocol Space b) User datagram Protocol
c) User Dynamic Protocol Space d) User Data Protocol

2. ____________ type of network is used mainly for storage or more than one storage devices connected to each other. Answer-: d

a) LAN Space b) WAN
c) MAN Space d) SAN

3. The ________ layer contains a variety of protocols. Answer-: c

a) Data link Space b) Presentation
c) Application Space d) Network

4. ARP stands for __________ Answer-: c

a) Address Reserve Protocol Space b) Address Reverse Protocol
c) Address Resolution Protocol Space d) Address Reminder Protocol

5. The collection of information is _________ Answer-: c

a) Data Space b) Fields
c) database Space d) Record

6. In MS-Access ___________ type of relationship can be created. Answer-: b

a) One-to-Two Space b) Many to many
c) three to four Space d) one to infinite

7. A _________ is centrally controlled collection fo data in an organization. Answer-: b

a) Table Space b) Database
c) Report Space d) View

8. In ____ debit side total always matches with credit side total. Answer-: b

a) Journal Space b) Balance Sheet
c) Ledger Space d) Cost Centre

9. In tally to print sales invoice ______ function key is used. Answer-: a

a) Alt+P Space b) Ctrl+P
c) Ctrl+C Space d) Ctrl+A

10. To create a new ledger in voucher entry screen ______ key is used. Answer-: d

a) Ctrl+C Space b) Ctrl+N
c) Ctrl+2 Space d) Alt+C

Q.4 Multiple Choice Questions (Select 2 Answers): [10 marks]

1. The attributes of <bgsound> tags are ___________________ Answer-: b d

a) name Space b) src
c) autoplay Space d) loop
  Space e) auto

2. In MS-Access table can be created using __________ Answer-: a d

a) Design view Space b) Pages
c) Database view Space d) Datasheet view
  Space e) Sorting

3. EDI is commonly applied to following phase of trade cycle. Answer-: b c

a) presale Space b) execution
c) settlement Space d) after sales
  Space e) negotiable

4. Which are the following are transmission media? Answer-: b d

a) Modem Space b) Co-axial cable
c) Hub Space d) Fiber Optic
  Space e) Multiplexer

5. Alt+D is used to delete following: Answer-: d e

a) Date Space b) Time
c) period Space d) Sales order
  Space e) Invoice

Q.5 Multiple Choice Questions (Select 3 Answers): [6 marks]

1. The attributes of the <area> tag are as follows Answer-: a b f

a) alt Space d) src
b) coords Space e) map
c) points Space f) href

2. Different types of queries in MS Access are __________ Answer-: a b d

a) Action Query Space d) Select Query
b) Special Purpose Query Space e) Table Query
c) Database Query Space f) Change Query

Q.6 Rearrange the Following: [4 marks]

1. Rearrange the following Answer-: bedcafg

a) <frame src="first page.html">
b) <html><head>
c) <frameset rows="30%,*>
d) </head>
e) <title>create frames</title>
f) <frames src="secondpage.html">
g) </html>

Answer: _____________________________

2. To delete a company following steps are used: Answer-: dfacbe

a) Press A key to select Alter option.
b) Select the company name to delete from hard disk.
c) Tally displays list of companies already created.
d) Open Gateway of Tally.
e) Press Alt + D
f) Press Alt + F3 to invoke Company info menu.

Answer: _____________________________

Q.7 Short Q. Answers: [10 marks]

1. List Dos and Donts for the ethics culture of Computer professionals.
2. What is E-Market.
3. Explain the concept of Primary key in MS-Access

Q.8 Write Program: [10 marks]

1. Write html program to display menu card of "HOTEL DERBI" with heading and minimum 3 Veg and Non-Veg items displayed in checkboxes and place "ORDER"
2. Write html code to display a text Mobile World having font size 24, background color red and blinking effect using CSS.