Chapter 1 Quiz - DATABASE MANAGEMENT AND DESIGN
The primary purpose of a Data Warehouse is simply to store, or archive, massive amounts of data. TRUE FALSE
FALSE
Which type of architecture will require the most amount of network bandwidth to process queries? • Client server architecture • Desktop architecture • Mainframe architecture • File server architecture
File server architecture
A massively large database that contains current facts about all kinds of world activities is called ______________
Freebase
Which of the following systems is best described as an MIS system? • Shipping system • Point of Sale System • Google Analytics • Quickbooks Accounting system
Google Analytics
The kind of database that is used for day-to-day business operations is called a(n) ___________ database. (use full words in answer.)
Online Transaction Processing
The ___________ is the industry standard language used to manipulate data in a relational database. (use full words, not acronyms)
Structured Query Language
The DBMS sits between the application software and the database. TRUE FALSE
TRUE
Which is NOT one of the responsibilities of a DBMS? • Display query results • Define the data • Execute stored procedures • Execute queries
Display query results
A Data Mart is a place that companies can use to purchase external data. TRUE FALSE
FALSE
In the database approach to information systems, for small systems sometimes the application can read the data directly without the DBMS. TRUE FALSE
FALSE
Knowledge about databases and how they function is only required for technical careers. TRUE FALSE
FALSE
Only very large and complex databases are required to have a schema. TRUE FALSE
FALSE
The attributes and relationships associated with a particular entity will be somewhat similar across databases. TRUE FALSE
FALSE
The most common career for technicians with database skills is Database Administrator. TRUE FALSE
FALSE
A system that is used to support the daily activities of a business is called a _____________
Transaction Processing System
Bookmark question for later If the entities are defined as rows in the database, the individual pieces of information about each entity are called ______________
attributes
What are two of the most important pieces of information stored in a database about an entity? • Field sizes and values • Identifiers and Attributes • Attributes and Relationships • Identifiers and Relationships
• Attributes and Relationships
The primary contributor to the availability of all kinds of information is what? • Internet availability • Database technology • Wikipedia • Online libraries
• Database technology
The DBMS itself resides on local computers in which of the following architecture? • Web architecture • File server architecture • Client/Server architecture • Mainframe architecture
• File server architecture
In addition to design issues of very large public databases, another important issue in their development and deployment is __________ • What capabilities are required by the servers to host the database • How to populate the database with large amounts of data • How to keep the database up and running 24/7 • How to ensure the security and safety of the large databases
• How to populate the database with large amounts of data
The three major characteristics of today's society that are impacted by databases include • Internet availability, Widespread smart phone use, and banking availability • Accessible transportation, accessible communication, and worldwide shipping • Pervasive connectivity, universal mobility, and abundant information • Markets accessibility, Private information availability, and Targeted advertising
• Pervasive connectivity, universal mobility, and abundant information
Which of the following systems is best described as a TPS system? • Google Analytics • Point of Sale System • Sales and Market Analysis system • Stock market price tracking system
• Point of Sale System
Information can be defined as facts that ____________
Can be labeled and belong to a context.
An analysis technique to extract and analyze information from massive databases is called _____________.
Data Mining
The structure and organization of a database is defined by its ___________
Schema
