ch03 c

Topics: Data management, Data warehouse, Business intelligence Pages: 11 (1817 words) Published: June 18, 2015
True/False

1. Document management technology archives digital and physical data to meet business needs, as well as regulatory and legal requirements.

2. In terms of IS dependability, fault tolerant data management technologies means zero-downtime, zero data loss, and continuous access to data, analytics, and reporting.

3. Operational intelligence refers to the credentials, technological skills, decision making abilities and industry experience of key leaders in an organization.

4. Traditional databases are not well suited for managing messy data such as customer comments and tweets.

5. An ad-hoc request for specific data or information from a database or warehouse is called a report.

6. An ad-hoc request for specific data or information from a database or warehouse is called a query.

7. Many database management systems use the Structured Query Language (SQL) for programming queries.

8. Many database management systems use the Syntax Query Language (SQL) for programming queries.

9. Databases are optimized for extremely fast processing of queries -or ad hoc user requests for specific data.

10. Data generated by business apps, sensors, and transaction processing systems (TPS) are typically stored first in a database.

11. Data warehouses integrate data from multiple databases and data silos and organize them for complex analysis, knowledge discovery, and to support decision making.

12. Data marts are small-scale data warehouses that support a single function or department.

13. Mini-data warehouses are small-scale data warehouses that support a single function or department.

14. Business intelligence (BI) tools and techniques process data and do statistical analysis for insight and discovery—that is, to discover meaningful relationships in the data, keep informed of real time, gain insight, detect trends, and identify opportunities and risks.

15. Database management systems (DBMS) are computer programs used to manage additions, updates, and deletions of data in a database as transactions occur; and support data queries and reporting.

16. Data warehouse management systems (DWMS) are computer programs used to manage additions, updates, and deletions of data in a database as transactions occur; and support data queries and reporting.

17. Online transaction processing (OLTP) systems designed to manage volatile transaction data.

18. Online analytical processing (OLAP) systems designed to manage volatile transaction data.

19. The two basic types of database systems are centralized databases and distributed databases.

20. The two basic types of database systems are static databases and dynamic databases.

21. A centralized database stores all related files in one physical location.

22. The primary benefits of centralized database configuration are better quality and better security.

23. The primary benefits of centralized database configuration are better reporting features and better statistical analysis tools.

24. The primary disadvantage of centralized database configurations is transmission delay when users are geo-dispersed.

25. The primary disadvantage of distributed database configurations is transmission delay when users are geo-dispersed.

26. A distributed database allows apps on computers and mobiles to access data from local and remote databases.

27. Distributed databases use a client/server architecture to process information requests.

28. Distributed databases use a Select Query (SQ) architecture to process information requests.

29. In a distributed database configuration, the computers and mobile devices that access data from remote servers are called clients.

30. In terms of the major functions performed by a DBMS, “data filtering and...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Operators in C
  • C Program Essay
  • C++ Learning Essay
  • Essay on Operator Overloading in C++
  • OOPs Using C++ Question Bank Essay
  • History of C++ Essay
  • Billing Management System C++ Essay
  • Essay on How to Use Dev C

Become a StudyMode Member

Sign Up - It's Free