Jawaharlal Nehru Technological University Hyderabad
Jawaharlal Nehru Technological University Hyderabad B.Tech III DATABASE MANAGEMENT SYSTEMS Previous Question Paper (May/June - 2019 - R16)
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. Each question carries 10 marks.
PART - A
What is database management systems? Why we need to use it.
Answer
A Database Management System (DBMS) is software that manages, stores, retrieves, and updates data in a database. We use it to ensure data integrity, security, concurrency control, and to provide an efficient interface for users to interact with large volumes of structured data without needing to know the physical storage details.
Write the syntax for various commands present in DDL
Answer
Data Definition Language (DDL) commands are used to define the database structure:
- CREATE: CREATE TABLE table_name (column1 datatype, column2 datatype, ...);
- ALTER: ALTER TABLE table_name ADD column_name datatype;
- DROP: DROP TABLE table_name;
- TRUNCATE: TRUNCATE TABLE table_name;
In what way an IN Clause differs from OR clause
Answer
Sign in to view the complete answer paper.
Distinguish between NULL and NOT NULL.
Answer
Sign in to view the complete answer paper.
What is schema? Give example.
Answer
Sign in to view the complete answer paper.
Describe about the non trivial functional dependency.
Answer
Sign in to view the complete answer paper.
What is failure? When it occurs.
Answer
Sign in to view the complete answer paper.
Explain the role of serializability using transactions.
Answer
Sign in to view the complete answer paper.
Differentiate volatile and non volatile storage.
Answer
Sign in to view the complete answer paper.
List out the operations that can be performed on files.
Answer
Sign in to view the complete answer paper.
PART - B
Discuss the activities of different database users.
Answer
Sign in to view the complete answer paper.
List the steps in proper sequence in order to convert an ER and EER diagram into tables.
Answer
Sign in to view the complete answer paper.
Draw and explain three-tier schema architecture of database system.
Answer
Sign in to view the complete answer paper.
Describe the client server architecture for the database with necessary diagram.
Answer
Sign in to view the complete answer paper.
Explain any three Aggregate functions and Scalar functions with examples.
Answer
Sign in to view the complete answer paper.
Discuss the importance of entity integrity and referential integrity constraints.
Answer
Sign in to view the complete answer paper.
Solve the queries for the following database using Relational Algebra:
Branch (branch-name, branch-city, assets)
Customer (customer-name, customer-street, customer-only)
Account (account-number, branch-name, balance)
Loan (loan-number, branch-name, amount)
Depositor (customer-name, account-number)
Borrower (customer-name, loan-number)
Answer
Sign in to view the complete answer paper.
Elaborate Normalization. Explain any three normal forms with suitable example(s).
Answer
Sign in to view the complete answer paper.
What is functional dependency? Explain its types in detail.
Answer
Sign in to view the complete answer paper.
How to compute closure of set of functional dependency? Explain with a suitable example schema.
Answer
Sign in to view the complete answer paper.
Explain insertion, deletion, and modification anomalies.
Answer
Sign in to view the complete answer paper.
Discuss in detail about timestamp based concurrency control techniques.
Answer
Sign in to view the complete answer paper.
Explain steps of query processing with the help of neat diagram.
Answer
Sign in to view the complete answer paper.
Write about the transaction management with SQL using commit, rollback, and save point.
Answer
Sign in to view the complete answer paper.
Is B+ tree, a multi level indexing? How does it differ from B-tree?
Answer
Sign in to view the complete answer paper.
Compare dynamic hashing with static hashing.
Answer
Sign in to view the complete answer paper.
When does a collision occur in hashing? Illustrate various collision resolution techniques.
Answer
Sign in to view the complete answer paper.