New Update

IGNOU BCA, MCA New, PGDCA New, M.com New, PGDIBO solved assignments July-January 2023-24 & January -July 2024 now available. Note: If do not get solved assignments after payment then mail us. Thanks You...

Tuesday 25 August 2020

IGNOU MCA MCSL-045 term-end exam notes,important questions,upcoming guess papers free download

IGNOU MCA MCSL-045 4th semester term-end practical examination (UNIX AND DBMS LAB) books/block,term-end exam notes,upcoming guess paper,important questions,study materials,previous year papers download.
IGNOU MCA MCSL-045 term-end exam notes,important questions,upcoming guess papers free download



IGNOU BCA/MCA all semester new revised (1st semester,2nd semester,3rd semester,4th semester,5th semester and 6th semester) solved assignments,term-end exam notes,study materials,important questions,books/blocks (June-December) free download.

                                                             Set-1



                                                        SECTION A
                                                            UNIX
1. List and execute the following UNIX commands :
(a) To rename a sub-directory.
(b) To remove all the files with filenames starting with "k" or "K" in the current working directory.
(c) To create a file using any editor of your choice.
(d) To display the Mode no. of any file.
(e) To copy all the files in PWD to a new folder.

2. Write a shell program to append contents of filet to file l.

                                                         SECTION B
                                                             DBMS
3. Create a table "TRAINING" with the following fields :
(TRAINING_ID, TRAINING_NAME, COORDINATOR,NO_OF_PARTICIPANTS, VENUE, NO_OF_DAYS, YEAR,NO_OF_RESOURCE_PERSONS, START_DATE, END_DATE)
Select the appropriate data types for each of the fields. Identify the primary key.Input meaningful data of at least 10 records.

4. For the above table in Q 3, answer the following queries using SQL :
(a) To display all the training programme details conducted in 2014.
(b) To display the Start_Date and End_Date of Training_ID = "1234".
(c) To display the Coordinator of "1234".
(d) To display the No_Of Resource_Persons hired for any particular training programme of your choice.
(e) To display the name of the training programme with Training_ID = "1234".

                                                         Set-2



                                                   SECTION A
                                                        UNIX
1. List and execute the following UNIX commands :
(a) To display the status of all the processes.
(b) To kill a process with its Process_ID.
(c) To compare 2 files and show the differences.
(d) To remove all the files in a sub-directory of your choice.
(e) To display the long listing of files and folders.

2. Write a shell program to search for the filenames starting with "c" or "C" in the current working directory and copy them in a newly created folder called as "new".

                                                 SECTION B
                                                     DBMS
3. Create a table "ROUTE" with the following fields :
(ROUTE_ID, ROUTE_NO, CATEGORY_CODE, ORIGIN, DESTINATION,FARE, DISTANCE, SEATING _CAPACITY, TRIPS) Select the appropriate data types for the fields. Select a primary key. Input meaningful data for at least 10 records.

4. For the above table given in Q 3, write the following queries using SQL :
(a) To display all the records, sorted in descending order w.r.t the distance.
(b) To display all the Route_ID's.
(c) To display the fare for the Route_No = 3 for Deluxe category service bus.
(d) Display the Seating_Capactiy for the Route_ID = "234".
(e) Display all types of categories the Road transport system has.

                                                        Set-3


                                                  SECTION A
                                                       UNIX
1. List and execute the following UNIX commands :
(a) To change the login password.
(b) To display the date and time.
(c) To display the history of previously executed commands.
(d) To display the calendar for the current month.
(e) To display all the files starting with "c" as the filename.

2. Write a shell program to count and display the occurrence of a particular pattern given as input appeared in a text file.

                                                          SECTION B
                                                              DBMS
3. Create the following table "STUDY_CENTRES" with the following fields :
(SC_NAME, SC_CODE, REGIONAL_CENTRE, SC_YEAR_ESTABLISHED,ADDR1, ADDR2, ADDR3, PROGRAMME_ COORDINATOR,NO_OF_PROGRAMMES_ACTIVATED, NO_OF_STUDENTS,NO_OF_AC_COUNSELLORS)
Select the appropriate data types for the fields. Identify the primary key. Input 10 meaningful records.

4. Write the following queries using SQL for the DB given in Q 3 :
(a) Display all the details of all the Study Centres under Chennai Regional Centre.
(b) Display the No_of students and No_of programmes_activated in Study Centre Code = "1104".
(c) Display the Programme Coordinator of Study Centre Code = "1104".
(d) Display the address of Study Centre Code = "2304".
(e) Display the count of number of Study Centres in total.

                                                          Set-4

                                                 
                                                    SECTION A
                                                        UNIX
1. Write and execute the following commands in UNIX :
(a) Create a sub-directory with 3 files — file l, file 2 and file 3 in the current working directory.
(b) Make a copy of any text file using a command in UNIX.
(c) To display all the files whose filename starts with "a".
(d) Write a grep command to select the lines from a file that has exactly 3 characters.
(e) Compare the two text files and display the first difference.

2. Write a shell program to display the last modification time of any file, if the filename of the file is given as input.

                                                            SECTION B
                                                                DBMS
3. Create a table with name "CATALOGUE" with the following fields :
(BOOK_ID, TITLE, AUTHOR_ID, AUTHORS, PUBLISHER_ID, PUBLISHER,CATEGORY_ID, YEAR, PRICE, VOLUME) Select the appropriate data type for each of the fields. Identify the primary key.Input meaningful data for at least 10 records.

4. Write the following queries using SQL for the table given in Q 3 :
(a) List all the Book_ID's published in the year 2015.
(b) List all the Publisher's names.
(c) List the Author(s) and their ID's for a given Book_ID.
(d) Display the Price for any given book Title.
(e) List all the Publisher_ID's.

IGNOU MCA MCSL-045 4th semester term-end practical examination (UNIX AND DBMS LAB) term-end exam notes Download       

 Also available:-

BCA all semester new solved assignments Download  

BCA all semester new revised books/blocks,study materials 
Download

MCA all semester new solved assignments Download  

MCA all semester new revised books/blocks,study materials Download 

BCA all semester term-end exam notes,important questions,guess papers (june-december) Download  

MCA all semester term-end exam notes,important questions,guess papers (june-december) Download 

BCA/MCA asp.net project Download