Cognizant interview question

Basic plsql questions, delete truncate difference, collections, analytical functions.