Question 1:
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.
Question 2:
(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.
PART-II: MCS-043
Question 1:
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.