FINRA interview question

Asked me SQL based questions. What does DROP do? What is cascade?