Exam 11: Databases

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. -A customer would like a list of all of the CDs from their favorite group that are priced at $10.00 or less at WebMusic.Which of the following categories of operators would be used in order to perform the proper type of query for the customer?

A ____ contains the outline or general specifications for a report,including such elements as the report title,fields to include,fields to subtotal/total,and report format specifications.

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

A field ____ rule is a specification that the database designer sets up to filter the data entered into a particular field.

A(n)____________________ is a procedure that monitors and records user activity within a database.

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

-In the query illustrated in the accompanying figure,the SELECT command specifies the fields that should appear._________________________

What would be an appropriate data type to choose for a fixed-length field designed to hold a person's name?

A field ____ is a template that adds the correct formatting as data is entered.

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

Which of the following SQL operators can be used to omit records from a search by specifying a not-equal relationship?

Database data that is transmitted over the Web can be encrypted using encryption technologies such as ____.

Which of the following is NOT a guideline for creating a template for reports?

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 make sure that a field contains all unique values,Kate wants to set up the database so that it will search every existing record for duplicates.What will accomplish this goal for Kate?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Type of field that does not require disk storage space

The logical data type is used for true/false or yes/no data.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Procedure that monitors and records user activity within a database

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Type of rule used to filter the data entered into a particular field

One of the most common database operations is to query for a particular record or group of records using the ____ command.

Database tables should be indexed by any field or fields that are commonly used as search fields.