PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 18

Q.1) The relational database environment has all of the following components except

(a) users

(b) separate files

(c) database

(d) database administrator

(e) None of these

Q.2) Which of the following feature is true regarding concatenated virtual circuits?

(a) A sequence of virtual circuits is set up for source through one or more gateways to the destination

(b) each gateway maintains table telling which virtual circuit pass through it

(c) the scheme works best when all the networks have roughly the same properties

(d) all of the above

(e) None of these

Q.3) RSPV (resource reservation protocol) used in

(a) congestion control

(b) it allows multiple senders to transmit to multiple groups of receivers

(c) it permit individuals receiver to switch channels freely and optimizes band width use while at the same time elimination congestion

(d) all of the above

(e) None of these

Q.4) primary key

(a) denote a candidate key that is chosen by the database designer as the principal means of identifying entities with in an entity set

(b) attributes names of all primary key are unique

(c) primary key specification is optional and good idea to specify primary key for each relation

(d) all of the above

(e) None of these

Q.5) A compiler which runs on one machine and generates code for another machine –

(a) bootstrap

(b) cross-compiler

(c) lexical analyser

(d) all of the above

(e) None of these

Q.6) IPV 6

(a) it is used in real time stream protocol

(b) they are 16 bytes long with 32 bits header

(c) it is used in security

(d) all of the above

(e) None of these

Q.7) In the blocked state:

(a) the processes waiting for I/O are found

(b) the process which is running is found

(c) the processes waiting for the processor are found

(d) all of the above

(e) None of these

Q.8) V.34

(a) it has 128 constellation point

(b) it runs on 28.800 bps

(c) both (a) and (b)

(d) it runs on 500 bps

(e) None of these

Q.9) ACID properties of transaction is

(a) atomicity

(b) consistency

(c) isolation

(d) all of the above

(e) None of these

Q.10) Identify the correct statements about DFS traversal of graph.

  1. it can be used to determine whether a graph is cycle or not
  2. it identifies the connected components of an undirected graph

III. Traverses a single path of the graph until it visits a node with no successor

(a) I and II

(b) II and III

(c) I and III

(d) I, II and III

(e) None of these

Q.11) Bankers algorithm for resource allocation deals with

(a) dead lock prevention

(b) dead lock avoidance

(c) dead lock recovery

(d) mutual exclusion

(e) None of these

Q.12) Error detection at data link layer is achieved by

(a) bit stuffing

(b) humming codes

(c) cyclic redundancy codes

(d) equalization

(e) None of these

Q.13) A method, which transfers the entire block of data from its own buffer to main memory takes place without intervention by CPU.

(a) programmed input/output

(b) interrupt driven input/output

(c) direct memory access

(d) resident monitor

(e) None of these

Q.14) Which of the following translation program converts assembly language programs to object program.

(a) compiler

(b) linker

(c) assembler

(d) microprocessor

(e) None of these

Q.15) An IP address is a _____ bit number

(a) 32

(b) 16

(c) 8

(d) 4

(e) None of these

Q.16) Which of the following is not a routing algorithm?

(a) broadcast

(b) link state

(c) traffic shaping

(d) distance vector

(e) None of these

Q.17) Which of the following is a type of fragmentation?

(a) transparent

(b) non-transparent

(c) both (a) and (b)

(d) mutual exclusion

(e) None of these

Q.18) When the maximum clock rate is quoted for a logic family. It applies to a

(a) shift register

(b) flip-flop

(c) counter

(d) single logic gate

(e) None of these

Q.19) The attributes of relationship teacher in teacher reaches course should be

(a) teacher code, teacher name, dept, phone no

(b) course no, course name, semester offered, credits

(c) teacher code, course no, semester no

(d) teacher code, course no, teacher name, dept, phone

(e) None of these

Q.20) “It takes as independently translated programs as input whose original source langue representation include symbolic reference to each other. Its task is to resolve these symbolic references and produce and single program”. Here ‘it’ refers to –

(a) loader

(b) linkage editor

(c) microprocessor

(d) sub editor

(e) None of these


Answer Key:

1        (b)     separate files

2        (d)     all of the above

3        (d)     all of the above

4        (d)     all of the above

5        (b)     cross-compiler

6        (d)     all of the above

7        (a)     the processes waiting for I/O are found

8        (c)     both (a)

9        (d)     all of the above

10      (d)     I, II and III

11      (b)     dead lock avoidance

12      (c)     cyclic redundancy codes

13      (c)     direct memory access

14      (c)     assembler

15      (a)     32

16      (c)     traffic shaping

17      (c)     both (a)

18      (a)     shift register

19      (c)     teacher code, course no, semester no

20      (b)     linkage editor


You can join in our Telegram Channel the invite given below and you can share this with your friends and other aspirants who are preparing for their exams like you.

Caution: You should have Telegram app installed in your mobile or laptop to join the group. If you don’t have telegram app in your mobile. First install the app and click the link given below….

Bankersdaily Telegram Supergroup – Click to join in the Group


Click for previous professional Knowledge Quiz:

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 17

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 16

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 15

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 14

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 13

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 12

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 11

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 10

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 9

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 8

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 7

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 6

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 5

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 4

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 3

PROFESSIONAL KNOWLEDGE QUIZ FOR IBPS SO(I.T OFFICER)-2017-SET 2

Professional Knowledge Quiz For IBPS SO(I.T Officer)-2017-Set 1