Indian Bank Computer Officers Exam, 2008

1. A passive threat to computer security is-
(A) Malicious Intent (B) Sabotage (C) Accidental Errors (D) Espionage Agents (E) None of these
2.The Secure Electronic Transac­tion (SET) specification-
(A) Is a notice, issued and veri­fied 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 scheme for the 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
3..................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
4.'DOS' floppy disk does not have-
(A) A Boot Record
(B) A File Allocation Table (C) A Root Directory
(D) Virtual Memory
(E) BIOS
5.'MICR' technology used for clearance of cheques by banks refers to-
(A) Magnetic Ink Character Recognition
(B) Magnetic Intelligence Char­acter Recognition
(C) Magnetic Information Cable Recognition
(D) Magnetic Insurance Cases Recognition
(E) None of these
6.All the information collected during database development is stored in a-
(A) Repository
(B) Data warehouse (C) RAD
(D) CASE
(E) None of these
7.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
8.A(n)................allows network
users to share a single copy of software, which resides on the network server.
(A) Single-user license agree­ment
(B) Network site license
(C) End-user license agreement (D) Business software license (E) None of these
9.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 a legitimate program
(D) Infects a program file, but still reports the size and creation date of the original, uninfected program
(E) None of these
10.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 I Easy or promlsmg 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) :\ one of these
11.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.
(e) Add demo programs, so users can test system without accessing production data
(D) Remove unnecessary compi­lers and interpreters.
(E) ~ one of these
12.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
13.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
14.Voice mail-
(A) Is the exchange of text mes­sages and computer files trans­mitted via a communications net­work such as a local area net­work 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 loca­tions
(E) None ofthese
15.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
16.Which of the following is a gene­tal-purpose programming lan­guage, designed by Sun Micro­systems, and well suited for use on the Web?
(A) VB Script
(B) Java Script
(C) CSS
(D) Java
(E) None of these
17.This.............tier processes HTTP
protocol, scripting tasks, per­forms calculations, and provides access to data.
(A) Client
(B) Applications/Web server
(C) Enterprise server
(D) DBA
(E) None of these
18.RSA is-
(A) Symmetric Cryptosystem (B) Asymmetric Cryptosystem (C) Block Cypher
(D) Digital Signature
(E) None ofthese
19.A DVD-RAM is similar to a ...........except it has storage capacities up to 5.2 GB.
(A) CD-R
(B) floppy disk
(C) CD-RW
(D) hard disk
(E) N one of these
20.When you are selecting a mouse for a particular computer system, what is the most important con­sideration ?
(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
21.How is power supplied to a low­power USB device?
(A)Through a power cable
(B) From an external power
(C) Directly from the computer's power supply
(D) Through the USB cable
(E) None of these
22.All the following are basic principles of networks, except
(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
23.This.............data mining technique
derives rules from real-world case examples.
(A) Rule discover
(B) Signal processing
(C) Neural nets
(D) Case-based reasoning
(E) None of these
24. ..... are used to identify a user who returns to a Website.
(A) Cookies (B) Plug-ins
(C) Scripts (D) ASPs
(E) None of these
25.Which of the following statements is not true about two-tier client-server database architecture?
(A) SQL statements are proces­sed on the server
(B) SQL statements may be pro­cessed on some of the clients
(C) Business logic is mostly pro­cessed on clients
(D) Business logic may be pro­cessed on the server
(E) None of these
26.Which one of the following objects is passed to a JavaBean 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
27.Programs that automatically sub­mit your search request to seve­ral search engines simultaneou­sly are called-
(A) Metasearch engines
(B) Webcrawlers
(C) Spiders
(D) Hits
(E) None of these
28.In Oracle, which statement is true about segments?
(A) Each table has its own seg­ment
(B) A segment is created every time an extent is created, exten­ded, or altered
(C) An index segment is created every time a table is created
(D) A segment is deleted when­ever a table is truncated
(E) None of these
29.Graphical diagrams used to represent different multiple pers­pectives of a system include--
(A) Use-case, class and state diagrams
(B) State, interaction, derivative diagrams
(C) Interaction, relationship and class diagrams
(D) Deployment, relationship and use-case diagrams
(E) None of these
30.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
31.Which of the following are nor­mally used to initialize a compu­ter system's hardware?
(A) Bootstrap memory
(B) Volatile memory
(C) External mass memory (D) Static memory
(E) Random access memory
32.If you wanted to locate the hard­ware address of a local device, which protocol would you use?
(A) ARP
(B) RARP
(C) ICMP
(D) PING
(E) PONG
33.Which of the following switching methods provides the greatest
frame throughput?
(A) Store-and-forward ching
(B) Frame-tag switching
(C) Cut-through switching
(D) ISL switching
(E) Store-and-backward swit­ching
34.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) 255

35.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
36.If 20 people need to communi­cate using symmetric-key cryptography, .............symmetric keys
are needed.

(A) 190
(B) 200
(C) 20
(D) 19
(E) 210
37.What is Internet 2 ?
(A) A new type of cabling sys­tem 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
38.In Oracle, which tables pace is the minimum required when crea­ting a new database?
(A) Undo tablespace
(B) Temporary tablespace (C) System tablespace
(D) Users tablespace
(E) None of these
39.The reason the data outputs of most ROM ICs are tri-state out­puts 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 many ROM chips to a common data bus
(D) Isolate the registers from the data bus during read operations
(E) None of these
40.The term, 'hypertext', means­(A) Non-sequential writing (B) Hypermedia
(C) Blinking text
(D) Text with heavy formatting (E) None of these
41.While searching a website, you have been unable to find infor­mation that was on the site seve­ral months ago. What might you do to attempt to locate that infor­mation?
(A) Visit Coogle'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 wayback machine (E) None of these
42.Which kind of lock includes a keypad that can be used to cont­rol access into areas?
(A) Cipher (C) Device (E) Typelock
(B) Warded (D) Tumbler
43.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
44.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
45.What is the name of the protocol used to eliminate loops?
(A) Switching
(B) ISL
(C) Frame tagging
(D) Spanning Tree Protocol (E) Scanning
46.The process by which the struc­ture of the database is modified to eliminate hidden dependen­cies and repeating groups is­(A) Enforcing data integrity
(B) Enforcing referential integ­rity
(C) Indexing
(D) Normalization (E) None of these
47.Which of the following describes programs that can run indepen­dently, travel from system to system, and disrupt computer communications?
(A) Trojans (B) Viruses
(C) Idlers (D) Droppers
(E) Worms
48.In Oracle, who owns the data dictionary ?
(A) Oracle
(B) SYS
(C) The DBA
(D) SYSTEM
(E) None of these

49.You need to configure a switch from a remote subnet. Which of the following must be configured on the switch ?
Continued from Page 502
(A) Console port
(B) IP
(C) Hostname
(D) SNMP
(E) Default gateway

50.In Oracle, which is more appro. priate to store a small list of values in a single column in each row in your address table?
(A) ORACARRA Y
(B) Nested table
(C) Index organized table (D) Index
(E) VARRAY

Answers.
1. (B) 2. (D) 3. (C) 4. (A) 5. (A) 6. (D) 7. (B) 8. (A) 9. (A) 10. (C) 11. (A) 12. (C) 13. (D) 14. (C) 15. (C) 16. (D) 17. (B) 18. (B) 19. (C) 20. (A) 21. (B) 22. (D) 23. (D) 24. (A) 25. (C) 26. (A) 27. (B) 28. (B) 29. (A) 30. (C) 31. (A) 32. (A) 33. (C) 34. (D) 35. (A) 36. (A) 37. (D) 38. (A) 39. (D) 40. (A)
41.(A)42. (B) Warded locks are the weakest form of Padlock, device locks are used to secure equipment, and tumbler locks are more complex than warded locks and offer greater security.
43.(E) 44. (B) 45.(D) The Spanning Tree Protocol is used to remove circular routes in bridge and switched Net. works.
46. (D) 47. (E) 48. (B) 49. (E) 50. (E)