Exam 11: Databases

Telephone numbers and ZIP codes are examples of data that should be stored in a field with the numeric data type.

Poorly designed custom software can result in data independence .

In SQL terminology, creating a relationship between tables is referred to as ____ tables.

XML is a markup language that allows field tags, data, and tables to be incorporated into a Web document.

Data ____ means that data is stored separately from the programs that are used to manipulate the data.

Case 4 The SQL query language provides a collection of special command words called SQL keywords. With these keywords, SQL can be used to specify the action that should be carried out in the database. To change the contents of a record in a database, you use the ____ command.

The SQL query language provides a collection of special command words called SQL ____________________, such as SELECT, FROM, INSERT, and WHERE.

Case Based Critical Thinking Questions Case 1 Janet is working in a music store called WebMusic that sells CDs. Most of the CDs in the store are listed in the database. Most of the customers are also listed. As the database designer, she has defined fields for the database. In the WebMusic database, all the records of the previous and current CD orders are listed for each customer. The basic information such as name, address, phone, and e-mail are listed for each customer. The relationship of the customer and the different CD orders is a ____ relationship.

The data accessed by data mining and other analysis techniques is often stored in a data ____.

All of the following are examples of database server software EXCEPT ____.

A(n) index simply points to the record where the data can be found.

Criminals have become sophisticated in the use of all of the following EXCEPT ____ to access data stored on personal computers.

What is an object database?

SQL can be used to create all of the following EXCEPT ____.

____ is a query language.

Case Based Critical Thinking Questions Case 1 Janet is working in a music store called WebMusic that sells CDs. Most of the CDs in the store are listed in the database. Most of the customers are also listed. As the database designer, she has defined fields for the database. The kind of record the customer information is listed under is referred to as a ____.

Database ____ software is designed to manage billions of records and several hundred transactions per second.