Exam Details
| Subject | Information Systems- Practical | |
| Paper | ||
| Exam / Course | Post Graduate Diploma in Library Automation and Networking | |
| Department | School of Social Sciences (SOSS) | |
| Organization | indira gandhi national open university | |
| Position | ||
| Exam Date | June, 2016 | |
| City, State | new delhi, |
Question Paper
Note: Attempt the following questions using the SQL Commands or MS -Access.
1. Create a database 'Serials' with two tables and 'holdings'.
Add the following fields in the table Key_Title, Editor, Publisher, ISSN and Frequency.
Add five records in the table 'Journal'.
Add the following fields in the table 'holdings' Price, Vol_No, Issue_No, Place and Journal_URL.
Add five records in the table 'holdings'.
3. Retrieve all Journals in the table 'Journal' where Frequency is equal or higher than 4/year.
4. Retrieve all records from the table 'holdings' and display records in descending order by price.
1. Create a database 'Serials' with two tables and 'holdings'.
Add the following fields in the table Key_Title, Editor, Publisher, ISSN and Frequency.
Add five records in the table 'Journal'.
Add the following fields in the table 'holdings' Price, Vol_No, Issue_No, Place and Journal_URL.
Add five records in the table 'holdings'.
3. Retrieve all Journals in the table 'Journal' where Frequency is equal or higher than 4/year.
4. Retrieve all records from the table 'holdings' and display records in descending order by price.
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
- Content Development
- Content Development- Practical
- Information Systems
- Information Systems- Practical
- Information, Communication And Society
- Internet Resources
- Internet Resources- Practical
- Introduction to Computers
- Introduction to Computers- Practical
- Library Automation
- Library Automation- Practical
- Networking and Internet Technology
- Networking and Internet Technology- Practical
- Programming (c++)
- Programming- Practical