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