Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the following queries will display the last name of all employees whos managed by KING?

Select one:

a. SELECT m.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id

b. SELECT e.last_name FROM employees e, employees m WHERE upper(last_name) = KING

c. SELECT e.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id and upper(m.last_name) = 'KING

d. none of the above

Which of the following is not an option of ALTER TABLE statement?

Select one:

a. modifying an existing tuple

b. adding a new column

c. deleting an existing constraint

When you issue the DELETE FROM tablename command without specifying a where condition _____.

Select one:

a. All rows will be deleted.

b. No rows will be deleted.

c. The last row will be deleted.

d. The first row will be deleted.

Clear my choice

d. resizing the length of an existing column