MCA (Revised)
Term-End Practical Examination
June, 2011
MCSL-045 : UNIX AND DBMS LAB
Time allowed : 2 hours Maximum Marks : 50
Note : There are two parts : UNIX and DBMS in this
paper. Each part is of 1 hour
duration and carry 20
marks. 5 marks is for Viva - voce of each part
separately. Attempt
only that part(s), which is/are not yet clear.
PART-I
UNIX
1. Write and execute UNIX commands for the following: 5
(a) To display the
last 10 lines in a text file.
(b) To remove a
directory.
(c) To connect to a
remote machine.
(d) To change the
permission of a file.
(e) To quit from a
file with no changes.
2. Write a shell script to write the initial of any name
given as input. 5
Input VINAY KUMAR
Output V K
3. Write a shell script program to find out biggest number
from the three given
numbers as input as
through command line argument. Display appropriate message if exactly three
arguments are not provided through command line. 10
PART-II
DBMS
Note: Answer the following questions:
1. Create a relational database with the following relations
and insert 10 meaningful
records/data in each table of the relation: 5
- TEACHER (T_ID,
Name, Designation, Subject)
- STUDENT (T_ID,
Roll_No, Subject, S_Name, Semester)
- RESULT (Roll_No,
S_Name, Subject, E_Marks)
2. Perform the following tasks using schema/Table/Relations
given in Q.1
(a) Using the schema /Tables of Q.1, write a trigger that
fires before any row is
inserted in the table RESULT. 5
(b) Using the schema/ tables of Q.1, write a procedure to
display the marks of those
students who have studied "Computer Graphics"
subject by a Teacher whose
designation is "Professor". 10
