Question 1

A transitive ____ occurs when the value of a nonkey attribute determines, or predicts, the value of another nonkey attribute.

Accepted Answer

A)  conversion 
B)  recursion 
C)  dependency 
D)  anomaly

Question 2

A ____ is a subset of rows in a database table that all depend on the same key.

Accepted Answer

A)  complete group 
B)  flattened group 
C)  repeating group 
D)  normalized group

Question 3

____ techniques include storing and verifying passwords or even using physical characteristics, such as fingerprints or voice recognition, before users can view data.

Accepted Answer

A)  Authorization 
B)  Data conversion 
C)  Data normalization 
D)  Authentication

Question 4

A(n) ____ key is a column that is not a key in a table, but it contains an attribute that is a key in a related table.

Accepted Answer

A)  alternate 
B)  candidate 
C)  foreign 
D)  primary

Question 5

When you combine two columns to create a compound key, you are ____ the columns.

Accepted Answer

A)  splitting 
B)  converting 
C)  joining 
D)  concatenating

Question 6

List two examples of primary keys.

Accepted Answer

The answer of List two examples of primary keys....

Question 7

A key that is constructed from multiple columns is called a compound key or ____ key.

Accepted Answer

A)  composite 
B)  combined 
C)  joined 
D)  joint

Question 8

In many database systems, some "deleted" records are not physically removed, but they are just marked as deleted so that they will not be used to process active records.

Accepted Answer

A) True 
 B)False

Question 9

List and explain the three normal forms.

Accepted Answer

The answer of List and explain the three normal forms....

Question 10

In database management systems, a particular way of looking at a database is sometimes called a(n) ____.

Accepted Answer

A)  segment 
B)  identity 
C)  view 
D)  value

Question 11

In a database, the files often are called ____ because you can arrange their contents in rows and columns.

Accepted Answer

A)  sheets 
B)  pages 
C)  forms 
D)  tables

Question 12

List three reasons why a primary key is important.

Accepted Answer

The answer of List three reasons why a primary key...

Question 13

Depending on the software you use, you might create a query by filling in blanks in a process called ____.

Accepted Answer

A)  query by example 
B)  query by reference 
C)  query by demonstration 
D)  query by comparison

Question 14

In some database software packages, such as Microsoft Access, you indicate a primary key simply by selecting a column name and clicking a button that is labeled with a key icon.

Accepted Answer

A) True 
 B)False

Question 15

A primary key should be ____________________, meaning that a value does not change during normal operation.

Accepted Answer

The answer of A primary key should be ____________________, meaning...

Question 16

The basic form of the SQL statement that retrieves selected records from a table is ____.

Accepted Answer

A)  GET-FROM-WHERE 
B)  SELECT-FROM-WHERE 
C)  RETRIEVE-FROM-WHERE 
D)  SELECTION-FROM-WHERE

Question 17

____________________ are formed from groups of related fields.

Accepted Answer

The answer of ____________________ are formed from groups of related...

Question 18

A symbol that means "any" or "all" is known as a ____.

Accepted Answer

A)  placeholder 
B)  token 
C)  substitution 
D)  wildcard

Question 19

Match between columns
                        Premises: A value that uniquely identifies a record
A group of database tables from which you can make connections between columns
Holds a group of files that an organization needs to support its applications
The process of returning the database to a correct form that existed before an error occurred
Represent a piece of information
The connection between two tables
Occurs when two database users need to modify the same record at the same time
A question using the syntax that the database software can understand
A group of transactions applied all at once
The smallest usable units of data

Accepted Answer

The Answer of fields and primary key and recovery and is...

Question 20

An ____ is an irregularity in a database's design that causes problems and inconveniences.

Accepted Answer

A)  inversion 
B)  inference 
C)  anomaly 
D)  abstraction

Exam 14: Using Relational Databases