IBPS IT Officer MCQ – 46

IT Officer

1 .A trigger is?
a) A statement that enables to start any DBMS
b) A statement that is executed by the user when debugging an application program
c) A condition the system tests for the validity of the database user
d) A statement that is executed automatically by the system as a side effect of modification to the database

Click here to View Answer
Answer d) A statement that is executed automatically by the system as a side effect of modification to the database

2 .Manager’s salary details are hidden from the employee. This is?
a) Conceptual level data hiding
b) Physical level data hiding
c) Externel level hiding
d) None of above

Click here to View Answer
Answer c) Externel level hiding

3. Regular expressions are closed under?
a) Union
b) Intersection
c) Kleen star
d) All of the mentioned
e) none of these

Click here to View Answer
Answer d) All of the mentioned

4 .Mode of data transfer in FTP, where all the is left to TCP?
a) Stream mode
b) Block mode
c) Compressed mode
d) decompressed mode
e) None of the mentioned

Click here to View Answer
Answer a) Stream mode

5 .The right to use a domain name is delegated by domain name registers which are accredited by?
a) internet architecture board
b) internet society
c) internet research task force
d) internet corporation for assigned names and numbers
e) none of these

Click here to View Answer
Answer d) internet corporation for assigned names and numbers

6. Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?
a) Data Definition Language
b) Data Manipulation Language
c) Data Described Language
d) Data Retrieval Language
e)Data Control Language

Click here to View Answer
Answer a) Data Definition Language

7. Application layer protocol defines?
a) types of messages exchanged
b) message format, syntax and semantics
c) rules for when and how processes send and respond to messages
d) all of the mentioned
e) none of these

Click here to View Answer
Answer d) all of the mentioned

8. Application layer offers _______ service?
a) End to end
b) Process to process
c) Both of the mentioned
d) None of the mentioned
e) node to node

Click here to View Answer
Answer a) End to end

9. Two devices are in network if?
a) a process in one device is able to exchange information with a process in another device
b) a process is running on both devices
c) PIDs of the processes running of different devices are same
d) none of the mentioned
e) all of these

Click here to View Answer
Answer a) a process in one device is able to exchange information with a process in another device

10. Which of the following data structure is linear type?
a) Graph
b) Trees
c) Binary tree
d) Stack
e) ALL OF THESE

Click here to View Answer
Answer d) Stack