Intro To Dbms Flashcards
What are the two main parts of a Database System?
Database Management Systems and Database Applications
What is a Database Management System (DBMS)?
A collection of interrelated data and a set of programs to access this data
What is the primary goal of a DBMS?
To provide a convenient environment to retrieve and store database information
What does a DBMS support regarding user access?
Single user and multi-user environments
True or False: A DBMS allows multiple users to access the database simultaneously.
False
What role does a DBMS play between application programs and the operating system?
Acts as an interface to access and manipulate the database
What is the difference between a Database Management System and a Database Application?
DBMS organizes and maintains information; Database Application allows viewing, retrieving, and updating information
What must a DBMS do to protect databases?
Protect databases from mal-intentioned changes by users and applications
What is a key capability of a multi-user DBMS?
Informing other users of any database changes
What types of tasks can a database handle?
- Accounting
- Purchasing
- Research papers
- Inventory management
- Managing books
- Managing related information
What does a DBMS ensure regarding user access to data?
Users have adequate and swift access to the data
Fill in the blank: A database is designed and populated with data for a _______.
[particular purpose]
What are some common services provided by a DBMS?
- Creating a file
- Adding/editing/deleting data
- Retrieving data
- Managing data integrity
- Managing database users
How can data stored in a DBMS be organized?
Data can be sorted and indexed at users’ discretion
What are the two main parts of a Database System?
Database Management Systems and Database Applications
What is a Database Management System (DBMS)?
A collection of interrelated data and a set of programs to access this data
What is the primary goal of a DBMS?
To provide a convenient environment to retrieve and store database information
What does a DBMS support regarding user access?
Single user and multi-user environments
True or False: A DBMS allows multiple users to access the database simultaneously.
False
What role does a DBMS play between application programs and the operating system?
Acts as an interface to access and manipulate the database
What is the difference between a Database Management System and a Database Application?
DBMS organizes and maintains information; Database Application allows viewing, retrieving, and updating information
What must a DBMS do to protect databases?
Protect databases from mal-intentioned changes by users and applications
What is a key capability of a multi-user DBMS?
Informing other users of any database changes
What types of tasks can a database handle?
- Accounting
- Purchasing
- Research papers
- Inventory management
- Managing books
- Managing related information
What does a DBMS ensure regarding user access to data?
Users have adequate and swift access to the data
Fill in the blank: A database is designed and populated with data for a _______.
[particular purpose]
What are some common services provided by a DBMS?
- Creating a file
- Adding/editing/deleting data
- Retrieving data
- Managing data integrity
- Managing database users
How can data stored in a DBMS be organized?
Data can be sorted and indexed at users’ discretion
