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 | June, 2015 | |
| City, State | new delhi, |
Question Paper
1. Choose the correct answer from the given four alternatives:
DML stands for
Data Managing Language
Data Management Layer
Data Manipulation Layer
Data Manipulation Language
Which of the following is not a level of data abstraction
Physical level
Logical level
View level
Critical level
In an ER-Diagram, rectangles represent
Entity Sets
Attributes
Database
Tables
Which of the following is not a Binary Operation?
Project
Union
Set-difference
Cartesian Product
Command to remove a relation from an SQL database is
Delete Table table name>
Drop Table table name>
Rename Table table name>
None of the above
ACID properties refer to
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Integrity,Durability
Atomicity, Concurrency, Integrity, Durability
Atomicity, Concurrency, Isolation, Durability
In a Database, to avoid the problems of concurrent updates we use
Pauses
Locks
Halts
Breaks
What is a Database Management System Explain its applications in the modern day scenario.
What is an Entity What do you understand by ER-Diagram Construct an ER-Diagram for your department mentioning its entities, their attributes and their relations.
Describe the Relational Model in detail, using suitable examples.
Differentiate between Primary Key, Candidate Key and Foreign Key, using suitable examples.
Explain the form of basic SQL queries along with examples.
What are SQL triggers Explain the various constraints on SQL triggers.
Differentiate between the FIRST and SECOND normal form using suitable examples.
Using suitable examples, explain the Multi-valued dependencies in detail.
Explain the concept of Hash based indexing in detail.
What is File Organization? Explain how data is stored on external storage.
Explain the concept of Transaction Management in detail.
Differentiate between Serializability and Recoverability in detail.
8. Write short notes on any four of the following:
Data Models
Views
Logical Database Design
Active Databases
Primary vs Secondary Indexes
Locks
DML stands for
Data Managing Language
Data Management Layer
Data Manipulation Layer
Data Manipulation Language
Which of the following is not a level of data abstraction
Physical level
Logical level
View level
Critical level
In an ER-Diagram, rectangles represent
Entity Sets
Attributes
Database
Tables
Which of the following is not a Binary Operation?
Project
Union
Set-difference
Cartesian Product
Command to remove a relation from an SQL database is
Delete Table table name>
Drop Table table name>
Rename Table table name>
None of the above
ACID properties refer to
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Integrity,Durability
Atomicity, Concurrency, Integrity, Durability
Atomicity, Concurrency, Isolation, Durability
In a Database, to avoid the problems of concurrent updates we use
Pauses
Locks
Halts
Breaks
What is a Database Management System Explain its applications in the modern day scenario.
What is an Entity What do you understand by ER-Diagram Construct an ER-Diagram for your department mentioning its entities, their attributes and their relations.
Describe the Relational Model in detail, using suitable examples.
Differentiate between Primary Key, Candidate Key and Foreign Key, using suitable examples.
Explain the form of basic SQL queries along with examples.
What are SQL triggers Explain the various constraints on SQL triggers.
Differentiate between the FIRST and SECOND normal form using suitable examples.
Using suitable examples, explain the Multi-valued dependencies in detail.
Explain the concept of Hash based indexing in detail.
What is File Organization? Explain how data is stored on external storage.
Explain the concept of Transaction Management in detail.
Differentiate between Serializability and Recoverability in detail.
8. Write short notes on any four of the following:
Data Models
Views
Logical Database Design
Active Databases
Primary vs Secondary Indexes
Locks
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