This post contains a practice set of 50 questions of SBI I.T. officer the previous year solved 2014 paper in a 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. Access Time of the symbol table will be logarithmic, if it is implemented by

A.Linear List

B.Search Tree

C.Hash Table

D.Self-organizing List

E.Link List

2. Loopback address is

A.127.0.0.1

B.127.(1)(1)0

C.127.(1)0.1

D.127.(1)(1)1

E.127.0.0.0

3. A machine that connects two or more electronic mail systems (including dissimilar mail systems) and transfers messages between them is called

A.Mail gateway

B.Mail exploder

C.Message Transfer Agent

D.Massage Handling System

E.MILNET

4. Batch Processing is preferred over on-line transaction processing when

(1) Processing efficiency is important.

(2) The volume of data to be processed is large

(3) Only periodic processing is needed

(4) A large number of queries are to be processed

A.(1), (2)

B.(1), (3)

C.(2), (3)

D.(1), (2), (3)

E.(1), (2), (3), (4)

5. When CD is read by the CD-ROM it is termed as________

A.Latency Time

B.Delay Time

C.Seek Time

D.Rotational Time

E.Shift Time

6. Stack is sometimes called a_______________

A.Push down list

B.Push down array

C.Pop down list

D.Pop up array

E.None of these

7. Page Stealing

A.Is a sign of an efficient system

B.Is taking page frames from other working sets

C.Should be the turning goal

D.Is taking larger disk spaces for pages out

E.None of these

8. Which of the following is not true regarding multi programming environment?

Provide efficient resource utilization in a non-interactive environment

Multiple user programs are in memory at any time

Uses DMA mode of I/O

Turnaround time of a program is the appropriate measure of user service in this system

The user is substituted by programs i.e. more than one program shares the CPU and the CPU rapidly switches from one program to another

9. Which of the following can be determined only from the meaning of the attributes in the entity type:

A.Domain

B.Cardinality

C.Key

D.Relation

E.Constraint

10. E-R diagram ellipse represents

A.Entity Sets

B.Attributes

C.Relationship Sets

D.Both Entity Sets and Attributes

E.Both Attributes and Relationship Sets

Page 2 of 5

11. In an E-R diagram double lines indicate

A.Total Participation

B.Multiple Participation

C.Cardinality N

D.Both Total Participation and Multiple Participation

E.None of these

12. Fragmentation Means:

The condition of a disk in which files are divided into pieces scattered around the disk.

B.Removing viruses from the computer

C.Cleaning up of computers memory

D.Increasing the size of primary memory

E.All the above

13. DFSA and NDFSA stand for ____________ and ________________ FSA respectively.

A.Deterministic, non-deterministic

B.Declarative, non-declarative

C.Directional, non-directional

D.Distinguishable, non-distinguishable

E.None of these

14. How many bits internet address is assigned to each host on a TCP/IP internet which is used in all communications with the host?

A.16-bits

B.32-bits

C.48-bits

D.64-bits

E.None of these

15. Virtual Memory is

A.Related to virtual reality

B.A form of RAM

C.A form of ROM

D.Both Related to virtual reality and A form of RAM

E.None of These

16. To deliver a message to the correct application program running on a host, the _______ address must be consulted.

A.Physical

B.IP

C.Port

D.DNS

E.Local

17. Which gate is known as universal gate?

A.NOT Gate

B.AND Gate

C.NAND Gate

D.XOR Gate

E.None of these

18. Error detection and control is the function of which layer of the OSI model

A.Physical Layer

B.Data Link Layer

C.Application Layer

D.Network Layer

E.Transport Layer

19. Black Box is related to

A.Encapsulation

B.Polymorphism

C.Inheritance

D.Abstraction

E.None of these

20. What is data Integrity?

A.It is the data contained in database that is non redundant

B.It is the data contained in database that is accurate and consistent

C.It is the data contained in database that is secured

D.It is the data contained in database that is shared

E.It is the data contained in database that is centralized

Page 3 of 5

21. 190.25(5)25(4)254 falls under which class of LAN

A.A

B.B

C.C

D.D

E.E

22. Code uses 7 bits to represent a character:

A.ASCII

B.ANSI

C.EBCDIC

D.BCD

E.EBDIIC

23. Manager's salary details are hidden from employees. This is

A.The conceptual level of data hiding

B.The physical level of data hiding

C.External level of data hiding

D.Both The conceptual level of data hiding and The physical level of data hiding

E.All of these

24. Parameter passing to function is called:

A.Call By Value

B.Call By Reference

C.Call By Name

D.A B and C

E.None of these

25. A relation is in ______________

A.2NF

B.3NF

C.BCNF

D.1NF

E.Both 2NF and 3NF

26. Which of the following command is used for two way communication:

A.Write

B.Talk

C.Mesg

D.Mail

E.Pine

27. Function Point Analysis is an objective and structured technique to measure software size by quantifying its functionality provided to the user, based on the requirements and logical design. Following are the % major components of Function Point Analysis which capture the functionality of the application are except:

A.External Inputs

B.External Outputs

C.External Inquiries

D.External Log Files

E.External Interface Files

28. Compiler is preferred over interpreter because

A.It can generate stand-alone programs that often take less time for execution

B.It is much helpful in the initial stages of program development

C.Debugging can be faster and easier

D.If one changes a statement, only that statement needs recompilation

E.It needs less computer resources

29. According to the levels of abstraction, the schema at the intermediate level is called

A.Logical Schema

B.Physical Schema

C.Sub schema

D.Super Schema

E.Conceptual Schema

30. End-to-end connectivity is provided from host-to-host in:

A.Network Layer

B.Session Layer

C.Data Link Layer

D.Transport layer

E.None of these

Page 4 of 5

31. Table in DBMS means______________

A.The basic structure to hold user data in a relational database

B.The structure uses an object type to define a column

C.The logical view of the data

D.Controlled access to data in the database

E.All the above

32. Cross-compiler is a compiler:

A.Which is written in a language that is different from the source language.

B.That generates object code for its host machine.

C.Which is written in a language that is same as the source language.

D.That runs on one machine but produces object code for another machine.

E.Both A and B

33. Data Integrity Control_______________

A.Unintended changes or errors in some data

B.Confidentiality of the information.

C.Data to be stored in more than one file

D.Changes in the data need to occur in all places

E.All of these

34. The XOR gates are ideal for testing parity because even-parity words produce a _________________ output and odd-parity words produce a ________________ output.

A.Low, High

B.High, Low

C.Odd, Even

D.Even, Odd

E.None of these

35. The Problem of thrashing is affected significantly by:

A.Program Structure

B.Program Size

C.Primary-storage device

D.All the above

E.None of the above

36. From a given tautology, another tautology can be derived by interchanging.

A.0 and 1

B.AND and OR

C.0 and 1; AND and OR

D.Impossible to derive

E.High and Low

37. Packets are related to which layer

A.Data Link Layer

B.Physical Layer

C.Network Layer

D.Presentation Layer

E.None of these

38. The RDBMS organizes the data so that its external view is a set of ____________________

A.Relations

B.Schema

C.Domain

D.Operations

E.Files

39. A ______________________ is considered as a collection of data items organized as a set of formally described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.

A.Relational Database

B.Object-Oriented Database

C.Replicated Distributed Database

D.Fragmented Distributed Database

E.Distributed Database

40. A tuple defines a collection of _____________________ values.

A.Relation

B.Attribute

C.Domain

D.Tuple

E.Schema

Page 5 of 5

41. Example of Railway Track is the eg. of which type of LANNING

A.Simplex

B.Half Duplex

C.Full Duplex

D.Both Simplex and Half Duplex

E.None of these

42. What is the term used to describe the situation when a derived class provides a function already provided in the base class.

A.Overloading

B.Overriding

C.Polymorphism

D.Encapsulation

E.None of these

43. Student and courses are example of ___________________

A.One to One

B.Many to Many

C.One to Many

D.Many to One

E.None of these

44. A table has ___________________ number of columns, but ____________ number of rows.

A.Specified, Any

B.Any, Specified

C.Any, Any

D.Specified, Specified

E.None of these

45. A bottom-up parser generates

A.Right-most derivation

B.Right-most derivation in reverse

C.Left-most derivation

D.Left-most derivation in reverse

E.Both Right-most derivation and Left-most derivation possible

46. Which of the following operations of DBMS is unary ?

A.Project

B.Join

C.Union

D.Intersection

E.Difference

47. Graph Showing basic block and their successor relationship is called:

A.Control Graph

B.Flow Graph

C.Dependency Graph

D.Hamiltonian Graph

E.DAG

48. Utility used to transfer files and exchange messages

A.Email

B.WWW

C.Web Browser

D.Firmware

E.Internet

49. When you drop a ______________ corresponding indexes are also dropped.

A.Column

B.Sequence

C.View

D.Table

E.None of these

50. Column of a table in database table is called

A.Relation

B.Attribute

C.Domain

D.Tuple

E.Schema

General Instructions:

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

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

Related