Capgemini interview question

I applied for PLSQL developer and the interviewer ask basic procedure vs function difference, find duplicate records, project information. Difference between delete and truncate. However, the client asked questions about ACID and RDBMS. Further they asked about, PGA, SGA.