A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user? Select one: a. select e.empid, d.head from emp e, dept d; b. Select e.empid, d.head from emp e, dept d where e.dept# = d.dept#; c. Select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#; d. Select e.empid, d.head from emp e right outer join on dept d where e.dept# = d.dept#; cascade update option (in the context of referential integrity) Select one: a. means do not change the value in the primary key field if that record has related records in another table b. means change all the related records in child tables if the record in parent table is changed c. Both of above d. None of above Consider the table (Relation) STUDREC SREF (Key Field) INITIAL SURNAME DATEOFBIRTH GENDER RESIDENCE KIDS HOMETOWN DISTANCE The key is SREF (student reference number). This table is in Select one: a. first normal form b. second normal form c. third normal form d. None of the above What SQL structure is used to limit column values of a table? Select one: a. The LIMIT constraint b. The CHECK constraint c. The VALUE constraint d. None of the above is correct. Which SQL statement is used to remove data from a database? Select one: a. DELETE b. REMOVE c. TRUNCATE d. DEL