Broadridge Interview Question

what is constructors? what is multithreading ? two coding questions SQL query- syntax for update and alter