Write the UNIX commands for the following:
(a) To kill a particular process with a PID.
(b) To append the contents of file2 after the contents of the file1 and redirect them to a new file3.
(c) To print the first difference between any two given files.
(d) To change the command prompt from $ to *.
(e) To grant the permissions of read, write and execute to the user and read only to the group and others for all the files in a current directory.
(f) To direct a standard output to any of the line printer.
(g) To list all the files in the current directory whose file names starts with a.
(h) To execute some command even after logout.
(i) To split a file splittest, which is containing 20 lines into 5 lines each which are directed to four various files.
(j) To display the last 20 lines in a given file.
(a) Write a shell program to count no. of characters, no. of blank spaces, no. of words and no. of lines in a given file by the user.
(b) Write a shell script to find the day when a date is given.
(c) Write a shell script to display the largest element in a given 4X4 matrix.
Consider the following employee database schema:
EMPLOYEE (ESSN, ENAME, DEPT_NO, SALARY)
DEPENDENT (ESSN, DEPEND_NAME, RELATION, DOB)
DEPARTMENT (DEPT_NO, DEPT_NAME, MANAGER)
(a) Create the appropriate database using Oracle.
(b) Perform following queries using SQL:
(i) Find details of dependents for employee having name AJAY.
(ii) Find the name of the manager of the department in which employee with ESSN Code 5078 works.
(iii) Find the name of all employees whose age is less than 18 years.
(iv) Find the DOB of the son of the employee having employee code ESSN 5078.
(v) Find the details of the departments in which the employee having employee code ESSN 5078 has worked.
(c) Create the procedures for the above queries.
(d) Write appropriate triggers, exceptions and functions for the above employee database schema.