BNP Paribas Interview Question

something like, what are the Oracle background process and their functions? What's the difference between ref cursor and cursor etc?