Exam Details
| Subject | Database Management System | |
| Paper | ||
| Exam / Course | Diploma -VIEP-Computer Science and Engineering(DCSVI)/Advanced Level O Certificate Course In Cse (ACCSVI) B.Tech. Computer Science And Engineering (BT | |
| Department | School of Engineering & Technology (SOET) | |
| Organization | indira gandhi national open university | |
| Position | ||
| Exam Date | December, 2015 | |
| City, State | new delhi, |
Question Paper
1. Choose the correct answer from the given four alternatives:
Which of the following is a Database Language?
Data Definition Language
Data Manipulation Language
Query Language
All of the above
Set of permitted values of each attribute is called
Domain
Tuple
Schema
Relation
In an ER diagram, ellipses represent
Entity Sets
Attributes
Database
Tables
Which of the following is not a Unary Operation?
Rename
Projection
Union
Select
A primary key must be
Unique
Not Null
Both and
None of the above
BCNF stands for
Bit Code Normal Format
Boyce Codd Normal Form
Binary Code Normal Form
None of the above
ACID properties refer to
Atomicity, Consistency, Isolation,Durability
Atomicity, Consistency, Integrity,Durability
Atomicity, Concurrency, Integrity, Durability
Atomicity, Concurrency, Isolation,Durability
What are the Database Applications Compare the database system against the traditional file system.
Describe the various levels of data abstraction in a database management system.
Explain the concept of Integrity Constraint in detail. Also describe the process of destroying tables.
Using suitable examples, explain the Selection and the Projection set operations.
Assuming that there is a Table Emp Name, Department, Salary),write the SQL queries for the following cases:
Show all contents of the table Emp.
Show the Employee record who has Maximum Salary.
Show the total number of employees in the table.
Delete the table Emp.
Explain the various aggregative operators using suitable examples.
Differentiate between the SECOND and THIRD normal form, using suitable examples.
Using a suitable example, explain Outer Join in detail.
What is Indexing? Explain the Tree-based Indexing in detail.
What are Dependency Preserving Decompositions Explain using suitable example.
Explain the concept of Transactions and Schedules.
Explain how Concurrency is achieved without Locks.
8. Write short notes on any four of the following;
Instance and Schema
Relational Algebra
SQL Triggers
BCNF
Cluster Indexes
Concurrency Control
Which of the following is a Database Language?
Data Definition Language
Data Manipulation Language
Query Language
All of the above
Set of permitted values of each attribute is called
Domain
Tuple
Schema
Relation
In an ER diagram, ellipses represent
Entity Sets
Attributes
Database
Tables
Which of the following is not a Unary Operation?
Rename
Projection
Union
Select
A primary key must be
Unique
Not Null
Both and
None of the above
BCNF stands for
Bit Code Normal Format
Boyce Codd Normal Form
Binary Code Normal Form
None of the above
ACID properties refer to
Atomicity, Consistency, Isolation,Durability
Atomicity, Consistency, Integrity,Durability
Atomicity, Concurrency, Integrity, Durability
Atomicity, Concurrency, Isolation,Durability
What are the Database Applications Compare the database system against the traditional file system.
Describe the various levels of data abstraction in a database management system.
Explain the concept of Integrity Constraint in detail. Also describe the process of destroying tables.
Using suitable examples, explain the Selection and the Projection set operations.
Assuming that there is a Table Emp Name, Department, Salary),write the SQL queries for the following cases:
Show all contents of the table Emp.
Show the Employee record who has Maximum Salary.
Show the total number of employees in the table.
Delete the table Emp.
Explain the various aggregative operators using suitable examples.
Differentiate between the SECOND and THIRD normal form, using suitable examples.
Using a suitable example, explain Outer Join in detail.
What is Indexing? Explain the Tree-based Indexing in detail.
What are Dependency Preserving Decompositions Explain using suitable example.
Explain the concept of Transactions and Schedules.
Explain how Concurrency is achieved without Locks.
8. Write short notes on any four of the following;
Instance and Schema
Relational Algebra
SQL Triggers
BCNF
Cluster Indexes
Concurrency Control
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 ComputerArchitecture
- Algorithms and Logic Design
- Artificial Intelligence
- Basics of Networking
- Bio-Informatics
- C P r o g r a m m i n g
- Computer Architecture
- Computer Networks
- Computer Organisations
- Computer Organization
- Cryptography And Network Security
- Data Modelling And Uml
- Data Structures
- Data Warehousing And Mining
- Database Management System
- Design And Analysis Of Algorithm
- Digital Image Processing
- Discrete Maths Structure
- Distributed Database
- E-Business
- Elective-Computer Networks
- Embedded System
- Formal Languages And Automata
- Fuzzy Systems
- Java Basic and Object Modeling Design
- Logic Design
- Microprocessor
- Mobile Computing
- Neural Network
- Numerical Methods and Computation
- Object Modeling And Design
- Object Oriented Design And Programming
- Object Oriented Programming
- Operating System
- Operating Systems
- Parallel Algorithms
- Pattern Recognition
- PC Assembly and Maintenance
- Principles of Communication Engineering
- Principles Of Programming Languages
- Real Time Systems
- Software Engineering
- Software Project Management (Spm)
- Software Quality Engineering
- Software Reusability
- System Analysis and Design
- System Programming And Compiler Design
- Theory Of Computation
- Unix Internals And Shell Programming
- Visual Basic Programming
- Web Technology