This post contains a practice set of 50 questions of Indian Bank I.T. officer the previous year solved 2011 paper in single choice. It helps you to analyze your performance while preparing for the I.T. officer exam.

General Instructions:

Your online test contain 50 multiple choice question with one correct answer.
Each correct answer carries equal marks i.e. 1.

Page 1 of 5

1. In Oracle, who owns the data dictionary ?

A.Oracle.

B.SYS.

C.The DBA.

D.SYSTEM.

E.None of these.

2. A DVD-RAM is similar to a _______________ expect it has storage capacities up to 5.2 GB.

A.CD-R.

B.Floppy Disk.

C.CD-RW.

D.Hard Disk.

E.None of these.

3. A passive threat to computer Security is

A.Malicious Intent.

B.Sabotage.

C.Accidental Errors.

D.Espionage Agents.

E.None of these.

4. In Oracle, which is more appropriate to store a small list of values in a single column in each row in your address table ?

A.ORACARRAY.

B.Nested table.

C.Index organized table.

D.Index.

E.VARRAY.

5. Which is NOT a good web security strategy?

A.Restrict access to the web server; keep a minimum number of ports open.

B.Limit the users who can load software, edit or add files.

C.Add demo programs, so users can test system without accessing production data.

D.Remove unnecessary compilers and interpreters.

E.None of these.

6. RSA is __________________.

A.Symmetric Cryptosystem.

B.Asymmetric Cryptosystem.

C.Block Cipher.

D.Digital Signature.

E.None of these.

7. A _________________ sometimes called a boot sector virus, executes when a computer boots up because it resides in the boot sector of a floppy disk or the master boot record of a hard disk.

A.System Virus.

B.Trojan Horse Virus.

C.File Virus.

D.Macro Virus.

E.None of these.

8. This _______________ tier processes HTTP protocol, scripting tasks, performs calculations, and provides access to data.

A.Client.

B.Applications / Web Server.

C.Enterprise Server.

D.DBA.

E.None of these.

9. In Oracle, which tablespace is the minimum required when creating a new database ?

A.Undo tablespace.

B.Temporary tablespace.

C.System tablespace.

D.Users tablespace.

E.None of these.

10. The process by which the structure of the database is modified to eliminate hidden dependencies and repeating groups is ________________.

A.Enforcing data integrity.

B.Enforcing referential integrity.

C.Indexing.

D.Normalization.

E.None of these.

Page 2 of 5

11. In Oracle, which statement is true about segments?

A.Each table has its own segment.

B.A segment is created every time an extent is created, extended, or altered

C.An index segment is created every time a table is created.

D.A segment is deleted whenever a table is truncated.

E.None of these.

12. Graphical diagram used to represent different multiple perspectives of system include____________.

A.Use-Case, Class, and State Diagram.

B.State, Interaction, Derivative Diagram.

C.Interaction, Relationship and Class Diagram.

D.Deployment, Relationship and Use-Case Diagram.

E.None of these.

13. This ____________ data mining technique devices rules from real-world case examples.

A.Rule discover.

B.Signal processing.

C.Neural nets.

D.Case-based reasoning.

E.None of these.

14. ____________________ are used to identify a user who returns to a website.

A.Cookies.

B.Plug-Ins.

C.Scripts.

D.ASPs.

E.None of these.

15. What is the name of protocol used in eliminate loops ?

A.Switching.

B.ISL.

C.Frame tagging.

D.Spanning Tree Protocol.

E.None of these.

16. Database redesign is not terribly difficult if the ______________.

A.Database is structured.

B.Database is well-designed.

C.Database has no data.

D.Database is relatively small.

E.Database is relatively large.

17. All of the following are basic principles of networks, expect _________________.

A.Each computer must have a network card.

B.There must be communications media connecting the network hardware devices.

C.There must be at least one connecting device.

D.Each computer must have software that supports the movement of information.

E.None of these.

18. Voice mail __________________.

A.Is the exchange of text message and computer files transmitted via a communications network such as a local area network or the internet.

B.Permits users to converse in real time with each other via the computer while connected to the internet.

C.Functions much like an answering machine, allowing callers to leave a voice message for the called party.

D.Involves using video and computer technology to conduct a meeting between participants at geographically separate location.

E.None of these.

19. A communication processor that connects dissimilar networks by providing the translation from one set of protocol to another is___________________.

A.Bridge.

B.Gateway.

C.Router.

D.Modem.

E.All of these.

20. The secure electronic transaction (SET) specification

A.Is a notice, issued and verified by a certificate authority by a certificate authority, that guarantees a user or web site is legitimate.

B.Provides private-key encryption of all data that passes between a client and a server.

C.Allows users to choose an encryption of all data that passes between a client and a server.

D.Uses a public-key encryption to secure credit-card transaction systems.

E.None of these.

Page 3 of 5

21. The word FTP stands for____________.

A.File Translate Protocol.

B.File Transit Protocol.

C.File Typing Protocol.

D.File Transfer Protocol.

E.None of these.

22. How is power supplied to a low-power USB device?

A.Through a power cable.

B.From an external power supply.

C.Directly from the computer's power supply.

D.Through the USB cable.

E.None of these.

23. The ______________________ component is used by the data analyst to create the queries that access the database.

A.Data Extraction.

B.End-User Query Tool.

C.End-User Presentation Tool.

D.Data Store.

E.None of these.

24. You need to configure a switch from a remote subnet. Which of the following must be configured on the switch?

A.Console port.

B.IP.

C.Hostname.

D.SNMP.

E.Default gateway.

25. 'MICR' technology used for clearance of cheques by banks refers to________________.

A.Magnetic Ink Character Recognition.

B.Magnetic Intelligence Character Recognition.

C.Magnetic Information Cable Recognition.

D.Magnetic Insurance cases Recognition.

E.None of these.

26. A(n) _______________ allows network users to share a single copy of software, which resides on the network server.

A.Single-user License Agreement.

B.Network Site License.

C.End-user license Agreement.

D.Business Software License.

E.None of these.

27. While searching a website, you have been unable to find information that was on the site several months ago. What might you do to attempt to locate that information?

A.Visit Google's cached page to view the older copy.

B.Forget about it, as there is no way to find this information.

C.Visit a partner site of the organization to see if it is there.

D.Use the way back machine.

E.None of these.

28. The term "hypertext," means ______________.

A.Non-Sequential writing.

B.Hypermedia.

C.Blinking text.

D.Text with heavy formatting.

E.None of these.

29. Which of the following statements is not true about two-tier client server database architecture ?

A.SQL statements are processed on the server.

B.SQL statements may be processed on some of the clients.

C.Business logic is mostly processed on clients.

D.Business logic may be processed on the server.

E.None of these.

30. Programs that automatically submit your search request to several search engines simultaneously are called_________.

A.Metasearch engines.

B.WebCrawler.

C.Spiders.

D.Hits.

E.None of these.

Page 4 of 5

31. The altering of data so that it is not usable unless the changes are undone is _______________.

A.Biometrics.

B.Compression.

C.Encryption.

D.Ergonomics.

E.None of these.

32. 'DOS' floppy disk does not have_________________.

A.A Boot Record.

B.A File Allocation Table.

C.A Root Directory.

D.Directory Structure.

E.BIOS.

33. All the information collected during database development during database development is stored in a _________________.

A.Repository.

B.Data Warehouse.

C.RAD.

D.CASE.

E.None of these.

34. What is Internet 2?

A.A new type of cabling system for wide area networks.

B.A second local area network that can connect with another online LAN to share access.

C.A new standard for Internet browsers.

D.An association to develop advanced internet technology.

E.None of these.

35. In oracle, what is the default number of transactions that MAXTRANS is set to if not specified?

A.512

B.10

C.40

D.1

E.225

36. Microwave transmission is used in environments where installing physical transmission media is______________________.

A.Difficult or impossible and where line-of-sight transmission is unavailable.

B.Easy or Promising and where line-of-sight transmission is unavailable.

C.Difficult or Impossible and where line-of-sight transmission is available.

D.Easy or promising and where line-of-sight transmission is available.

E.None of these.

37. Which of the following switching methods provides the greatest frame throughput?

A.Store-and-forward switching.

B.Frame-tag-switching.

C.Cut-through switching.

D.ISL switching.

E.Store-and-backward switching.

38. To which pin on the RAM chip does the address decoder connect in order to signal which memory chip is being accessed?

A.The address input.

B.The output enable.

C.The chip enable.

D.The data input.

E.The data output.

39. ___________________ allows wireless mobile devices to access the internet and its services such as the Web and e-mail.

A.TCP/IP.

B.Ethernet.

C.WAP.

D.Token Ring.

E.None of these.

40. Which one of the following objects is passed to a Java Bean when one of its properties is set via a JSP action?

A.Servlet Request.

B.http Servlet Request.

C.Servlet Response.

D.http Servlet Response.

E.None of these.

Page 5 of 5

41. Which of the following is a general-purpose programming language , designed by Sun Microsystems, and well suited for use on the Web ?

A.Bridge.

B.Gateway.

C.Router.

D.Modem.

E.All of these.

42. If 20 people need to communicate using symmetric-key cryptography,_______________ symmetric keys are needed.

A.190

B.200

C.20

D.19

E.210

43. Which of the following describes programs that can run independently, travel from system to system, and disrupt computer communications?

A.Trojans.

B.Viruses.

C.Idlers.

D.Droppers.

E.Worms.

44. When you are selecting a mouse for a particular computer system, what is the most important consideration?

A.The type of drivers that come with the mouse.

B.The length of the mouse cord.

C.The Type of connector the mouse is equipped with.

D.The number of buttons the mouse has.

E.None of these.

45. Which kind of lock includes a keypad that can be used to control access into areas?

A.Cipher.

B.Warded.

C.Device.

D.Tumbler.

E.Type lock.

46. If you wanted to locate the hardware address of a local device, which protocol would you use?

A.ARP.

B.RARP.

C.ICMP.

D.PING.

E.PONG.

47. In the straight CGI approach to database connectivity on the Internet________________.

A.The external program is located between the client and the web server.

B.The external program is located between the database server and the database.

C.The external program is located between the web-server and the database server.

D.There is no external program.

E.None of these.

48. Which of the following are normally used in initialize a computer system's hardware?

A.Bootstrap Memory.

B.Volatile Memory.

C.External mass memory.

D.Static memory.

E.Random access memory.

49. The reason the data outputs of most ROM ICs are tri-state output is to _________________.

A.Allow for three separate data input lines.

B.Allow the bidirectional flow of data between the bus lines and the ROM registers.

C.Permit the connection of may ROM chips to a common data bus.

D.Isolate her registers from the data bus during read operations.

E.None of these.

50. A Polymorphic Virus ______________.

A.Modifies its program code each time it attaches itself to another program or file.

B.Is a malicious-logic program that copies itself repeatedly in memory or on a disk drive until no memory or disk space remains.

C.A malicious-logic program that hides within or looks like legitimate program.

D.Infects a program file, but still reports the size and creation data of the original, uninfected program.

E.None of These.

Indian Bank I.T. Officer Previous Year Solved Paper 2011

General Instructions:

Your online test contain 50 multiple choice question with one correct answer.

Each correct answer carries equal marks i.e. 1.

Related