Data and Database Administration Which of the following is true concerning open-source DBMS? Is free or nearly free database software whose source code is publicly available Is not competitive against PC-oriented packages and is fully SQL compliant Is free or nearly free database software whose source code is not publicly available 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 Is not competitive against PC-oriented packages and is fully SQL compliant Is free or nearly free database software whose source code is not publicly available Is competitive against PC-oriented packages and is not fully SQL compliant ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Poor data administration can lead to which of the following? A single definition of the same data entity Missing data elements All of these Familiarity with existing data A single definition of the same data entity Missing data elements All of these Familiarity with existing data ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Incorrect data is easy to detect. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration A disaster recovery plan does not need to include the shipment of database backups to other sites. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data and Database Administration Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? Switch to duplicate database Reprocess transactions Rollback Rollforward Switch to duplicate database Reprocess transactions Rollback Rollforward ANSWER DOWNLOAD EXAMIANS APP