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, 2016 | |
| City, State | new delhi, |
Question Paper
No. of Printed Pages 5 IBIC8-038 I DIPLOMA -VIEP -COMPUTER SCIENCE AND ENGINEERING (DCSVI) Term-End Examination 2016
BICS-038 DATABASE MANAGEMENT SYSTEM
Time: 2 hours Maximum Marks: 70
Note: Attempt five questions in all. Question no. 1 is compulsory. Each question carries equal marks.
1. Choose the correct answer from the given four alternatives: 7 x 2=14
Foreign key cannot be null, relates to
Entity Integrity Constraint
Referential Integrity Constraint
Domain Integrity Constraint
None of the above
DDL stands for
Data Definition Language
Data Description Language
Data Decomposition Language
Data Derivation Language
SQL commands INSERT, DELETE, UPDATE, come under the purview of
DDL
DML
DCL
None of the above
Issues related to partial functional dependency are resolved in normal form.
First
Second
Third
None of the above
protocol relates to concurrency management.
2-Phase Locking
2-Phase Commit
Both and
None of the above
Nouns identify of ER Diagrams.
Entities
Relations
Attributes
None of the above
is the minimal super key.
Primary key
Secondary key
Foreign key
Composite key
2. Explain the following with the help of suitable examples:
Third Normal Form
Boyce-Codd Normal Form (BCNF)
Also prove that "BCNF is stronger than 3NF".
3. Draw an ER Diagram for the following statement:
"Teachers teach students in an institute affiliated to a University."
Choose proper set of attributes for each component in the diagram. Prepare the database for each component, as per the identified schema. 7
Differentiate between the following: 7
2-Phase Commit and 2-Phase Locking
File Base System and Database Management System
4. Perform the following operations on the relations RI and R2 given below: 4x2=8
R1: A B R2: A B
A1 B1 A1 B1
A2 B2 A7 B7
A3 B3 A2 B2
A4 B4 A4 B4
R1 U R2
R1 n R2
R1 x R2
R1 D R2
Discuss the concept of in databases. What are the advantages of Can we perform insert, delete or modify operations, if the view contains a group function Justify your answer with suitable arguments.
5. Write short notes on any two of the following: 2x3 1/2
Wait-die Protocol
Wait-wound Protocol
Optimistic Scheduling
What are triggers in DBMS Discuss the role of triggers in DBMS. List the constraints imposed on SQL triggers.
6. Differentiate between the following: 7+7=14
Hash based Indexing and Tree based Indexing
Cluster Indexes, Primary and Secondary Indexes
7. Discuss the role of ACID properties for managing the transactions in concurrent environment. Violation of which property relates to "Lost update problem" Discuss the "Lost update problem" with a suitable example.
8. Draw the diagram of three-level architecture of a database. Discuss. the role of each level, along with the languages and SQL commands operational at each level. How is the working of these three levels related to the concept of data independence?
BICS-038 DATABASE MANAGEMENT SYSTEM
Time: 2 hours Maximum Marks: 70
Note: Attempt five questions in all. Question no. 1 is compulsory. Each question carries equal marks.
1. Choose the correct answer from the given four alternatives: 7 x 2=14
Foreign key cannot be null, relates to
Entity Integrity Constraint
Referential Integrity Constraint
Domain Integrity Constraint
None of the above
DDL stands for
Data Definition Language
Data Description Language
Data Decomposition Language
Data Derivation Language
SQL commands INSERT, DELETE, UPDATE, come under the purview of
DDL
DML
DCL
None of the above
Issues related to partial functional dependency are resolved in normal form.
First
Second
Third
None of the above
protocol relates to concurrency management.
2-Phase Locking
2-Phase Commit
Both and
None of the above
Nouns identify of ER Diagrams.
Entities
Relations
Attributes
None of the above
is the minimal super key.
Primary key
Secondary key
Foreign key
Composite key
2. Explain the following with the help of suitable examples:
Third Normal Form
Boyce-Codd Normal Form (BCNF)
Also prove that "BCNF is stronger than 3NF".
3. Draw an ER Diagram for the following statement:
"Teachers teach students in an institute affiliated to a University."
Choose proper set of attributes for each component in the diagram. Prepare the database for each component, as per the identified schema. 7
Differentiate between the following: 7
2-Phase Commit and 2-Phase Locking
File Base System and Database Management System
4. Perform the following operations on the relations RI and R2 given below: 4x2=8
R1: A B R2: A B
A1 B1 A1 B1
A2 B2 A7 B7
A3 B3 A2 B2
A4 B4 A4 B4
R1 U R2
R1 n R2
R1 x R2
R1 D R2
Discuss the concept of in databases. What are the advantages of Can we perform insert, delete or modify operations, if the view contains a group function Justify your answer with suitable arguments.
5. Write short notes on any two of the following: 2x3 1/2
Wait-die Protocol
Wait-wound Protocol
Optimistic Scheduling
What are triggers in DBMS Discuss the role of triggers in DBMS. List the constraints imposed on SQL triggers.
6. Differentiate between the following: 7+7=14
Hash based Indexing and Tree based Indexing
Cluster Indexes, Primary and Secondary Indexes
7. Discuss the role of ACID properties for managing the transactions in concurrent environment. Violation of which property relates to "Lost update problem" Discuss the "Lost update problem" with a suitable example.
8. Draw the diagram of three-level architecture of a database. Discuss. the role of each level, along with the languages and SQL commands operational at each level. How is the working of these three levels related to the concept of data independence?
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