1. In a distributed database management system (DDBMS), database fragment E1 is located at Site 1, database fragment E2 is located at site 2, and database fragment E3 is located at site 3. Which statement would most accurately explain the operations of data access in this type of environment?
Minimum storage is used at each site.
2. How would you change a network with a single-site processing, single-site data (SPSD) environment into a multiple-site processing, single-site data (MPSD) environment if there is only a single database repository?
Add at least one more transaction processor
3. A DDBMS is subject to which restriction?
Remote data access is provided on a read-only basis.
4. Why would a website that deals with world-wide ticket sales favor a NoSQL DDBMS type of system when transaction consistency is most desirable in large DDBMS models?
It uses a BASE transaction model.
5. If a company’s database engineers have been so used to using a centralized database management system (DBMS) with set scripts and commands to operate databases locally, what disadvantage of a distributed DBMS could negatively impact the company for a short period?
Complexity of management and control
6. A department user has a single SQL statement to process and does not have much time to wait for the data. The data only exists in one location. For the best possible performance, the user’s task should be treated as which of the following?
Remote request
7. _____ transparency allows data to be updated simultaneously at several network sites.
Transaction
8. A database with multiple copies of each database fragment at multiple sites is considered to be a ____.
fully replicated database
9. An administrator has been tasked to accommodate the different work locations of two departments by configuring the distributed database management system (DDBMS) in a way so that each department has quick and easy access to specific information of the CUSTOMER table as needed. How should the database be structured?
Use vertical fragmentation
10. When comparing a distributed request to a remote transaction, a distributed request would cause multiple data processors to work together because of which of the following transaction characteristics?
A single SELECT statement references two tables: each at two different sites.
11. Identify among the following, which system of data warehousing is mostly used.
reporting and data analysis
12. When using Operational data, they are commonly stored in many tables, and the stored data represents information about what?
a given transaction only
13. If we wanted to use a data warehouse subject that helps provide decision support to a small group, what would we use?
data marts
14. What type of science does data visualization have its roots in?
cognitive
15. With SQL, how can you return all the records from a table named “College” sorted descending by “CollegeName”?
SELECT * FROM Colleges ORDER BY CollegeName DESC
16. While using a MDBMS, how would you store the end user visualization?
data cube
17. If Postcard company needs a framework that is more comprehensive and integrated decision support what would their company choose?
Business Intelligence
18. You need a clause that can help you dictate when to update the materialized view. What clause can you use to do this?
REFRESH
19. At work you are asked to use a star schema that will help with searching a certain product for your boss. What attribute are using?
facts
20. The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.
dimensions