Mulitple Choice: 4 questions @ 2.5 points per question Enter the answer on the line provided. These questions do NOT refer to specific table definitions in either the text or the notebook. Assume all tables names and column names are valid. a. You query the database with this command: SELECT name FROM employee WHERE name LIKE '_a\%'; Which names are displayed? A. names starting with "a" B. names starting with "a" or "A" C. names containing " a " as the second letter D. names containing "a" as any letter except the first ANSWER: b. What happens when you update a table without a WHERE clause? A The statement will not execute B. Only the rows specified will be updated C. All of the rows in the table will be updated D. The statement will execute, but no changes will be made ANSWER: c. In which situation would it be most appropriate to use a self join query? (Self join is joining a table to itself (think recursive relationship). A. The EMPLOYEE and REGION tables have corresponding columns B. The EMPLOYEE and REGION tables have no corresponding columns C. The EMPLOYEE table has two columns that correspond to each other D. The EMPLOYEE table column corresponding to the REGION table column contains null values for rows that need to be displayed. ANSWER: d. Which TWO relationships exist for PATIENT and DOCTOR if a patient can have many doctors, a doctor can have many patients, and a doctor can be a patient? (CHOOSE TWO) A. recursive B. one-to-one C. one-to-many D. many-to-one E. many-to-many ANSWERS