Prepare Interview

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

SQL Interview Questions and Answers

Test your skills through the online practice test: SQL Quiz Online Practice Test

Ques 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.

Is it helpful? Add Comment View Comments
 

Ques 12. What are the three components of a client server model ?

A Client,
A Server and
A Network/Communication software.

Is it helpful? Add Comment View Comments
 

Ques 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.

Is it helpful? Add Comment View Comments
 

Ques 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.

Is it helpful? Add Comment View Comments
 

Ques 15. What are the different topologies available for network ?

Star,
Bus,
Ring.

Is it helpful? Add Comment View Comments
 

Most helpful rated by users:

©2024 WithoutBook