DBMS PYQS UNIT WISE
About this PDF
It contains unit wise SPPU pyqs Unit Conatins- Unit I - Introduction to Database Management System Introduction to Database Management Systems, Purpose of Database Systems, Database-System Applications, View of Data, Database Languages, Database System Structure, Enterprise Constraints Data Models, Database Design and ER Model: Entity, Attributes, Relationships, Constraints, Keys, Design Process, Entity Relationship Model, ER Diagram, Design Issues, Extended E-R Features, Converting E-R & EER diagram into tables. Unit II - SQL and PL/SQL SQL: DDL, DML, Select Queries, String, Date and Numerical Functions, Aggregate Functions ,View, Indexes, Group by and Having Clause, Join Queries, Set, Set operation, Set membership, Nested queries, DCL, TCL PL/SQL: Control Statement, Cursor, Stored Procedure and Function, Trigger Unit III - Relational Database Design Relational Model: Basic concepts, Attributes and Domains, CODD’s Rules, Relational Integrity, Referential Integrities, Database Design: Features of Good Relational Designs, Normalization, Atomic Domains and First Normal Form, Decomposition using Functional Dependencies, 2NF, 3NF, BCNF. Unit IV - Database Transactions Basic concept of a Transaction, Transaction Management, Properties of Transactions, ACID, Concept of Schedule, Serial Schedule, Serializability: Conflict and View, Cascaded Aborts, Recoverable and Non-recoverable Schedules, Concurrency Control: Need, Locking Methods. Unit V - NoSQL Database Introduction to NoSQL Database, NoSQL data models, CAP theorem and BASE Properties, Comparative study of SQL and NoSQL, MongoDB: CRUD Operations, Indexing and Aggregation.
Topics covered
Headings from inside this PDF (12 pages in total).
- UNIT 1
- UNIT 2
- 1. Consider the following schemas [6]
- 3. Explain cursor in SQL with example. [4]
- 6. What is sequence? How to create and use sequence in SQL?
- 7. Consider following schema [4]
- 9. Consider following schema [5]
- 10. Consider the following relation schema [6]
- 12. What is synonym? How to create and use synonym in SQL?
- 19. Consider following schema. [5]
What you get
Details
- Format
- PDF · 12 pages
- Pages
- 12 pages
- Language
- English
- Size
- 936 KB
- Delivery
- Read PDFs online — not downloadable, instantly after payment
- Access
- 365 days from purchase
- Sold by
- Disha Singh
- Published
- 19 November 2026







