Sopra Steria interview question

1. Producer and consumer problem using multithreading and without multithreading. 2. What is pipelining in MS-SQL.