DBMS Foundations: 15 flashcards
All 15 flashcards from this kit, free and with no sign-up.
1. What are the three levels of abstraction in a DBMS?
Show the answer
Physical, Logical, and View levels.
2. What does the Physical Level describe?
Show the answer
How data is actually stored on disk, including file organization, indexing, and hashing.
3. What does the Logical Level describe?
Show the answer
What data is stored, including tables, columns, relationships, and constraints.
4. What does the View Level show?
Show the answer
Only part of the database to specific users, enhancing security and simplicity.
5. Who typically interacts with the Physical Level?
Show the answer
Database Administrators, System Programmers, and DBMS Developers.
6. What is Physical Data Independence?
Show the answer
The ability to change physical storage without affecting the logical structure or applications.
7. What is Logical Data Independence?
Show the answer
The ability to change the logical schema without affecting user views or application programs.
8. Which is harder to achieve: physical or logical data independence?
Show the answer
Logical data independence is harder to achieve than physical data independence.
9. What is the Three-Schema Architecture (ANSI/SPARC)?
Show the answer
A framework separating the database into External, Conceptual, and Internal schemas.
10. What is the main difference between Two-Tier and Three-Tier Architecture?
Show the answer
Two-tier has client directly connecting to database; three-tier adds an application server in between.
11. What are the ACID properties?
Show the answer
Atomicity, Consistency, Isolation, and Durability.
12. What is the role of the Storage Manager?
Show the answer
Responsible for storing, retrieving, and updating data, acting as the interface between the database and the OS.
13. What is the role of the Query Processor?
Show the answer
Interprets, optimizes, and executes SQL commands.
14. What is a Data Model?
Show the answer
A blueprint that defines how data is stored, organized, and processed.
15. What is a Primary Key?
Show the answer
A selected Candidate Key used to uniquely identify records; must be unique and NOT NULL.
Your notes can be a kit like these
Every kit here was made from real study material. Point Veda at a chapter, a PDF, a photo or a link and get notes, flashcards, practice MCQs, games and a scored test — free, in 42 languages.
- Chapter notes
- Flashcards
- Practice MCQs
- Scored tests
- Exam prep
Get Veda free See what students get
Free to start · No ads · Works in 42 languages