Exam 11: Databases

-In the relationship in the ____ row of the accompanying figure,one record in a particular record type can be related to many records in another record type,and vice versa.

The average American is in less than 10 commercial databases.

The ____ data type would be the right choice for a field designed to hold an MP3 file.

XML documents are not optimized for many operations you would customarily associate with databases,such as fast sorts,searches,and updates.

A lookup ____________________ validates an entry by searching for the same data in a file or database table.

A(n)____________________ is a database management system that is optimized for handling data that exists in XML format.

An index has no bearing on the physical sequence of records on disk.

A relational database stores data in a collection of related tables.

When no ____________________ order is specified,new records are appended to the end of the database file.

Queries within an unsorted database are slow because each record must be looked at sequentially.

Dynamic Web publishing allows you to take a snapshot of the data in a database by generating a report,which is converted into an HTML document._________________________

The ____ Web publishing process generates customized Web pages as needed.

Databases are vulnerable to ____.

-The two tables shown in the accompanying figure are ____ by the CustomerNumber field.

In a fixed-length field,when the data entered is shorter than the allocated field length,blank spaces automatically fill the field.

A record contains the smallest unit of meaningful information.

-In the accompanying figure,the relationship shown in the top row is a one-to-many relationship.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of data fields

Janet has been hired to design a database for a music store called WebMusic. The store sells CDs, which are to be included in the database. Janet plans to include many of the customers that visit the store in the database as well. She has designed fields for the database. -In the WebMusic database,all previous and current CD orders will be included for each customer.Basic customer information,such as name,address,phone,and e-mail,will also be included for each customer.The relationship between the customer and his/her CD orders will likely be which of the following?

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