DBMS - Database Management System
Exam Questions and Answers (Latest
Update 2024)
Database - Correct Answer ✅ Collection of Data
Management System - Correct Answer ✅ a set of programs
to store and retrieve data.
DBMS - Correct Answer ✅ (Database Management System)
A collection of inter-related data that contains programs to
store & access that data in an easy and effective manner.
What is the need of DBMS? - Correct Answer ✅ Store Data
in an optimized and systematic manner
and
Retrieve Data Fast
What are some Examples Applications where we use
Database Management Systems are: - Correct Answer ✅
Telecom
,DBMS - Database Management System
Exam Questions and Answers (Latest
Update 2024)
Industry
Banking
Education sector
Online shopping
Advantages of DBMS over a FILE System - Correct Answer
✅ no redundant data
Data consistency and Integrity
Secure
Privacy
Easy access to data
Easy recovery
Flexible
Disadvantages of DBMS over FILE System - Correct Answer
✅ Higher implementation Cost
Complexity
Performance for some applications
,DBMS - Database Management System
Exam Questions and Answers (Latest
Update 2024)
What must you have to understand the view of data? -
Correct Answer ✅ Data Abstraction
Instance and Schema
What is data abstraction? - Correct Answer ✅ The process
of hiding irrelevant details from user
What are the 3 levels of Data abstraction? - Correct Answer
✅ Physical
Logical
View
Physical abstraction level - Correct Answer ✅ This is the
lowest level of data abstraction. It describes how data is
actually stored in database. You can get the complex data
structure details at this level.
records can be described as blocks of storage (bytes,
gigabytes, terabytes etc.) in memory.
, DBMS - Database Management System
Exam Questions and Answers (Latest
Update 2024)
Logical abstraction level - Correct Answer ✅ - Middle level
- Describes what data is stored in database
- Developers and admins access this level.
- records can be described as fields and attributes along with
their data types, their relationship among each other can be
logically implemented.
View abstraction level - Correct Answer ✅ - Highest level of
data abstraction.
- Describes the user interaction with database system.
user just interact with system with the help of GUI and enter
the details at the screen, they are not aware of how the data
is stored and what data is stored; such details are hidden
from them.
Database Instance - Correct Answer ✅ The data stored in
database at a particular moment of time
Exam Questions and Answers (Latest
Update 2024)
Database - Correct Answer ✅ Collection of Data
Management System - Correct Answer ✅ a set of programs
to store and retrieve data.
DBMS - Correct Answer ✅ (Database Management System)
A collection of inter-related data that contains programs to
store & access that data in an easy and effective manner.
What is the need of DBMS? - Correct Answer ✅ Store Data
in an optimized and systematic manner
and
Retrieve Data Fast
What are some Examples Applications where we use
Database Management Systems are: - Correct Answer ✅
Telecom
,DBMS - Database Management System
Exam Questions and Answers (Latest
Update 2024)
Industry
Banking
Education sector
Online shopping
Advantages of DBMS over a FILE System - Correct Answer
✅ no redundant data
Data consistency and Integrity
Secure
Privacy
Easy access to data
Easy recovery
Flexible
Disadvantages of DBMS over FILE System - Correct Answer
✅ Higher implementation Cost
Complexity
Performance for some applications
,DBMS - Database Management System
Exam Questions and Answers (Latest
Update 2024)
What must you have to understand the view of data? -
Correct Answer ✅ Data Abstraction
Instance and Schema
What is data abstraction? - Correct Answer ✅ The process
of hiding irrelevant details from user
What are the 3 levels of Data abstraction? - Correct Answer
✅ Physical
Logical
View
Physical abstraction level - Correct Answer ✅ This is the
lowest level of data abstraction. It describes how data is
actually stored in database. You can get the complex data
structure details at this level.
records can be described as blocks of storage (bytes,
gigabytes, terabytes etc.) in memory.
, DBMS - Database Management System
Exam Questions and Answers (Latest
Update 2024)
Logical abstraction level - Correct Answer ✅ - Middle level
- Describes what data is stored in database
- Developers and admins access this level.
- records can be described as fields and attributes along with
their data types, their relationship among each other can be
logically implemented.
View abstraction level - Correct Answer ✅ - Highest level of
data abstraction.
- Describes the user interaction with database system.
user just interact with system with the help of GUI and enter
the details at the screen, they are not aware of how the data
is stored and what data is stored; such details are hidden
from them.
Database Instance - Correct Answer ✅ The data stored in
database at a particular moment of time
