Exam 11: Databases

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

-The accompanying figure shows an example of an SQL query.

From a user perspective,the data ____________________ determines the way that data can be manipulated.

The simplest model for storing data is the flat file.

A field ____________________ helps maintain consistent data by providing a structure for entering data into a field.

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

Which of the following does NOT have the potential to add doubt about the veracity of database data?

A ____ data type usually provides a variable-length field into which users can enter comments.

A(n)____________________ refers to a collection of data fields about one entity--a person,place,thing,or event.

WebMusic's database designer, Janet, has hired an intern. She has requested that this intern create some SQL queries that would be useful to managers tracking the day-to-day operations of the store. -Janet wants her intern to make some changes to the contents of records in the store's database.Which of the following commands would the intern use?