1. Write and execute the following commands in UNIX:

To count the number of files in the current directory.

To kill a process with its PID.

To split a file with each file containing 5 lines.

To translate characters from upper case to lower case of any text file.

To send a file to a print queue of a line printer.

2. Write a shell program to combine any 2 files into a single file and display the resultant file's word-count.

3. Create a table with the following fields:
SYS_COMPLAINTS (Complt_No, Complt_Desc, Hardware Software, Complt_Date, Dept, Room_No, Engineer_ID_Alloted) Select appropriate data types for all the fields. Complt_N0 should be auto-generated and sequential. Enter 10 meaningful records.

4. For the above table in Q. answer the following queries using SQL

To display all the complaints received on today's date.

To display only the hardware related complaints and their description.

To display all the details of the complaints alloted to Engineer_ID_Alloted ="001".

To display all the complaints from the Dept "CSE".

To display all the Complt_No and Complt_Desc for all the software related complaints lodged yesterday.