of Printed Pages: 2 IMCSL-045 -Set -41
MASTER OF COMPUTER APPLICATIONS (Revised)
00598

Term-End Examination
June, 2016
MCSL-045 -Set UNIX AND DBMS LAB

Time: 2 hours Maximum Marks: 50
Note: T7lere are 2 sections in this paper.
All tIle questions are compulsory.
Each section is of one hour duration and carries 20 marks.
5 marks are for viva-voce of each section separately.
Attempt only that section(s) in which you are not successful as yet.

SECTION

UNIX

1. Write and execute the following UNIX commands

To display the present working directory.

To combine multiple files/dir's into a single archive.

To compress a given file.

To print first 10 lines of any text file.

To examine file(s) and displays whether text, data etc.

2. Write a shell program which deletes all the odd numbered lines of a text file and transfers them to a new file with name "odd.txt" in the same directory.

SECTION

DBMS

3. Create the tables:

Supplier SName, Status, City)
Parts PName, Colour, Weight, City)
SP quantity)
Select appropriate data type for each of the fields. Input meaningful data for at least 10 records. Identify the "keys".

4. For the above table given in Q3, answer the following queries using SQL 5x2=10

Find the names of all the suppliers for the city "MUMBAI".

To find the no. of suppliers who supply "GREEN" part.

To sort the supplier table by S#.

To display weight of the

To display all the details of the supplier whose