Infosys Interview Question

For example about SQL question included - What is a subquery(and give an example) and an inline query - What are some aggregate functions - Have you used any automation tools - difference b/w delete, truncate, and drop