Dan is told by his manager that the organization needs reliable, consolidated,unique and integrated analysis and reporting of its data, at different levels of aggregation. Which of the following best describes what Dan needs to implement?

Databases can record transactions in real time, which usually updates more thanone database in a distributed environment. This type of complexity can introduce many integrity threats, so the database software should implement the characteristics of what’s known as the ACID test. Which of the following are incorrect characteristics of the ACID test?

i. Atomicity – Divides transactions into units of work and ensures that all modifications take effect or none takes effect.
ii. Consistency – A transaction must follow the integrity policy developed for that particular database and ensure all data are consistent in the different databases.
iii. Isolation – Transactions execute in isolation until completed, without interacting with other transactions.
iv. Durability – Once the transaction is verified as inaccurate on all systems, it is committed, and the databases cannot be rolled back.

Katie goes to the bank and withdraws $6,500 from her $10,000 checking account.Database A receives the request and records a new checking account balance of $3,500, but database B does not get updated. It still shows a balance of $10,000.Then, Katie makes a request to check the balance on her checking account, but that request gets sent to database B, which returns in accurate information because the withdrawal transaction was never carried over to this database. Which of the following best describes what should be enabled to make sure that this type of situation does not take place?

When building her database, Diane wants to make sure that if users at a lower clearance level attempt to interact with an object at a higher classification level that he will not be told that the object is off limits because of clearance and classification issues. Which of the following best describes what Diane should implement?

If a database administrator wants to allow middle management members to see their departments’ profits and expenses but not show them the whole company’s profits,what can she implement?

To ensure that aggregation and inference attacks do not take place, which of the following should Linda not implement?

Linda has found out that two people who work for her who do not have the clearance level to know about certain military troop movement have learned about the activity and sold the information to enemy states. Which of the following best describes what type of issue is Linda dealing with?

In some cases, two transactions may, in the course of their processing, attempt to access the same portion of a database at the same time, in a way that prevents them from proceeding. Which of the following best describes this type of situation?

Which of the following best describes what transaction-processing system provides?

Which of the following best describes an operation that allows changes to adatabase to be available to all applications and users?