Assignment July - 2016 & January - 2017 MCSL-045

MCSL-045

PART-I: MCS-041

1.     Write the UNIX commands for the following :

        (a)   Use the more command, and a pipe to send the contents of your .profile and .shrc files to the screen.

        (b)   Use head and tail in a pipeline to display lines 10 through 15 of a file?

        (c)   To search the /etc/passwd file for the string given by the user and display whether it is found.

        (d)   To display the lines in /etc/passwd that begins with the character “a”.

        (e)   List all the files in the /tmp directory owned by the user root.

        (f)    To see a complete listing of all the processes currently scheduled.

        (g)   Use the ps command, and the grep command, in a pipeline to find all the processes owned by you.

        (h)   To force termination of a job whose process ID is given.

        (i) Sort the /etc/passwd file, place the results in a file called paswd, and trap any errors in a file called err with the command.

        (j) To sort a text file containing the names of 10 students in alphabetical order and place the results in a file called sortedfile.          (5 Marks)

2.     (a)   Write a shell program to count the number of special symbols, end of line characters and blank-spaces present in a text file. Redirect the output to a file called as output. (5 Marks)

        (b)   Write a shell script to take username as an argument and check whether s/he has logged in or not for every 30 seconds for 5 minutes.

        (c)   Write a shell script to display the number of files and their details in the current directory, whose filenames are starting with the character “b”. (5 Marks)

PART-II: MCS-043

1.     (a)   Create an appropriate database using Oracle for a “MCA Evaluation System” for all the 6 semesters. It should cater to the student-wise marks entry for all the assignments and term end exam of all the courses, marks processing, calculation of total marks, generation of grade card etc.. Perform Normalization, to the required levels.            (10 Marks)  

Note: Assumptions can be made wherever necessary. Follow the evaluation scheme given in your MCA Programme Guide.                                                 

        (b)   Perform following queries using SQL:

                (i)    To find the total no. of marks for all the assignments submitted by a student in 5 semesters, if the enrolment no. is given.

                (ii)   To find the total no. of marks for all the Term End Exams of a student in 5 semesters, if the enrolment no. is given.

                (iii)  To display the list of student who have passed in all the first semester assignments.

                (iv)  To display the list of all the students who scored more than 70% in MCS-011.

                (v)   To display the list of all the students who were failed in MCS-011 course.     (5 Marks)

        (c)   Write appropriate triggers, exceptions and functions for the above said system database schema and describe them briefly.

*****************************************************************

Note: Answer with Dotcom Books

www.dotcombooks4u.com

(Last 5 year solved question paper with Assignment solutions)

9825183881

 ****************************************************************