IBM Sample Technical Interview Questions

1.Can you tell advantages of RDBMS over simple custom DBMS ?
Answer:
Any data storage in any manageable structure can be called a DBMS. But, it is the responsibility of the programmer to maintain the data integrity and to take care of constraints. But on RDBMS, the system takes care of almost all of the data integrity requirements. Hence, the programmer could focus more on business logic rather than worrying about data integrity much.

2.Which is the layer of an Operating System that takes care of the system resource usage at the lowest level ?
Answer:
Answer is Kernel Layer.

3.Can you tell any two advantages of stored procedures ?
Answer:
Stored procedures can replace complex program segments requiring extensive SQL statements being executed from the code, hence they can make the application more manageable. Another advantage is that the usage of stored procedures can significantly reduce the network and bandwidth usage. This is because of the reduction in the number of requests and responses between business layer and database layer.

Popular posts from this blog

AGRICULTURAL SCIENTIST RECRUITMENT BOARD

HSC Exam Time Table 2013 Arts, Commerce, Science

CIVIL SERVICES' (I.A.S.) EXAMINATION