TIA Chapter 11 Exam

In a relational database, what is a relationship? A. A link between tables that defines how the data are related B. The primary key in the database C. The links among databases D. The array of tables in a database

A. A link between tables that defines how the data are related

_________ involves putting data into an electronic file in a format that another application can understand. A. Exporting B. Importing C. Batch processing D. Data mining

A. Exporting

Each record must have a unique field called a(n) ___ field. A. Primary key B. Identifier C. Validation D. Referential

A. Primary Key

_____ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table. A. Referential integrity B. Normalization C. Database consistency D. Record integrity

A. Referential integrity

________ databases have the largest market share among the primary types of electronic databases. A. Relational B. Flat-file C. Multidimensional D. Object Oriented

A. Relational

A(n) ___________ check determines whether all required fields were entered with appropriate data. A. completeness B. range C. consistency D. alphabetic

A. completeness

A ____ is a collection of related data that can be stored, sorted, organized, and queried. A. database B. list C. filter D. data mine

A. database

A ___ is automatically displayed in a field unless the user enters something different. A. default value B. relation C. field type D. numeric check

A. default value

In a database, a _______ is synonymous with a category of information A. field B. record C. row D. table

A. field

A Web address is stored as a(n) ________ field in a database. A. hyperlink B. text C. address D. memo

A. hyperlink

If a numeric field has a size of 5, which is the highest number it can hold? A. 5 B. 99999 C. 55555 D. 50,000

B. 99999

What does the acronym DBMS stand for? A. Database modeling system B. Database management system C. Data building and modeling system D. Data browsing and management system

B. Database management system

Which of the following is NOT a main operation of a database management system (DBMS)? A. Creating databases and entering data B. Implementing data mining C. Viewing and sorting data D. Outputting data

B. Implementing data mining

SQL uses ___ to extract records from a database by using English-like expression that have variables and operations. A. Boolean Algebra B. Relational Algebra C. Primary Keys D. Foreign Keys

B. Relational Algebra

Which of the following is NOT a likely primary key? A. Driver's license number B. Street address C. Student ID number D. Social Security Number

B. Street Address

Prior to entering data into a database, you must create a data ___ entry for each field in the database. A. type B. dictionary C. mine D. warehouse

B. dictionary

A _____ temporarily displays records that match the specified criteria. A. sieve B. filter C. validation rule D. field constraint

B. filter

Data ______ means that the data contained in a database is accurate and reliable. A. efficiency B. integrity C. redundancy D. consistency

B. integrity

When you want to extract data from two or more tables, you use a(n) _____ query. A. select B. join C. relational D. object

B. join

In a database, ______ fields store numbers used to perform calculations. A. date B. numeric C. computational D. alphanumeric

B. numeric

In a database, a chart is stored in a(n) ______ field. A. text B. object C. memo D. hyperlink

B. object

A ______ check allows you to set credits allowed for students during one quarter from 0 to 21. A. completeness B. range C. consistency D. numeric

B. range

If a business keeps two lists, one for employee payroll and one for employee benefits information, both containing name and address information, this is an example of data ________. A. integrity B. redundancy C. completeness D. normalization

B. redundancy

Microsoft ___ is a database management system. A. Visio B. Publisher C. Access D. Project

C. Access

Data in a multidimensional database is organized in a _______ format. A. Linear B. Table C. Cube D. Cellular

C. Cube

___ defines the maximum number of characters or digits that a particular field can hold. A. type B. max C. field D. text

C. Field

___ is the process of reducing data redundancy by recording data only once. A. Consistency checking B. Validation C. Normalization D. Range Checking

C. Normalization

Nontraditional data such as audio clips, video clips, pictures and very large documents are called ___ data. A. Enterprise B. Structured C. Unstructured D. Multidimensional

C. Unstructured

An individual trained in the design and building of databases is called a database ________. A. master B. technician C. administrator D. analyst

C. administrator

Unstructured data such as video clips and pictures are known as _____ because of the way they are encoded. A. hyperlink fields B. multidimensional data C. binary large objects (BLOBs) D. metadata

C. binary large objects (BLOBs)

A _____ check compares the values of data in two or more fields to see whether those values are reasonable. A. correctness B. range C. consistency D. numeric

C. consistency

A _____ relationship indicates that for each record in a table, there is only a single corresponding record in a related table. A. many-to-one B. one-to-many C. one-to-one D. many-to-many

C. one-to-one

In a database, a ________ is a group of related fields. A. file B. list C. record D. table

C. record

A _________ displays a subset of data from a table (or tables) based on the criteria specified. A. database query B. join query C. select query D. criteria query

C. select query

___ helps to ensure data integrity by maintaining information in only one place A. Data flexibility B. Data redundancy C. Data mapping D. Data centralization

D. Data centralization

Which of the following is NOT a typical disadvantage associated with databases? A. Databases can be expensive to set up. B. Databases are usually more complex to administer. C. Databases are more complex to construct. D. Database information cannot be changed once it is entered.

D. Database information cannot be changed once it is entered.

Which of the following statements about object-oriented databases is FALSE? A. They are more complex than relational databases B. They use a query language to access and manage data C. They are good at handling unstructured data D. They store data in table format

D. They store data in table format

A database schema is also called a(n)____. A. information system B. summary report C. relation D. data dictionary

D. data dictionary

A(n) __________ is a way of retrieving information from one or more table that defines a particular subset of data. A. validation rule B. field constraint C. enquiry D. query

D. query

In a database, a group of related records is called a(n) ________. A. memo B. field C. object D. table

D. table