Ch 1 Quiz - Database Management and Design
A Data Mart is a place that companies can use to purchase external data.
False
In the database approach to information systems, for small systems sometimes the application can read the data directly without the DBMS.
False
Knowledge about databases and how they function is only required for technical careers.
False
Only very large and complex databases are required to have a schema.
False
The attributes and relationships associated with a particular entity will be somewhat similar across databases.
False
The most common career for technicians with database skills is Database Administrator.
False
The primary purpose of a Data Warehouse is simply to store, or archive, massive amounts of data.
False
The DBMS itself resides on local computers in which of the following architecture?
File server architecture
Which type of architecture will require the most amount of network bandwidth to process queries?
File server architecture
Which of the following systems is best described as an MIS 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 three major characteristics of today's society that are impacted by databases include
Pervasive connectivity, universal mobility, and abundant information
Which of the following systems is best described as a TPS system?
Point of Sale System
The ______________ is the industry standard language used to manipulate data in a relational database. (use full words, not acronyms)
Structured Query Language
Which is NOT one of the responsibilities of a DBMS?
Display query results
A system that is used to support the daily activities of a business is called a _________.
Transaction Processing System
The DBMS sits between the application software and the database.
True
If the entities are defined as rows in the database, the individual pieces of information about each entity are called _________.
attributes
A massively large database that contains current facts about all kinds of world activities is called _________
freebase
The structure and organization of a database is defined by its ___________
schema
The primary contributor to the availability of all kinds of information is what?
Database technology
What are two of the most important pieces of information stored in a database about an entity?
Attributes and Relationships
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
In addition to design issues of very large public databases, another important issue in their development and deployment is
How to populate the database with large amounts of data
