Joy Smith San (9/12/2012)
Experts,One of the interviewer asked me something like below question. It was not clear to me anyway.
"When we get an SQL query how do we determine if it meets ACID properties or not ?". Since it was telephonic I din't hear it properly as well.
Can anyone tell me What should be the answer ?.
Thanks in advance.
San.
There is no "right" answer. The interviewer was trying to determine more than that question. They wanted you to explain your understanding of ACID and how it relates to a query. Do you know what ACID is? If you don't then start there.
If I were asked this question I would have responded with a question for clarification because the question as you posted it is entirely too vague to provide a decent answer. What type of query is it? What is the context it is being used?
Honestly I don't really quite understand how a query can be held up against the ACID test.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/