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;

Consider the following data files:  digits-en.txtThis file c…

Consider the following data files:  digits-en.txtThis file contains digits (0 to 9) and their lower-case spelling in English.Example of contents:  nine 9two 2one 1four 4 digits-fr.txtThis file contains similar information, but the digit comes first and the words are in French (without accentuated letters, to make things easier).Example of contents:  8 huit3 trois4 quatre1 un digits.txtThis file contains only numbers.Example of contents:  354298 Please note the following:  Our files may not all feature the same numbers. We will therefore have the spelling for some numbers in only one language, in both, or in none. None of the files are to be assumed to be already sorted by numbers. A single space is used as separator in all files. We want you to use join in order to display the following sorted lists of numbers (only numbers, not any words): All numbers that are found in digits.txt, that also have an English spelling in digits-en.txt. All numbers, that are found in digits-en.txt and digits-fr.txt, that have only a French spelling, but no English spelling. All numbers, that are found in digits-en.txt and digits-fr.txt, that have a spelling in only one of the two languages. Provide the Linux command lines to achieve these three separate objectives.