Capgemini Interview Question

different kinds of joins, indexes, postgresql config parameters, session level performance tuning parameters, Postgresql backup and restore