Exam Details
| Subject | UNIX and DBMS Lab | |
| Paper | ||
| Exam / Course | Bachelor of Computer Applications / Masters in Computer Applications (PRACTICALS) | |
| Department | School of Computer and Information Sciences (SOCIS) | |
| Organization | indira gandhi national open university | |
| Position | ||
| Exam Date | June, 2016 | |
| City, State | new delhi, |
Question Paper
No. of Printed Pages: 2
IMCSL-045 -Set -21
MASTER OF COMPUTER APPLICATIONS (Revised)
Term-End Examination
02106
June, 2016
MCSL-045 -Set UNIX AND DBMS LAB
Time hours Maximum Marks: 50
Note: There are 2 sections in this paper.
All the 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 commands in UNIX: 5x1=5
To print the last 10 lines of any file.
To print the most recent status of the system like who are the current logged -in users.
To print the information about the active processes.
To create or change a password.
To delete files from a directory.
2. Write a shell program, using "grep" to locate a given string and count its no. of 15 occurrences in a file.
SECTION
DBMS
3. Create a table "WORKSHOP" with the following fields:
(WORKSHOP#, WORKSHOP_NAME COORDINATOR, CO_COORDINATOR, NO_OF_DAYS, VENUE, START_DATE, END_DATE, NO_OF_MAX_ PARTICIPANTS, NO_OF_RESOURCE_PERSONS, YEAR)
Select appropriate data types for the fields. Identify the primary key. Input to meaningful records.
4. For the above table in Q3, answer the following queries using SQL 5x2=10
To display all the WORKSHOPS conducted during 2015.
To display the dates of WORKSHOP# "111".
To display all the co-ordinators of workshops conducted during 2013.
To display the NO_OF_MAX_PARTICIPANTS and NO_OF_RESOURCE_PERSONS for the WORKSHOP conducted in seminar_hall on 29-08-2014 for one day.
To display the VENUE's list of all the WORKSHOPS conducted during 2012.
IMCSL-045 -Set -21
MASTER OF COMPUTER APPLICATIONS (Revised)
Term-End Examination
02106
June, 2016
MCSL-045 -Set UNIX AND DBMS LAB
Time hours Maximum Marks: 50
Note: There are 2 sections in this paper.
All the 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 commands in UNIX: 5x1=5
To print the last 10 lines of any file.
To print the most recent status of the system like who are the current logged -in users.
To print the information about the active processes.
To create or change a password.
To delete files from a directory.
2. Write a shell program, using "grep" to locate a given string and count its no. of 15 occurrences in a file.
SECTION
DBMS
3. Create a table "WORKSHOP" with the following fields:
(WORKSHOP#, WORKSHOP_NAME COORDINATOR, CO_COORDINATOR, NO_OF_DAYS, VENUE, START_DATE, END_DATE, NO_OF_MAX_ PARTICIPANTS, NO_OF_RESOURCE_PERSONS, YEAR)
Select appropriate data types for the fields. Identify the primary key. Input to meaningful records.
4. For the above table in Q3, answer the following queries using SQL 5x2=10
To display all the WORKSHOPS conducted during 2015.
To display the dates of WORKSHOP# "111".
To display all the co-ordinators of workshops conducted during 2013.
To display the NO_OF_MAX_PARTICIPANTS and NO_OF_RESOURCE_PERSONS for the WORKSHOP conducted in seminar_hall on 29-08-2014 for one day.
To display the VENUE's list of all the WORKSHOPS conducted during 2012.
Other Question Papers
Departments
- Centre for Corporate Education, Training & Consultancy (CCETC)
- Centre for Corporate Education, Training & Consultancy (CCETC)
- National Centre for Disability Studies (NCDS)
- School of Agriculture (SOA)
- School of Computer and Information Sciences (SOCIS)
- School of Continuing Education (SOCE)
- School of Education (SOE)
- School of Engineering & Technology (SOET)
- School of Extension and Development Studies (SOEDS)
- School of Foreign Languages (SOFL)
- School of Gender Development Studies(SOGDS)
- School of Health Science (SOHS)
- School of Humanities (SOH)
- School of Interdisciplinary and Trans-Disciplinary Studies (SOITDS)
- School of Journalism and New Media Studies (SOJNMS)
- School of Law (SOL)
- School of Management Studies (SOMS)
- School of Performing Arts and Visual Arts (SOPVA)
- School of Performing Arts and Visual Arts(SOPVA)
- School of Sciences (SOS)
- School of Social Sciences (SOSS)
- School of Social Work (SOSW)
- School of Tourism & Hospitality Service Sectoral SOMS (SOTHSM)
- School of Tourism &Hospitality Service Sectoral SOMS (SOTHSSM)
- School of Translation Studies and Training (SOTST)
- School of Vocational Education and Training (SOVET)
- Staff Training & Research in Distance Education (STRIDE)
Subjects
- Advanced database management systems
- Assembly Language Programming Lab
- C and Assembly Language Programming
- C Language Programming
- C' Programming and Data Structure
- C++ Programming Lab
- Computer Basics And PC Software Lab
- Computer Fundamentals and PC Software
- Computer Networks
- COMPUTER ORIENTED NUMERICAL TECHNIQUES LAB
- Data And File Structures Lab
- Data Base Management System Lab
- Internet Concepts and Web Design
- Introduction to algorithm design lab
- Introduction to Internet Programming (Java)
- Introduction to System Software
- Java Programming Lab
- Laboratory Course (For Data and File Structures, Networking, DBMS Lab & Java Programming
- Laboratory Course (For OOAD, Software Engineering and Accountancy and Financial Management
- Laboratory Course in (Advanced Internet Technologies & Computer Graphics and Multimedia)
- Network Programming and Administration Lab
- Operating System Concepts and Network Management Lab
- RDBMS Lab
- Statistical Techniques Lab
- TCP/IP Programming
- UNIX and DBMS Lab
- WEB PROGRAMMING LAB
- Windows Programming