1. Write and execute the following UNIX commands:

To change to a new directory from the current directory.

To summarize the free space on disk device.

To remove the files with file name starting with b or B in the current directory.

To compare two files and show the differences.

To show the date and time.

2. Write a shell program, using "grep" to find the number of occurrences of a string "and" in a text file and display its count.

3. Create a table "SEMINAR" with the following fields:
SEM_TITLE, DEPT_ORGANISED, YEAR, CO_ORDINATOR, CO_COORDINATOR, NO_OF_DAYS, VENUE, START_DATE, END_DATE, NO_OF_PARTICIPANTS, NO_OF_RESOURCE_PERSONS, SPONSORED/NON_SPONSORED)
Select appropriate data types for all the fields. Identify the primary key. Input 10 meaningful records.

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

To display all the seminars co-ordinated by "RAHUL" and co-coordinated by "ACHUTH".

To display the details of all the seminars conducted in the year 2015.

To display all the records whose venue is "AUDITORIUM_1" and are all sponsored seminars.

To display all the seminars in which the No_of_participants is more than 100.

To display all the seminar_nos whose title starts with "D".