Question 1

Data in third normal form (3NF) contains which of the following?

Accepted Answer

A)  repeating groups 
B)  transitive dependencies 
C)  partial dependencies 
D)  none of the above 
A)  repeating groups 
B)  transitive dependencies 
C)  partial dependencies 
D)  none of the above

Question 2

A file is composed of a group of related ____________________.

Accepted Answer

The answer of A file is composed of a group...

Question 3

Tables can be linked or joined together through their primary keys.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?

Accepted Answer

A)  unnormalized data 
B)  first normal form (1NF) 
C)  second normal form (2NF) 
D)  third normal form (3NF) 
A)  unnormalized data 
B)  first normal form (1NF) 
C)  second normal form (2NF) 
D)  third normal form (3NF)

Question 5

If uncontrolled, what can lead to data anomalies?

Accepted Answer

A)  data normalization 
B)  data correlation 
C)  data redundancy 
D)  data suppression 
A)  data normalization 
B)  data correlation 
C)  data redundancy 
D)  data suppression

Question 6

A field in the logical design of a database corresponds to a ____ in the physical database.

Accepted Answer

A)  column 
B)  row 
C)  table 
D)  file 
A)  column 
B)  row 
C)  table 
D)  file

Question 7

Data mining refers to ____.

Accepted Answer

A)  discovering new data to include in the database 
B)  analyzing data already stored in a database 
C)  selling data to other organizations 
D)  all of the above 
A)  discovering new data to include in the database 
B)  analyzing data already stored in a database 
C)  selling data to other organizations 
D)  all of the above

Question 8

A(n) ____________________ is referred to as a row in the physical database.

Accepted Answer

The answer of A(n) ____________________ is referred to as a...

Question 9

A collection of fields is a file.

Accepted Answer

A) True 
 B)False

Question 10

A column represents a field in the physical database table.

Accepted Answer

A) True 
 B)False

Question 11

Data is in ____________________ normal form if it does not have any repeating groups and has a primary key.

Accepted Answer

The answer of Data is in ____________________ normal form if...

Question 12

The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.

Accepted Answer

A) True 
 B)False

Question 13

An entity is represented by a column in the Entity-Relationship Model.

Accepted Answer

A) True 
 B)False

Question 14

The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables.

Accepted Answer

A) True 
 B)False

Question 15

A one-to-many relationship cannot be included in a relational database.

Accepted Answer

A) True 
 B)False

Question 16

If a recipe contains several ingredients, and those ingredients can also be used in other recipes, this would be an example of what type of relationship?

Accepted Answer

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

Question 17

A ____ is a group of interrelated files.

Accepted Answer

A)  record 
B)  character 
C)  field 
D)  database 
A)  record 
B)  character 
C)  field 
D)  database

Question 18

What represents a characteristic or attribute that is being collected about an entity?

Accepted Answer

A)  record 
B)  row 
C)  field 
D)  both a and b 
A)  record 
B)  row 
C)  field 
D)  both a and b

Question 19

Which of the following may contain transitive dependencies, but not partial dependencies?

Accepted Answer

A)  unnormalized data 
B)  first normal form (1NF) 
C)  second normal form (2NF) 
D)  third normal form (3NF) 
A)  unnormalized data 
B)  first normal form (1NF) 
C)  second normal form (2NF) 
D)  third normal form (3NF)

Question 20

Which of the following types of relationships cannot exist in a relational database?

Accepted Answer

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

Data in third normal form (3NF) contains which of the following?

A file is composed of a group of related ____________________.

Tables can be linked or joined together through their primary keys.

Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?

If uncontrolled, what can lead to data anomalies?

A field in the logical design of a database corresponds to a ____ in the physical database.

Data mining refers to ____.

A(n) ____________________ is referred to as a row in the physical database.

A collection of fields is a file.

A column represents a field in the physical database table.

Data is in ____________________ normal form if it does not have any repeating groups and has a primary key.

The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.

An entity is represented by a column in the Entity-Relationship Model.

The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables.

A one-to-many relationship cannot be included in a relational database.

If a recipe contains several ingredients, and those ingredients can also be used in other recipes, this would be an example of what type of relationship?

A ____ is a group of interrelated files.

What represents a characteristic or attribute that is being collected about an entity?

Which of the following may contain transitive dependencies, but not partial dependencies?

Which of the following types of relationships cannot exist in a relational database?

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 1: Overview of Database Concepts

Data in third normal form (3NF) contains which of the following?

A file is composed of a group of related ____________________.

Tables can be linked or joined together through their primary keys.

Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?

If uncontrolled, what can lead to data anomalies?

A field in the logical design of a database corresponds to a ____ in the physical database.

Data mining refers to ____.

A(n) ____________________ is referred to as a row in the physical database.

A collection of fields is a file.

A column represents a field in the physical database table.

Data is in ____________________ normal form if it does not have any repeating groups and has a primary key.

The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.

An entity is represented by a column in the Entity-Relationship Model.

The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables.

A one-to-many relationship cannot be included in a relational database.

If a recipe contains several ingredients, and those ingredients can also be used in other recipes, this would be an example of what type of relationship?

A ____ is a group of interrelated files.

What represents a characteristic or attribute that is being collected about an entity?

Which of the following may contain transitive dependencies, but not partial dependencies?

Which of the following types of relationships cannot exist in a relational database?

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters