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. 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) include schema definition, storage structure and access method definition, schema and physical organization modification, granting authorization for data access, and routine maintenance such as monitoring performance and backing up data.
List four significant difference between a file processing system and DBMS.
Answer
Differences between File Processing Systems and DBMS include: 1) Data redundancy and inconsistency are high in file systems but controlled in DBMS. 2) DBMS provides data independence (physical and logical), whereas file systems are highly dependent on application programs. 3) DBMS offers centralized control and security, while file systems lack robust access control. 4) DBMS supports concurrent access and transaction management, which is not natively available in file 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 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.