SQL вопросы и ответы для интервью
Вопрос 11. Why is it better to use an integrity constraint to validate data in a table than to use a stored procedure?
Because an integrity constraint is automatically checked while data is inserted into a table. A stored has to be specifically invoked.
Вопрос 12. What are the three components of a client server model ?
A Client,
A Server and
A Network/Communication software.
Вопрос 13. What are the advantages of client/server model?
Flexibility of the system, scalability, cost saving, centralised control and implementation of business rules, increase of developers productivity, portability, improved network and resource utilization.
Вопрос 14. What are the disadvantages of the client/server model ?
Heterogeneity of the system results in reduced reliability. May not be suitable for all applications. Managing and tuning networks becomes difficult.
Вопрос 15. What are the different topologies available for network ?
Star,
Bus,
Ring.
Самое полезное по оценкам пользователей: