The following PL/SQL block will correctly return the last na…

The following PL/SQL block will correctly return the last name of the employee whose employee id is 100. True or False? DECLARE     v_last_name employees.last_name%TYPE;     employee_id employees.employee_id%TYPE := 100; BEGIN     SELECT last_name INTO v_last_name     FROM employees     WHERE employee_id = employee_id; END;

What is the parameter mode for p_name in the query_demo proc…

What is the parameter mode for p_name in the query_demo procedure in the following PL/SQL block? DECLARE  p_name  persons.name%TYPE;    p_sal   persons.salary%TYPE;BEGIN  query_demo(178, p_name, p_sal);  DBMS_OUTPUT.PUT_LINE(‘Name: ‘ || p_name);  DBMS_OUTPUT.PUT_LINE(‘Salary: ‘ || p_sal);END;