IBPS IT Officer MCQ – 45

IT Officer

1. Which of the following SQL command can be used to modify existing data in a database table?
a) MODIFY
b) UPDATE
c) CHANGE
d) NEW
e) ALTER

Click here to View Answer
Answer b) UPDATE

2. The basic limitation of finite automata is that?
a) It can’t remember arbitrary large amount of information
b) It sometimes recognize grammar that are not regular
c) It sometimes fails to recognize regular grammar
d) All of the mentioned
e) there is no limitation

Click here to View Answer
Answer a) It can’t remember arbitrary large amount of information

3. When SQL statements are embedded inside 3GL, we call such a program as?
a) Nested query
b) Nested programming
c) Distinct query
d) Embedded SQL
e) inline query

Click here to View Answer
Answer d) Embedded SQL

4. An interconnected collection of piconet is called?
a) scatternet
b) micronet
c) mininet
d) macronet
e) none of the mentioned

Click here to View Answer
Answer a) scatternet

5. Which one of the following protocol delivers/stores mail to reciever server?
a) simple mail transfer protocol
b) post office protocol
c) internet mail access protocol
d) hypertext transfer protocol
e) file transfer protocol

Click here to View Answer
Answer a) simple mail transfer protocol

6. E-mail is?
a) Loss-tolerant application
b) Bandwidth-sensitive application
c) Elastic application
d) all of the mentioned
e) none of these

Click here to View Answer
Answer c) Elastic application

7. What is interframe gap?
a) idle time between frames
b) idle time between frame bits
c) idle time between packets
d) idle time between two adjacent frames
e) none of the mentioned

Click here to View Answer
Answer a) idle time between frames

8. A terminated transaction that has completed its execution successfully is ____________, otherwise it is __________?
a) committed, destroyed
b) aborted, destroyed
c) committed, aborted
d) only commited
e) only aborted

Click here to View Answer
Answer c) committed, aborted

9. ATM and frame relay are?
a) virtual circuit networks
b) datagram networks
c) both (a) and (b)
d) virtual network
e) none of the mentioned

Click here to View Answer
Answer b) datagram networks

10.Which of the following data structure is non linear type?
A) Strings
B) Lists
C) Stacks
D) Graph
E) ARRAY

Click here to View Answer
Answer D) Graph