JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech II DATABASE MANAGEMENT SYSTEMS Previous Question Paper (April - 2018 - R13)
Note: This question paper contains two parts A and B. Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit.
Part A
What are five main functions of database Administrator?
Answer
The five main functions of a Database Administrator (DBA) are:
- Schema Definition: Creating the original database schema by executing a set of data definition statements.
- Storage Structure and Access Method Definition: Defining the physical storage structures and access methods to ensure efficient data retrieval.
- Schema and Physical Organization Modification: Modifying the database schema or physical organization to adapt to changing requirements or performance needs.
- Granting Authorization: Controlling access to the database by granting specific privileges to users to ensure data security.
- Routine Maintenance: Monitoring database performance, performing backups, and ensuring data integrity and recovery procedures are in place.
List four significant difference between a file processing system and DBMS.
Answer
The four significant differences between a file processing system and a Database Management System (DBMS) are:
- Data Redundancy and Inconsistency: In file systems, data is often duplicated across multiple files leading to inconsistency, whereas a DBMS minimizes redundancy through centralized data control.
- Data Isolation: File systems store data in different formats across various files, making it difficult to access or combine data. A DBMS provides a unified structure, allowing for easier data retrieval and integration.
- Concurrent Access: File systems generally do not support efficient concurrent access, often leading to data corruption. A DBMS includes sophisticated concurrency control mechanisms to allow multiple users to access data simultaneously without conflict.
- Security and Integrity: DBMS provides robust security mechanisms, such as user authentication and authorization, and enforces integrity constraints to ensure data accuracy, which are typically absent or difficult to implement in file processing systems.
Explain about set membership in SQL.
Answer
Sign in to view the complete answer paper.
Explain Outer join operators in relational algebra.
Answer
Sign in to view the complete answer paper.
What is functional dependency?
Answer
Sign in to view the complete answer paper.
Explain about join Dependency.
Answer
Sign in to view the complete answer paper.
What is fuzzy check point?
Answer
Sign in to view the complete answer paper.
What are the different types of log records and when they are written?
Answer
Sign in to view the complete answer paper.
What is the main difference between static and dynamic hashing?
Answer
Sign in to view the complete answer paper.
What are the main difference between static and dynamic index structure?
Answer
Sign in to view the complete answer paper.
Part B
What is data model? What is the relational data model? What is data independence and how does a DBMS support it.
Answer
Sign in to view the complete answer paper.
What is E-R Model? Draw an E-R Diagram for online book store.
Answer
Sign in to view the complete answer paper.
Explain the difference between external, internal and conceptual schemas. How these different schema layers are related to logical and physical data independence.
Answer
Sign in to view the complete answer paper.
Draw an ER-Diagram for Specialization, generalization and aggregation.
Answer
Sign in to view the complete answer paper.
Explain Domain Integrity constraints in SQL.
Answer
Sign in to view the complete answer paper.
Give an overview of active databases.
Answer
Sign in to view the complete answer paper.
Explain various DML statement in SQL with example.
Answer
Sign in to view the complete answer paper.
Explain Aggregate and database modification operators in relational algebra.
Answer
Sign in to view the complete answer paper.
What is normalization? What are the conditions are required for a relation to be in 1NF, 2NF and 3NF. Explain with examples.
Answer
Sign in to view the complete answer paper.
Explain the following with examples: i) Join Dependency ii) multivalued dependency.
Answer
Sign in to view the complete answer paper.
Suppose that we decompose the schema R = (A, B, C, D, E) into R1 (A, B, C) and R2 (A, D, E). Show that this decomposition is lossless-join decomposition if the following set F of functional dependencies holds: A → BC, CD → E, B → D, E → A
Answer
Sign in to view the complete answer paper.
What are the condition are required for 4NF and 5NF Normal forms explain with examples?
Answer
Sign in to view the complete answer paper.
What is Concurrency control? Explain how multiple granularity protocol is used to Control concurrent transactions.
Answer
Sign in to view the complete answer paper.
Explain what happens if there are crashes during undo phase of recovery? What if there are crashes during the analysis phase and redo phase.
Answer
Sign in to view the complete answer paper.
Explain conservative Time Stamp-Based Concurrency Control protocol.
Answer
Sign in to view the complete answer paper.
What are the problems with lock-based concurrency control protocols.
Answer
Sign in to view the complete answer paper.
Describe how insert and delete operations work in ISAM.
Answer
Sign in to view the complete answer paper.
What are the problems with storage of data on external storage? Explain.
Answer
Sign in to view the complete answer paper.
Describe the B+ tree insert and delete operations with examples.
Answer
Sign in to view the complete answer paper.
What is Hashing? Discuss the relation between extendable hashing and Linear Hashing. What are their relative merits?
Answer
Sign in to view the complete answer paper.