Question 1 of 25
Hints left: 3
Q1
Information repositories are replacing data dictionaries in many organizations.
Q2
A disaster recovery plan does not need to include the shipment of database backups to other sites.
Q3
The fact that the same operation may apply to two or more classes is called what?
Q4
A transaction log shows before and after images of records that have been modified by transactions.
Q5
Which of the following is the preferred way to recover a database after a system failure?
Q6
The term Complete for a UML has the same meaning as which of the following for an EER diagram?
Q7
Data modeling and database design are key responsibilities of data and data base administration.
Q8
Failure to control confidentiality may lead to loss of competitiveness.
Q9
The greatest threat to business security is often internal rather than external.
Q10
With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.
Q11
Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.
Q12
A UML diagram includes which of the following?
Q13
Authorization tables contain highly sensitive data and should be protected by stringent security rules.
Q14
Composition is a stronger form of which of the following?
Q15
Databases are not the property of a single function or individual within the organization.
Q16
To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.
Q17
Multiplicity is the same as what concept for an ERD?
Q18
Mirrored databases are almost always provided in high-availability systems.
Q19
Incorrect data is easy to detect.
Q20
Concurrency control is important for which of the following reasons?
Q21
The restore/rerun technique involves reprocessing the day's transactions up to the point of failure.
Q22
Queries that do full table scans should be avoided.
Q23
The object-oriented development life cycle is which of the following?
Q24
A data warehouse administrator is concerned with which of the following?
Q25
An abstract class is which of the following?