Exam 11: Databases

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Specifies the way data is represented on the disk and in RAM

In an SQL query,a ____ clause is used to specify the table you want to access.

Sorted tables typically produce slower queries and updates than unsorted tables.

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

Dynamic Web publishing relies on a program or script,referred to as a(n)____ program,that acts as an intermediary between your browser and a DBMS.

In some business environments, the database designer also enters the data into the database. In Kate's large banking firm, however, the actual database entries are not made by the database designers. After perusing the database, Kate has discovered that one data entry operator might enter a telephone number as 555-555-7777, another as (555) 555-7777, and a third as 1-555-555-7777. When multiple data entry operators enter telephone numbers in different formats, it becomes difficult to produce nicely formatted reports or to locate a particular telephone number. -To prevent inconsistent formatting,Kate needs to ask the database designer to make the database automatically reject any entry that was typed in the wrong format.What should Kate request be applied to the telephone number field to solve this problem?

A(n)_____________________________________________ is software optimized for the object database model.

____ are detailed specifications for an SQL command.

In some business environments, the database designer also enters the data into the database. In Kate's large banking firm, however, the actual database entries are not made by the database designers. After perusing the database, Kate has discovered that one data entry operator might enter a telephone number as 555-555-7777, another as (555) 555-7777, and a third as 1-555-555-7777. When multiple data entry operators enter telephone numbers in different formats, it becomes difficult to produce nicely formatted reports or to locate a particular telephone number. -Kate would also like to request that the database developer ensure that the data entry operators cannot enter a dollar amount of less than $0.00 in any currency fields.What should she ask be applied to those fields?

A record ____ contains data about a particular entity.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The smallest unit of meaningful information in a database

A(n)____________________ limits access to systems such as computer databases.

____ can block unauthorized users and limit activities of authorized users.

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. -The intern needs to complete the following query so that it draws data from two different tables.Which command should she use to complete the query? SELECT FROM CompactDiscs ____ Tracks ON CompactDiscs.ItemNumber = Tracks.ItemNumber

Describe the seven principles that contribute to good user interface design.

Data ____ means that data are separate from the programs used to manipulate the data.

In the world of databases,a(n)____ refers to a collection of data fields.

Which of the following can be used to delineate the data entry area in a user interface?

If a single data management tool can be used to maintain many different files and databases,it must support data ____.

A fixed-length field contains a predetermined number of ____.