The simplest model for storing data is the flat file. T or F?
In a fixed-length field, when the data entered is shorter than the allocated field length, blank spaces automatically fill the field. T or F?
A record contains the smallest unit of meaningful information. T or F?
In the accompanying figure, the relationship shown in the bottom row is a many-to-many relationship. T or F?
In the accompanying figure, the relationship shown in the top row is a one-to-many relationship. T or F?
A relational database stores data in a collection of related tables. T or F?
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. T or F?
If a name field contains an entire name, it is difficult to individually manipulate the first name, last name, and middle initial. T or F?
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. (T/F)
Sorted tables typically produce slower queries and updates than unsorted tables
Queries within an unsorted database are slow because each record must be looked at sequentially. T or F?
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 accompanying figure shows an example of an SQL query.
The average American is in less than 10 commercial databases. (T/F)
An encrypted database can be queried quickly. (T/F)
Under privleges delineate which fields and records a particular user is allowed to access
The United States has some of the strongest privacy regulations in the developed world. (T/F)
In the broadest definition, a(n) ____ is a collection of information.
Data ____ refers to the process of analyzing information in databases to discover previously unknown and potentially useful information.
____ refers to a branch of data mining that focuses on predicting future probabilities and trends.
A(n) ___ file uses a uniform format to store data for each person or thing in the file.
In the world of databases, a(n) ____ refers to a collection of data fields.
____ refers to the number of associations that can exist between two record types.
A(n) ____ is an association between data that is stored in different record types.
In an object database, an attribute is ______.
Equivalent to a field in a relational database
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.
if a single data management tool can be used to maintain many different files and databases, it must support data ______.
A(n) ____ allows you to create, update, and administer a relational database.
Database ___ software allows remote computer or network workstation to access data in a database.
Database ____ software is designed to manage billions of records and several hundred transactions per second.
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.
A CGI script can be written in all of the following EXCEPT
The accompanying figure shows a(n) ____ document.
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.
What would be an appropriate data type to choose for a field designed to hold an MP3 file?
BLOB data type
A ____ validates an entry by searching for the same data in a file or database table.
The two tables shown in the accompanying figure are ____ by the CustomerNumber field.
A table's ____ order is the order in which records are stored on disk.
To provide a quality database interface, a designer might ____.
arrange fields in a logical order
Which of the following can be used to delineate the data entry area in a user interface?
all of the above
A(n) ____ copies data out of a software package, such as spreadsheet software, and into a database.
____ is a query language.
Database ____ provides users with an easy-to-use interface for entering search specifications, new records, data updates, and so on.
what SQL command removes a record from a table
____ are detailed specifications for an SQL command.
One of the most common database operations is to query for a particular record using the ___ command
Which of the following is NOT a Boolean operator?
Which of the following SQL operators designates records that meet either one of a set of two criteria or both?
Which of the following SQL operators 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.
In the SQL query in the accompanying figure, how many tables will be accessed?
Databases are NOT vulnerable to ____.
Which of the following does NOT have the potential to add doubt about the veracity of database data?
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 database audit can ____.
all of the above
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?
Margaret is considering purchasing a custom software package. Which of the following will be true?
The cost of development is generally high, but the result will be versatile.
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?
SELECT FROM CompactDiscs ____ Tracks ON CompactDiscs.ItemNumber = Tracks.ItemNumber
Want to see the other 70 Flashcards in Chapter 11?JOIN TODAY FOR FREE!