Aloha Technology interview question

joins in sql,cursor,triggers,Stored procedure, functions etc