Dell Technologies Interview Question

Questions: 1. Use of instring and substring in questions 2. Some common sql questions 3 Informatica Partitioning 4. They asked puzzle which I could not answer. It was unexpected.