WorksheetsLessons review questions - Data Management Systems
Total questions: 20
Worksheet time: 12mins
Under the GPP Back-up approach, only one grandparent back-up file is maintained.
True
False
Which of the following are traditional problems encountered with the flat-file approach (check those that apply)
Data currency
Data updating
Task-data dependency
Data storage
Flat files are usually owned by its user and can be shared with others
True
False
The portion of the entire database the is visible to the users.
Conceptual view
Internal view
Physical view
User view
The programming language used to enable queries in a database
Standard query language
Data query language
Data manipulation language
Data definition language
A database environment eliminates the data redundancy that is present in a flat-file environment.
True
False
A primary person in the organization that is responsible in managing database access rights.
(a)
The manner at which records are physically arranged in a storage device, which can either be sequential or random.
(a)
Which of the following database models presents data in a tree format?
Hierarchical model
Network model
Relational model
Which of the following are risk related to data management systems under the flat-file approach(check those that apply).
Unauthorized access
Data loss
Malicious programs
Hacking attacks
User authentication method that measure various personal characteristics, such as fingerprints, voice prints, retina prints, or signature characteristics.
Biometrics device
User views
User-defined procedures
Inference controls
User defined procedures include, in addition to password, the personal characteristics of a person (such as fingerprint) which is possessed only by the user.
False
True
When auditing database access control, auditor needs to confirm is all database users are required to provide log-in credentials such as username and passwords before access is granted.
True
False
Which of the following database controls will name data unreadable to intruders?
Biometrics device
Inference controls
User view
Data encryption
Database access is violated by (check those that apply)
Intruders
Users with excessive access privilege
Database administrator
IT personnel
Direct access file backup is also known as destructive replacement.
True
False
Which of the following describes the entire database in a logical and abstract form.
Internal view
Conceptual view
Query view
User view
In a flat-file approach, decision makers may create decisions based on obsolete information if updates were not properly disseminated.
True
False
A database environment removes all constraints with respect to information needs to users.
True
False
A database environment significantly reducing the resources spent on data maintenance.
True
False
