Exam Details
Subject | Data Base Management System 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, 2015 | |
City, State | new delhi, |
Question Paper
1. Create the following table "COMPLAINTS" with the following fields:
(COMPLAINT_ID, COMPLAINT_CATEGORY, COMPLAINT_DATE, SUPERVISOR_NAME, ALLOCATED_TO, COMPLAINT_DESCRIPTION)
Select appropriate datatypes for all the fields. Select a primary key. Input 10 meaningful records with appropriate data.
2. For the above created table in Q.1, answer the following queries using SQL:
Display the Complaint_description of Complaint_ID 123.
Display the Complaint_allocated person to handle Complaint_ID =123.
Display all the Complaint_IDs, Complaint_descriptions of yesterday.
Display the Supervisor_name who is handling Complaint_ID "123".
Display all the "Categories" of complaints.
(COMPLAINT_ID, COMPLAINT_CATEGORY, COMPLAINT_DATE, SUPERVISOR_NAME, ALLOCATED_TO, COMPLAINT_DESCRIPTION)
Select appropriate datatypes for all the fields. Select a primary key. Input 10 meaningful records with appropriate data.
2. For the above created table in Q.1, answer the following queries using SQL:
Display the Complaint_description of Complaint_ID 123.
Display the Complaint_allocated person to handle Complaint_ID =123.
Display all the Complaint_IDs, Complaint_descriptions of yesterday.
Display the Supervisor_name who is handling Complaint_ID "123".
Display all the "Categories" of complaints.
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