A shared lock allows which of the following types of transactions to occur? Update Insert Read Delete TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following could cause data to be unavailable? All of these Planned database maintenance activities Data becoming lost or inaccurate The database server TRUE ANSWER : ? YOUR ANSWER : ?
Locking may cause which of the following problems? Versioning Erroneous updates All of these Deadlock TRUE ANSWER : ? YOUR ANSWER : ?
The transaction log includes which of the following? The essential data of the record The before-image of a record The before and after-image of a record The after-image of a record TRUE ANSWER : ? YOUR ANSWER : ?
Data modeling and database design are key responsibilities of data and data base administration. True False TRUE ANSWER : ? YOUR ANSWER : ?
Concurrency control is important for which of the following reasons? To ensure data integrity while reading data occurs to the database in a single-user environment To ensure data integrity when updates occur to the database in a multiuser environment To ensure data integrity while reading data occurs to the database in a multiuser environment To ensure data integrity when updates occur to the database in a single-user environment TRUE ANSWER : ? YOUR ANSWER : ?
Performance analysis and tuning is which of the following? Undertaken as an ongoing part of the backup of a database Undertaken one time at the time of the implementation of a new application Undertaken as an ongoing part of managing a database Undertaken one time at the time of a DBMS installation TRUE ANSWER : ? YOUR ANSWER : ?
Poor data administration can lead to which of the following? Missing data elements All of these A single definition of the same data entity Familiarity with existing data TRUE ANSWER : ? YOUR ANSWER : ?
Databases are not the property of a single function or individual within the organization. True False TRUE ANSWER : ? YOUR ANSWER : ?