JNTU ananthapur R23 btech 2nd year -1sem DBMS November 2026 semester exam
Full explanation, worked examples & memory tricks in the app
DBMS Exam Prep
English 50 leveled MCQs Free
Shared by a Veda learner · Generated with Veda AI
Smart notes
1
What you'll study, topic by topic
Solved paper preview
Sample questions with model answers
Every question in the paper gets a full exam-length answer in the app — organised by marks, the way a topper writes it.
10 marks Long answer
Write a brief note on data models in DBMS?
Show answer outline
Data models define how data is organized and manipulated.
The full exam-length answer is in the app.
10 marks Long answer
Discuss about centralized and client server architecture?
Show answer outline
Centralized architecture has a single server, while client-server architecture distributes tasks across multiple servers.
The full exam-length answer is in the app.
10 marks Long answer
Explain the three-schema architecture of database and the role of achieving data independence?
Show answer outline
The three-schema architecture separates user views, logical structure, and physical storage to achieve data independence.
The full exam-length answer is in the app.
10 marks Long answer
Explain Entity, Attributes, and key constraints participation in ER-diagrams?
Show answer outline
ER-diagrams represent entities, their attributes, and constraints like primary keys.
The full exam-length answer is in the app.
10 marks Long answer
What is normalization? Compare 1NF, 2NF, 3NF using an example?
Show answer outline
Normalization organizes data to reduce redundancy; 1NF, 2NF, and 3NF have increasing levels of normalization.
The full exam-length answer is in the app.
10 marks Long answer
Write about the concept of database users in database system?
Show answer outline
Database users include administrators, developers, and end-users who interact with the database.
The full exam-length answer is in the app.
10 marks Long answer
Describe the role of database users in database system?
Show answer outline
Database users perform operations such as data entry, querying, and reporting.
The full exam-length answer is in the app.
10 marks Long answer
Explain about DDL, DQL commands in SQL?
Show answer outline
DDL commands define database structure; DQL commands query data.
The full exam-length answer is in the app.
10 marks Long answer
Write about the relational algebra operations?
Show answer outline
Relational algebra operations include selection, projection, union, and join.
The full exam-length answer is in the app.
10 marks Long answer
Write a short note on relational calculus in database?
Show answer outline
Relational calculus is a non-procedural query language based on mathematical logic.
The full exam-length answer is in the app.
10 marks Long answer
Write a note on SQL functions?
Show answer outline
SQL functions perform operations on data, such as COUNT, SUM, and AVG.
The full exam-length answer is in the app.
10 marks Long answer
What is SQL join? Implement different types of join in SQL?
Show answer outline
SQL joins combine rows from two or more tables based on related columns.
The full exam-length answer is in the app.
10 marks Long answer
What is VIEW in DBMS? Discuss about updatable and non-updatable views using an example?
Show answer outline
A VIEW is a virtual table; updatable views allow data changes, while non-updatable views do not.
The full exam-length answer is in the app.
10 marks Long answer
Define a nested query? Also implement an inner query using GROUP BY, HAVING clauses?
Show answer outline
A nested query is a query within another query; it can be used with GROUP BY and HAVING clauses.
The full exam-length answer is in the app.
10 marks Long answer
Write a short note on Boyce cod normal form also how it differ from 3NF?
Show answer outline
BCNF is a stricter version of 3NF that addresses certain anomalies.
The full exam-length answer is in the app.
10 marks Long answer
What is the purpose of normalization? Also write the advantages of Normalization in database?
Show answer outline
Normalization aims to reduce redundancy and improve data integrity.
The full exam-length answer is in the app.
10 marks Long answer
Discuss about fourth normal form using an example?
Show answer outline
Fourth normal form eliminates multi-valued dependencies.
The full exam-length answer is in the app.
10 marks Long answer
What is serializability? Explain the view serializability and conflict serializability using an example?
Show answer outline
Serializability ensures transactions yield the same result as a serial schedule; view and conflict serializability are two types.
The full exam-length answer is in the app.
10 marks Long answer
Discuss about lock based protocols in database transactions?
Show answer outline
Lock-based protocols use locks to control access to data during transactions.
The full exam-length answer is in the app.
10 marks Long answer
What are Recoverable and non-recoverable database transactions?
Show answer outline
Recoverable transactions can be rolled back, while non-recoverable cannot.
The full exam-length answer is in the app.
10 marks Long answer
Write about B+ tree operations in database also explain the operations using an example?
Show answer outline
B+ tree operations include insertion, deletion, and searching, maintaining sorted order.
The full exam-length answer is in the app.
2 marks Short answer
What are the functions of DBMS?
Show answer outline
Functions include data storage, retrieval, and management.
The full exam-length answer is in the app.
2 marks Short answer
Advantages of DBMS?
Show answer outline
Advantages include data integrity, security, and reduced redundancy.
The full exam-length answer is in the app.
2 marks Short answer
Difference between File system and Database system?
Show answer outline
Database systems provide structured data management, while file systems store data in unstructured formats.
The full exam-length answer is in the app.
2 marks Short answer
Write a note on Database user?
Show answer outline
Database users interact with the database to perform operations like querying and updating data.
The full exam-length answer is in the app.
2 marks Short answer
What is an entity and attributes in ER model?
Show answer outline
An entity is an object, and attributes are its properties.
The full exam-length answer is in the app.
2 marks Short answer
What is Relationship? Also degree of relationship in ER model?
Show answer outline
A relationship connects entities; its degree indicates the number of entities involved.
The full exam-length answer is in the app.
2 marks Short answer
Explain the concept of Inheritance?
Show answer outline
Inheritance allows one entity to inherit attributes from another.
The full exam-length answer is in the app.
2 marks Short answer
Define database schema?
Show answer outline
A database schema defines the structure of the database.
The full exam-length answer is in the app.
2 marks Short answer
What is a tuple?
Show answer outline
A tuple is a single row in a table representing a record.
The full exam-length answer is in the app.
2 marks Short answer
Importance of Null values?
Show answer outline
Null values indicate missing or unknown data.
The full exam-length answer is in the app.
2 marks Short answer
Discuss about primary key, candidate key, Super key?
Show answer outline
Primary key uniquely identifies records; candidate keys are potential primary keys; super key includes all attributes that can uniquely identify records.
The full exam-length answer is in the app.
2 marks Short answer
Differentiate between ALTER and UPDATE command?
Show answer outline
ALTER modifies the database structure, while UPDATE modifies existing data.
The full exam-length answer is in the app.
2 marks Short answer
Explain about different integrity constraints?
Show answer outline
Integrity constraints ensure data accuracy and consistency.
The full exam-length answer is in the app.
2 marks Short answer
Write an SQL query using SELECT and WHERE clause?
Show answer outline
SELECT * FROM table_name WHERE condition;
The full exam-length answer is in the app.
2 marks Short answer
Write an SQL query using BETWEEN operator?
Show answer outline
SELECT * FROM table_name WHERE column_name BETWEEN value1 AND value2;
The full exam-length answer is in the app.
2 marks Short answer
Differences between UPTABLE and NON-UPTABLE views?
Show answer outline
UPDATABLE views allow data modifications; NON-UPDATABLE views do not.
The full exam-length answer is in the app.
2 marks Short answer
Write about relational set operations?
Show answer outline
Relational set operations include union, intersection, and difference.
The full exam-length answer is in the app.
2 marks Short answer
Define schema refinement?
Show answer outline
Schema refinement improves the structure of the database schema.
The full exam-length answer is in the app.
2 marks Short answer
What is functional dependency?
Show answer outline
Functional dependency is a relationship where one attribute uniquely determines another.
The full exam-length answer is in the app.
2 marks Short answer
Define lossless join in DBMS?
Show answer outline
A lossless join preserves all data when tables are joined.
The full exam-length answer is in the app.
2 marks Short answer
Discuss the concept of surrogate key?
Show answer outline
A surrogate key is an artificial key used to uniquely identify records.
The full exam-length answer is in the app.
2 marks Short answer
Explain dependency preservation in decomposition?
Show answer outline
Dependency preservation ensures that all functional dependencies are maintained after decomposition.
The full exam-length answer is in the app.
2 marks Short answer
Explain ACID properties in database transactions?
Show answer outline
ACID properties ensure Atomicity, Consistency, Isolation, and Durability.
The full exam-length answer is in the app.
2 marks Short answer
What is recoverability?
Show answer outline
Recoverability ensures that transactions can be rolled back to a consistent state.
The full exam-length answer is in the app.
2 marks Short answer
Discuss the test of serializability?
Show answer outline
The test of serializability checks if a schedule can be transformed into a serial schedule.
The full exam-length answer is in the app.
2 marks Short answer
What are the B+ tree operations?
Show answer outline
B+ tree operations include insertion, deletion, and searching.
The full exam-length answer is in the app.
2 marks Short answer
Define deadlock?
Show answer outline
Deadlock occurs when two or more transactions are waiting indefinitely for each other.
The full exam-length answer is in the app.
2 marks Short answer
Write about concurrency protocols?
Show answer outline
Concurrency protocols manage simultaneous transaction execution to maintain consistency.
The full exam-length answer is in the app.
2 marks Short answer
Discuss about shared and exclusive locks?
Show answer outline
Shared locks allow concurrent reads; exclusive locks prevent other transactions from accessing the resource.
The full exam-length answer is in the app.
Study it properly — free, in the app
The full Veda Bites deck, complete notes, spaced-repetition flashcards, leveled MCQs, tests and games for this kit — plus Daily Facts and the Arena, every day.