SQL Interviewfragen und Antworten
Frage 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.
Frage 12. What are the three components of a client server model ?
A Client,
A Server and
A Network/Communication software.
Frage 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.
Frage 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.
Frage 15. What are the different topologies available for network ?
Star,
Bus,
Ring.
Am hilfreichsten laut Nutzern: