Computer 11

The simplest model for storing data is the flat file.

In a fixed-length, 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.

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

Modern database software is designed to support data dependence.

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

In a name field contains an entire name, it is difficult to individually manipulate the first name, last name, and middle initial.

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

The hyperlink data type is used to store data that can have one of two values.

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

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

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

The average American is in less than 10 commercial databases.

An encrypted database is more efficient than an unencrypted database.

User privileges delineate what activities a user can perform within a database.

The United States has some of the strongest privacy regulations in the developed world.

In a flat file, each row in the table is a field.

In database jargon, a relationship is an association between data that is stored in different record types.

In a relational database, relationships are specified by joining common data stored in the fields of records in different tables.

Poorly designed custom database software can result in data independence.

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.

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

In a case sensitive database, uppercase letters are not equivalent to their lowercase counterparts.

The index key for a table specifies the order in which records are stored and where new records are inserted in a table.

An inrsj455dex simply points to the record where the data can be found.

Thieves who gain access to an encrypted database cannot make sense of the data.

In the broadest definition, a(n) ____ is a collection of information.

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

____ refers to a branch of data mining that analyzes current and historical data to predict future trends.

____ allows decision makers to quickly get answers to complex queries that encompass multiple factors.

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

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

A record that contains data is referred to as a record ____.

____ refers to the number of associations that can exist between two record types.

Relationships between record types can be graphically depicted using a(n) ____.

A(n) ____ is an association between data that is stored in different record types.

In an object database, an attribute is ____.

It is possible to enter data as a(n) ____ text file and then use a programming language to write routines to access that data.

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

A(n) ____ allows you to create, update, and administer a relational database.

With a(n) ____ database, the database is stored on several different computers, on multiple networks, or in different geographical locations.

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

A technique called ____ Web publishing is a simple way to display the data in a database by converting a database report into an HTML document, which can be displayed as a Web page by a browser.

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

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.

All of the following are tools to help you create server-side programs EXCEPT ____.

The ____ data type is used to store true/false or yes/no data using minimal storage space.

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

The ____ data type would be appropriate for a fixed-length field designed to hold a person's name.

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

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

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

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

The goal of normalization is to minimize data ____.

A table's ____ order is the order in which records are stored on disk.

A database ____ contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key.

____ is a query language.

Database ____ provides users with an easy-to-use interface for entering search specifications, new records, data updates, and so on.

____ is the SQL command used to introduce a brand-new database or table.

____ is the SQL command used to remove a record from a table.

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

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

The ____ operator specifies that both of the search criteria must be true for the record to be selected.

The following SQL operator can be used to omit records from a search by specifying a not-equal relationship: ____.

A ____ update changes data in more than one record at a time.

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

Databases are vulnerable to ____.

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

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

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

Surveys show that as many as ____ of businesses never change the standard administrator password for a DBMS.

A ____ establishes which fields and records a particular user may access.

The list of field names that will be used to hold WebMusic's customer information will be defined as a template called a ____.

One of Margaret's first tasks is to create the company's electronic customer address book. Which software tool would be easy, require minimal setup, and likely have the needed fields predefined?

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?

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?

Each column of a relational database table is equivalent to a(n) ____________________.

The ____________________ data type is used to store dates in a format that allows them to be manipulated.

A(n) ____________________ key is a field that contains data unique to a record.

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

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

The accompanying figure shows an example of an SQL query.

In the query illustrated in the accompanying figure, the SELECT command is used to link the Albums and Tracks tables.

In the query illustrated in the accompanying figure, the JOIN command specifies that you want to see the album with item number LPM-2256.

You can query by ____ using a fill-in form, like the one shown in the accompanying figure.

The accompanying figure shows a(n) ____ document.

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

To provide a quality database interface, a designer might ____.

A(n) ____ can be used to delineate the data entry area in a user interface.

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.

The following is NOT a guideline for creating a template for reports: ____

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

The ____________________ data type stores URLs used to link directly from a database to a Web page.

In the SQL query in the accompanying figure, ____ tables will be accessed.