Deck 14: Using Relational Databases

Question 1

3NF requires that a table be in 2NF and have transitive dependencies.

Answer 1

False

Question 2

Normalization involves altering a table so that it satisfies one or more of four normal forms, or sets of rules for constructing a well-designed database.

Answer 2

False

Question 3

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

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

Answer 3

C

Question 4

Database software recognizes the distinction between text and numeric data.

Question 5

Database software provides the means to ensure that data integrity is enforced.

Question 6

Connecting two tables based on the values in a common column is called a(n) ____ operation.

A) union
B) join
C) intersection
D) liberation

Question 7

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

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

Question 8

When a field in a database contains a null value, it means that ____.

A) the field holds zeros
B) the field holds spaces
C) no data has been entered in the field
D) the field holds asterisks

Question 9

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

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

Question 10

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.

Question 11

Structured Query Language is a commonly used language for accessing data in database tables.

Question 12

A common reason you create a one-to-one relationship is security.

Question 13

If an employee record contains both a company-assigned employee ID and a Social Security number, then both columns are ____ keys.

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

Question 14

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.

Question 15

After you choose a primary key from among candidate keys, the remaining candidate keys become ____ keys.

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

Question 16

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

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

Question 17

Entering data into an existing table is not difficult, but it requires a good deal of time and accurate typing.

Question 18

Some database designers insert an exclamation point after the key instead of underlining it.

Question 19

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

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

Question 20

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

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

Question 21

The ____ assigned to a user indicate which parts of the database the user can view, modify, or delete.

A) permissions
B) controls
C) locks
D) attributes

Question 22

A table that contains repeating groups is ____.

A) unnormalized
B) normalized
C) simplified
D) non-normalized

Question 23

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.

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

Question 24

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

Question 25

A ____________________ is a binary large object, which is a collection of binary data such as an image, video, or audio clip stored in a database system.

Question 26

A ____ relationship is the most common type of relationship between tables.

A) one-to-many
B) one-to-one
C) many-to-one
D) many-to-many

Question 27

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

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

Question 28

To ____ a table is to reduce it to a lower normal form by placing some repeated information back into the table.

A) denormalize
B) normalize
C) flatten
D) compose

Question 29

____ is the unnecessary repetition of data.

A) Data duplication
B) Data replication
C) Data normalization
D) Data redundancy

Question 30

____________________ are composed of associated records.

Question 31

____________________ are formed from groups of related fields.

Question 32

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

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

Question 33

____ is the process of coding data into a format that human beings cannot read.

A) Integrity
B) Encoding
C) Encryption
D) RFID

Question 34

Database developers also refer to operations or transactions as ____ transactions when they appear to execute completely or not at all.

A) coupled
B) atomic
C) decoupled
D) nominal

Question 35

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

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

Question 36

A ____ is a mechanism that prevents changes to a database for a period of time.

A) flag
B) lock
C) permission
D) transaction

Question 37

A(n) ____________________ is a long-term database lock required when users want to maintain a consistent view of their data while making modifications over a long transaction.

Question 38

A database has ____ when it follows a set of rules that makes the data accurate and consistent.

A) transparent integrity
B) data availability
C) data integrity
D) data security

Question 39

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

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

Question 40

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

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

Question 42

Discuss the issue of recovering lost data.

Question 43

List and explain the three normal forms.

Question 44

List two examples of primary keys.

Question 45

Discuss the use of null values within a database table.

Question 46

Discuss a shorthand way to describe a table.

Question 47

List the three types of relationships that can exist between tables.

Question 48

List four major issues with database performance and security.

Question 49

Discuss how to create databases and design tables.

Question 50

List three reasons why a primary key is important.

Question 51

Discuss how to sort the records in a table.