DBMS Important Questions with Solutions: Complete Exam Prep
🔥 DBMS Most Important Questions with Solutions
1. Differentiate File Processing System and DBMS
Answer
| File Processing System | DBMS |
|---|---|
| Data stored in separate files | Data stored in organized database |
| High data redundancy | Redundancy controlled |
| Data inconsistency possible | Better consistency |
| Difficult data sharing | Easy data sharing |
| Limited security | Better security |
| Difficult concurrent access | Concurrency control provided |
| Recovery is difficult | Backup and recovery supported |
| Integrity constraints difficult | Integrity constraints |
DBMS Solved Answers: File Systems, Three-Schema Architecture, Constraints, ER-to-Relational Mapping and Relational Algebra
Worked for 36s
DBMS – Solved Answers
1. File Processing System vs DBMS
| File Processing System | DBMS |
|---|---|
| Data stored in separate files | Data stored in an integrated database |
| High data redundancy | Redundancy is controlled |
| Difficult data sharing | Easy data sharing |
| Program–data dependence | Program–data independence |
| Limited security | Strong security and authorization |
| Difficult backup/recovery | Provides backup and recovery |
| Poor concurrency control | Supports concurrency control |
Limitations of File Processing System
- Data redundancy
Database Schema vs Instance, Data Independence, Keys, Integrity Constraints and Relational Algebra Explained
1. Schema vs Instance
- Schema is the logical structure of a database.
- It defines the design of the database.
- It specifies tables and their attributes.
- It defines relationships between tables.
- It also defines database constraints.
- Schema is created during database design.
- Instance is the actual data stored in the database at a particular time.
- It represents the current state of the database.
- It changes when data is inserted.
- It changes when data is updated or deleted.
- An instance can be different at different
Major Agricultural and Industrial Schemes in India
Agricultural Development Schemes
1. PM-KISAN (Pradhan Mantri Kisan Samman Nidhi)
Objective: To provide direct income support to farmers.
Features
- ₹6,000 per year transferred directly to farmers
- Amount given in three installments
- Financial support for small and marginal farmers
Importance
- Supports farmers’ income
- Helps in purchasing seeds and fertilizers
- Reduces dependence on moneylenders
2. PMFBY (Pradhan Mantri Fasal Bima Yojana)
Objective: To provide crop insurance protection against natural calamities.
Read MoreConsumer Protection Laws and Rights: A Complete Study
1. Key Concepts in Consumer Protection
- Ethical Marketing: Promoting goods and services honestly, fairly, and responsibly to build trust.
- Right to Information: Consumers have the right to know the quality, quantity, price, and purity of goods.
- District Forum: A consumer court at the district level for settling disputes.
- Caveat Emptor: “Let the buyer beware”; the buyer must examine goods before purchase.
- Consumer Education: Educating consumers about their rights and methods of seeking redressal.
- Complaint:
Consumer Protection: Rights, Laws, and Market Ethics
UNIT–I: Consumer Protection
1. Concept and Types of Consumer
A consumer is a person who purchases goods or services for personal use and not for resale or commercial purposes. Consumers are the final users in the process of production and distribution. They play an important role in the economy because demand for goods and services depends on consumer needs and preferences.
Consumers can be classified into different types based on their purchasing behavior and usage:
- Individual consumers: Buy products