SQL Interview Questions and Answers
Ques 1. What does one do when one is rightsizing ?
With rightsizing, one would move applications to the most appropriate server platforms.
Is it helpful?
Add Comment
View Comments
Ques 2. What does the term downsizing refer to ?
A host based application is re-engineered to run in smaller or LAN based environment.
Is it helpful?
Add Comment
View Comments
Ques 3. What is event trigger ?
An event trigger, a segment of code which is associated with each event and is fired when the event occurs.
Is it helpful?
Add Comment
View Comments
Ques 4. Why do stored procedures reduce network traffic ?
When a stored procedure is called, only the procedure call is sent to the server and not the statements that the procedure contains.
Is it helpful?
Add Comment
View Comments
Ques 5. What are the types of processes that a server runs ?
Foreground process and Background process.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users: