Which of the following could cause data to be unavailable? All of these Data becoming lost or inaccurate Planned database maintenance activities The database server TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is true concerning open-source DBMS? Is free or nearly free database software whose source code is not publicly available Is not competitive against PC-oriented packages and is fully SQL compliant Is competitive against PC-oriented packages and is not fully SQL compliant Is free or nearly free database software whose source code is publicly available TRUE ANSWER : ? YOUR ANSWER : ?
Failure to control confidentiality may lead to loss of competitiveness. True False TRUE ANSWER : ? YOUR ANSWER : ?
Information repositories are replacing data dictionaries in many organizations. False True TRUE ANSWER : ? YOUR ANSWER : ?
Poor data administration can lead to which of the following? Familiarity with existing data All of these Missing data elements A single definition of the same data entity TRUE ANSWER : ? YOUR ANSWER : ?
Locking may cause which of the following problems? All of these Deadlock Versioning Erroneous updates TRUE ANSWER : ? YOUR ANSWER : ?
Backward recovery is which of the following? Where the after-images and before-images are applied to the database Where the before-images are applied to the database Where the after-images are applied to the database Switching to an existing copy of the database TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is the preferred way to recover a database after a system failure? Reprocess transactions Rollback Rollforward Switch to duplicate database TRUE ANSWER : ? YOUR ANSWER : ?
To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository. False True TRUE ANSWER : ? YOUR ANSWER : ?
Mirrored databases are almost always provided in high-availability systems. True False TRUE ANSWER : ? YOUR ANSWER : ?