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.
Ques 2. What does the term downsizing refer to ?
A host based application is re-engineered to run in smaller or LAN based environment.
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.
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.
Ques 5. What are the types of processes that a server runs ?
Foreground process and Background process.
Most helpful rated by users: