Lazy writer in Memory ?
Answer : Lazy write is an effect caused by the use of a write-back cache…
Browsing Tag
Allstate Solut interview questions and answers
8 posts
What is the difference between the SubQuery and Corelated SubQuery ?
Answer : The inner query is executed only once…
What is the Difference between join and union ?
Answer : The union operator combines the results of two or more queries into a single result set…
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE ?
Answer : The HAVING clause sets conditions on the GROUP BY…
Difference between Clustered and Non-clustered index ?
Answer : Cluster index: Clustered index will be created…
What is an Index ?
Answer : Index is a database object which improves the efficiency of the query…
