1. Home
  2. Previous Year Papers
  3. IBPS SO
  4. 2015
Institute of Banking Personnel Selection (IBPS) · Mains

IBPS SO IT Officer Professional Knowledge Paper Question Paper – 2015 (with Answers)

All 50 questions of the 2015 paper, with all the options and the correct answer. Read it here, or take the same paper as a timed test and see your score and rank.

Disclaimer: We do not own this question paper or its questions. They belong to the government body that conducted the examination. The paper is shared here in good faith, free of cost, only to help students prepare better.

50Questions
50 minDuration
+1 / −0.25Marking
2015Exam date
  1. Q.1Professional Knowledge
    The CMM Level at which measurable goals for quality and productivity are established in
    1. Level 1
    2. Level 3
    3. Level 5
    4. Level 4
    5. Level 2
    Show answer

    Correct answer: option4 — Level 4

  2. Q.2Professional Knowledge
    When you will visit websites spyware may be substantially downloaded. This is called a
    1. logic bomb
    2. drive – by download
    3. Virus
    4. drive – in download
    5. spyot
    Show answer

    Correct answer: option2 — drive – by download

  3. Q.3Professional Knowledge
    Malicious software is known as
    1. disasterware
    2. badware
    3. illegalware
    4. malware
    5. maliciousware
    Show answer

    Correct answer: option4 — malware

  4. Q.4Professional Knowledge
    A data structure where elements can be added or removed at either end but not in the middle is called
    1. requeue
    2. queues
    3. dequeue
    4. linked lists
    5. stacks
    Show answer

    Correct answer: option3 — dequeue

  5. Q.5Professional Knowledge
    Which of the following are placeholders for literal value in a SQL query being sent to the database
    1. reduction and resolution variables
    2. resolution variables
    3. reduction variables
    4. assimilation variables
    5. bind variables
    Show answer

    Correct answer: option5 — bind variables

  6. Q.6Professional Knowledge
    In TPS systems, an output that signifies that a specific transaction has taken place is called a (n)
    1. detail report
    2. action document
    3. inception report
    4. exception report
    5. Summary report
    Show answer

    Correct answer: option2 — action document

  7. Q.7Professional Knowledge
    ________ is the process whereby media files such as a video start playing as they are downloading
    1. Streaming
    2. Pushing
    3. Dragging
    4. Flashing
    5. Pulling
    Show answer

    Correct answer: option1 — Streaming

  8. Q.8Professional Knowledge
    Which of the following statements about Stacks is incorrect?
    1. New nodes can only be added to the top of the stack
    2. Stacks can be implemented using linked lists
    3. Stacks are first – in, first – out data structures
    4. The last node (at the bottom) of a stack has a null(0) link
    5. stacks are very useful
    Show answer

    Correct answer: option3 — Stacks are first – in, first – out data structures

  9. Q.9Professional Knowledge
    The UML designation for a public class member is
    1. the symbol @
    2. the symbol #
    3. the minus symbol (-)
    4. The plus symbol (+)
    5. The word public
    Show answer

    Correct answer: option4 — The plus symbol (+)

  10. Q.10Professional Knowledge
    what type of join is needed when you wish to include rows that do not have matching values?
    1. Equi - join
    2. Indefinite join
    3. Intermediate join
    4. Natural join
    5. Outer join
    Show answer

    Correct answer: option5 — Outer join

  11. Q.11Professional Knowledge
    A home page is
    1. the web page that identifies a website
    2. a webpage you eventually reach by clicking a series of hyperlinks
    3. a webpage created by an individual home user, as opposed to the one created by a corporation
    4. the last page of the website
    5. the web page you like to visit the most
    Show answer

    Correct answer: option1 — the web page that identifies a website

  12. Q.12Professional Knowledge
    A network covering a large geographic area is usually referred to as a(n)
    1. huge area network
    2. wide area network
    3. internetwork
    4. local area network
    5. intranet
    Show answer

    Correct answer: option2 — wide area network

  13. Q.13Professional Knowledge
    Frame relay
    1. does not use error correction routines
    2. is used by facsimile machines
    3. uses error – correction routines
    4. does not work weel on the internet
    5. is an outdated technology
    Show answer

    Correct answer: option1 — does not use error correction routines

  14. Q.14Professional Knowledge
    The design tool used to illustrate the logic of a new computer software logic diagram that uses symbols to represent program elements is called a (n)
    1. data logic chart
    2. data flow diagram
    3. software logic diagram
    4. system flow chart
    5. entry relationship illustration
    Show answer

    Correct answer: option4 — system flow chart

  15. Q.15Professional Knowledge
    A web facility that helps to find sites with the information and / or services that is desired is
    1. a hyperlink
    2. the top inner domain
    3. a search engine
    4. a network access point
    5. a blog
    Show answer

    Correct answer: option3 — a search engine

  16. Q.16Professional Knowledge
    When new data are to be inserted into a data structure but there is not available space ; this situation is usually called
    1. underflow
    2. overflow
    3. Houseful
    4. saturated
    5. empty
    Show answer

    Correct answer: option2 — overflow

  17. Q.17Professional Knowledge
    A _____________ is an acrylic diagraph, which has only node with in – degree 0, and other nodes have in degree 1.
    1. Dis – joint tree
    2. Direction oriented tree
    3. Directed tree
    4. Diagonalised tree
    5. Undirected tree
    Show answer

    Correct answer: option3 — Directed tree

  18. Q.18Professional Knowledge
    Which of the following are true of XML ?
    1. XML is too complicated.
    2. XML is difficult to learn
    3. XML is a set of tags designed to tell browsers how to display text on a webpage
    4. XML is a set of rules for creating tags to describe data
    5. XML is a set of tags designed to tell browsers how to display images on a webpage
    Show answer

    Correct answer: option4 — XML is a set of rules for creating tags to describe data

  19. Q.19Professional Knowledge
    Which of the following forms does not describe parallel ATA devices?
    1. SCSI
    2. IOE and DOE
    3. IOE
    4. DOE
    5. ATA
    Show answer

    Correct answer: option1 — SCSI

  20. Q.20Professional Knowledge
    _____________ maps domain name to their IP addresses.
    1. Wi - Fi
    2. DNS
    3. HTML
    4. XML
    5. Java
    Show answer

    Correct answer: option2 — DNS

  21. Q.21Professional Knowledge
    Every host computer on the internet has a (n)
    1. similar IP address
    2. unique 10 – digit number
    3. common name and number
    4. unique IP address
    5. Unique 15 – digit number
    Show answer

    Correct answer: option4 — unique IP address

  22. Q.22Professional Knowledge
    Which of the following are five built – in functions provided by SQL?
    1. SUM, AVG, MIN, MAX, NAME
    2. MIN, MAX, MULT, DIV, NAME
    3. SUM, AVG, MULT, DIV, MIN
    4. SUM, AVG, MIN, MAX, MULT
    5. COUNT, SUM, AVG, MAX, MIN
    Show answer

    Correct answer: option5 — COUNT, SUM, AVG, MAX, MIN

  23. Q.23Professional Knowledge
    Common Gateway Interface (CGI) is which of the following?
    1. An interface that accepts and returns data that may be written in SQL
    2. A small program that executes within other application and is stored on the server
    3. A small program that executes within other application and is stored on the client
    4. A small program that executes within other application and is stored on the client or the server
    5. An interface that accepts and returns data that may be written in any language that produces executable file
    Show answer

    Correct answer: option5 — An interface that accepts and returns data that may be written in any language that produces executable file

  24. Q.24Professional Knowledge
    Which of the following wildcard masks is most useful for matching all IP packets in subnet 10.1.128.0, mask 255.255.255.0?
    1. 0.0.0.0
    2. 0.0.0.255
    3. 0.0.0240
    4. 0.0.0.31
    5. 0.0.15.0
    Show answer

    Correct answer: option2 — 0.0.0.255

  25. Q.25Professional Knowledge
    Which of the following is not a testable Web App security element?
    1. Encryption
    2. Authentication and Encryption
    3. Firewalls
    4. Authentication
    5. Penetration
    Show answer

    Correct answer: option5 — Penetration

  26. Q.26Professional Knowledge
    _________ are two Important technologies for developing the Semantic web
    1. XML and RDF
    2. XML and HTML
    3. RDF and HTML
    4. Wi-Fi and RDF
    5. Wi-Fi and XML
    Show answer

    Correct answer: option1 — XML and RDF

  27. Q.27Professional Knowledge
    In what kind of storage, we can easily insert, delete, concatenate and reaarange substrings?
    1. Stack
    2. Linked list
    3. Dedicated list
    4. Queue
    5. Array
    Show answer

    Correct answer: option2 — Linked list

  28. Q.28Professional Knowledge
    Web Pages can be created using
    1. only Web authoring software
    2. only macromedia Dreamweaver
    3. any Word processor
    4. only Microsoft products
    5. only Microsoft Front Page
    Show answer

    Correct answer: option3 — any Word processor

  29. Q.29Professional Knowledge
    Which of the following techniques provides redundancy by using two disks and two controllers?
    1. Disk striping
    2. Disk striping with parity
    3. Drive mirroring
    4. Drive mirroring and disk striping
    5. Drive duplexing
    Show answer

    Correct answer: option5 — Drive duplexing

  30. Q.30Professional Knowledge
    _________ is the term for the use of deception to get someone’s sensitive information
    1. Identity theft
    2. Personal engineering
    3. Spoofing
    4. Social engineering
    5. Hacking
    Show answer

    Correct answer: option4 — Social engineering

  31. Q.31Professional Knowledge
    In addition to an internet connection, which of the following is needed to?
    1. Telnet client
    2. Scanner
    3. Mail client
    4. HP client
    5. Web browser
    Show answer

    Correct answer: option5 — Web browser

  32. Q.32Professional Knowledge
    A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is not one of those functions?
    1. Data integrity management
    2. Data reports
    3. Security and storage management
    4. Data storage management
    5. Security management
    Show answer

    Correct answer: option2 — Data reports

  33. Q.33Professional Knowledge
    A procedural program stores __________ in a collection of variables and a set of _______ performs operations on it.
    1. parameters ; arguments
    2. data ; functions
    3. assets ; actions
    4. strings ; operators
    5. numbers ; arguments
    Show answer

    Correct answer: option2 — data ; functions

  34. Q.34Professional Knowledge
    Which of the following is the phase of SDLC in which the identified requirements are incorporated into the new system’s design
    1. Maintenance
    2. Physical Layout
    3. Requirement design
    4. Systems design
    5. System blueprint
    Show answer

    Correct answer: option3 — Requirement design

  35. Q.35Professional Knowledge
    What does DLCI stand for?
    1. Data Link Circuit Identifier
    2. Data Link Connection interrupt
    3. Data Link Connection Indicator
    4. Data Link Circuit Indicator
    5. Data Link Connection Identifier
    Show answer

    Correct answer: option5 — Data Link Connection Identifier

  36. Q.36Professional Knowledge
    What standard Java Package is used to move the cursors?
    1. Javax swing
    2. java cio
    3. java lo
    4. java facio
    5. java awt event
    Show answer

    Correct answer: option5 — java awt event

  37. Q.37Professional Knowledge
    A communications medium where data are transformed into lights pulses is
    1. coaxial cable
    2. optical fibre
    3. satellite
    4. twisted – pair cable
    5. Copper cable
    Show answer

    Correct answer: option2 — optical fibre

  38. Q.38Professional Knowledge
    __________ is a standard for security that is inclined at the network or packet processing layer of network communications, as opposed to the application layer.
    1. Passive FTP
    2. TCP
    3. SSL
    4. S – HTTP
    5. IPsec
    Show answer

    Correct answer: option5 — IPsec

  39. Q.39Professional Knowledge
    Locking may cause which of the following problems?
    1. Deadlock
    2. Versioning
    3. Versioning and Deadlock
    4. Erroneous updates
    5. Erroneous updates and deadlock
    Show answer

    Correct answer: option1 — Deadlock

  40. Q.40Professional Knowledge
    Which of the following is not a WebApp Interface mechanism ?
    1. Links
    2. Cookies
    3. Browser
    4. Cookies and Links
    5. Forms
    Show answer

    Correct answer: option3 — Browser

  41. Q.41Professional Knowledge
    _________ is one of the older and slowest methods an intruder might use to scan a network to determine which of a range of IP addresses map to live hosts.
    1. Ping sweep
    2. Phreaking
    3. Smurfing
    4. War driving
    5. Brute force cracking
    Show answer

    Correct answer: option1 — Ping sweep

  42. Q.42Professional Knowledge
    which of the following is used to create and delete views and relations within tables?
    1. SQL Data Identification Language
    2. SQL Data Identification and Manipulation Language
    3. SQL Data Relational Language
    4. SQL Data Definition Language
    5. SQL Data Manipulation Language
    Show answer

    Correct answer: option4 — SQL Data Definition Language

  43. Q.43Professional Knowledge
    Criminal hacking is called
    1. cracking
    2. a virus
    3. a trojan horse
    4. a worm
    5. blasting
    Show answer

    Correct answer: option1 — cracking

  44. Q.44Professional Knowledge
    Backword recovery is which of the following?
    1. Where the before – images are applied to the database
    2. Where the after – images and a = before – images are applied to the database.
    3. Where the after – images are applied to the database
    4. Continuing without any recovery
    5. Switching to an existing copy of the database
    Show answer

    Correct answer: option1 — Where the before – images are applied to the database

  45. Q.45Professional Knowledge
    ________ is the integration of economic, social, cultural and ecological facets of life, enabled by information technologies.
    1. Business environment
    2. Neutralisation
    3. Nationalisation
    4. Regionalisation
    5. Globalisation
    Show answer

    Correct answer: option5 — Globalisation

  46. Q.46Professional Knowledge
    ________ is the process and tools used by managers and executives with the support of the project team to manage employee resistance.
    1. Resistance management
    2. Change management
    3. Detailing management
    4. Probing management
    5. Blasting management
    Show answer

    Correct answer: option1 — Resistance management

  47. Q.47Professional Knowledge
    A cross life – cycle activity of system development is
    1. data modeling
    2. fact finding
    3. prototyping
    4. data flow diagram modeling
    5. object modeling
    Show answer

    Correct answer: option2 — fact finding

  48. Q.48Professional Knowledge
    The result of a SQL SELECT statement is a(n)
    1. report
    2. file
    3. page
    4. table
    5. form
    Show answer

    Correct answer: option4 — table

  49. Q.49Professional Knowledge
    Web App performance tests are designed to
    1. assess Web App usability
    2. test network performance
    3. test network connectivity
    4. evaluate page loading times
    5. simulate real – world loading situations
    Show answer

    Correct answer: option5 — simulate real – world loading situations

  50. Q.50Professional Knowledge
    A CASE SQL statement is which of the following?
    1. A way to establish a data definition in SQL or establish a loop in SQL
    2. A way to establish an IF – THEN – ELSE in SQL
    3. A way to establish a loop in SQL
    4. A way to establish a data definition in SQL
    5. Establish a loop in SQL and establish an IF – THEN – ELSE in SQL
    Show answer

    Correct answer: option2 — A way to establish an IF – THEN – ELSE in SQL

Answer key

Option number of the correct answer for each question.

142234435562718394105111122131144153162173184191202214225235242255261272283295304315322332343355365372385391403411424431441455461472484495502

About this paper

Source: a memory-based paper, rebuilt from what candidates remembered after the exam (the 2015 IBPS SO IT Officer paper). The board does not publish its question papers, so the wording and options can differ a little from the original and a few answers may differ from the official key. Treat it as practice material. If you spot a wrong question or answer, tell us on the contact page.

Disclaimer: We do not own this question paper or its questions. They belong to the government body that conducted the examination. The paper is shared here in good faith, free of cost, only to help students prepare better.

Marking in this exam: +1 for a correct answer and −0.25 for a wrong one. Duration 50 minutes.

More IBPS SO question papers

Free Study Planner