A database management system is used to organise who can access a database and how they can make changes. They are important for managing the security and the integrity of data.
Which of the following is a tool to store, edit and organise data in a database?
A database management system (DBMS)
In terms of databases, what does consistency mean?
All data inputted follows the same format
All users have the same view of data
The data is the same no matter who views it
In terms of databases, what is meant by security?
Only the most important data is kept in a secure place
Different access rights cannot be assigned to different users
All data is kept in a secure place and different access rights can be assigned to different users
Which of the following is true?
A DBMS separates applications from data
A DBMS integrates applications and data
SQL integrates applications and data
Which database view is used by users who input and view data?
Which view is used for the detailed programming of a database?
Which of the following are valid levels of access?
Read and change
Read only, edit, delete and append
Administrator and change
In terms of databases, what is meant by concurrency?
Many users can interact with the database simultaneously
More than one user cannot edit data at the same time
Only a single user can interact with the database at a time
What term is given to a change made in a database?
In terms of databases, what is meant by isolation?
Users cannot share data
Transactions must not interfere with other transactions
Changes must not break the database