Solved Paper INDIAN BANK COMPUTER OFFICERS EXAM., 2008 (Held on 30-3-2008)

INDIAN BANK COMPUTER OFFICERS (IT) EXAM., 2008

(Held on 30-3-2008)

Professional Knowledge

(Based on Memory)

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 Transaction (SET) specification—

(A) Is a notice, issued and verified 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 Character 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 agreement

(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) 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

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.

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

(D) Remove unnecessary compilers and interpreters.

(E) None 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 messages 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 locations

(E) None of these

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 general-purpose programming language, designed by Sun Microsystems, 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, performs 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 of these

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) None of these

20. 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

21. 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

22. All of 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 processed on the server

(B) SQL statements may be processed on some of the dients

,• (C) Business logic is mostly processed on clients

(D) Business logic may be processed 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 submit your search request to several search engines simultaneously 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 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

29. Graphical diagrams used to represent different multiple perspectives 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 normally used to initialize a computer 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 hardware 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 switching

(B) Frame-tag switching

(C) Cut-through switching

(D) ISL switching

(E) Store-and-backward switching

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 communicate 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 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

38. 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

39. The reason the data outputs of most ROM ICs are tri-state outputs 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 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 wayback machine

(E) None of these

42. 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) Typelock

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 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

47. 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

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 ?

(A) Console port

(B) 

(C) Hostname

(D) SNNIP

(E) Default gateway

50. 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

(8) 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. (0)24. (A) 25. (C)26. (A) 27. (B) 28. (3) 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 Networks.
46 (D) 47. (E) 48. (B) 49. (E) 50. (E)