Question 1

If the data has no partial dependencies, repeating groups, or transitive dependencies, and has a composite primary key, the data is in which form?

Accepted Answer

A)  first normal 
B)  second normal 
C)  third normal 
D)  unnormalized 
A)  first normal 
B)  second normal 
C)  third normal 
D)  unnormalized C

Question 2

Which of the following may contain partial dependencies, but cannot contain repeating groups?

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) B

Question 3

What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?

Accepted Answer

A)  duplicate key 
B)  foreign key 
C)  composite primary key 
D)  distinct key 
A)  duplicate key 
B)  foreign key 
C)  composite primary key 
D)  distinct key B

Question 4

What steps/tasks are required to convert unnormalized data to third normal form (3NF)?

Accepted Answer

Any repeating groups are eliminated from

Question 5

Analyzing historical data stored in a database is referred to as ____________________.

Accepted Answer

The answer of Analyzing historical data stored in a database...

Question 6

The multi-step process used when creating a new system is referred to as ____.

Accepted Answer

A)  the Systems Development Life Cycle 
B)  data mining 
C)  E-R Modeling 
D)  SQL 
A)  the Systems Development Life Cycle 
B)  data mining 
C)  E-R Modeling 
D)  SQL

Question 7

Which of the following terms refers to a group of related records?

Accepted Answer

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

Question 8

A(n) ____________________ is used to uniquely identify each record.

Accepted Answer

The answer of A(n) ____________________ is used to uniquely identify...

Question 9

Which of the following can be used to link the data in two or more tables together?

Accepted Answer

A)  repeating group 
B)  relationships 
C)  SDLC 
D)  common field 
A)  repeating group 
B)  relationships 
C)  SDLC 
D)  common field

Question 10

A solid straight line in an E-R Model depicts a(n) ____________________ relationship.

Accepted Answer

one-to-one

Question 11

In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?

Accepted Answer

A)  systems investigation 
B)  systems analysis 
C)  systems deployment 
D)  systems implementation and review 
A)  systems investigation 
B)  systems analysis 
C)  systems deployment 
D)  systems implementation and review

Question 12

A database is a physical storage device for data.

Accepted Answer

A) True 
 B)False

Question 13

Data is in third normal form if it is in second normal form and has no _________________________.

Accepted Answer

Transitive

Question 14

If a primary key has been identified for the data, then the data is considered to be in first normal form (1NF).

Accepted Answer

A) True 
 B)False

Question 15

Only one type of relationship can be represented in an Entity-Relationship Model.

Accepted Answer

A) True 
 B)False

Question 16

A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.

Accepted Answer

A) True 
 B)False

Question 17

A(n) ____________________ is a group of related fields.

Accepted Answer

The answer of A(n) ____________________ is a group of related...

Question 18

A(n) ______________________________ is used to create and maintain the structure of a database.

Accepted Answer

database m

Question 19

Which of the following is not a step in the Systems Development Life Cycle (SDLC)?

Accepted Answer

A)  systems analysis 
B)  systems investigation 
C)  systems design 
D)  all of the above are steps in the SDLC 
A)  systems analysis 
B)  systems investigation 
C)  systems design 
D)  all of the above are steps in the SDLC

Question 20

If at least one value in a record does not depend upon the primary key, then a _________________________ exists.

Accepted Answer

Transitive

If the data has no partial dependencies, repeating groups, or transitive dependencies, and has a composite primary key, the data is in which form?

Which of the following may contain partial dependencies, but cannot contain repeating groups?

What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?

What steps/tasks are required to convert unnormalized data to third normal form (3NF)?

Analyzing historical data stored in a database is referred to as ____________________.

The multi-step process used when creating a new system is referred to as ____.

Which of the following terms refers to a group of related records?

A(n) ____________________ is used to uniquely identify each record.

Which of the following can be used to link the data in two or more tables together?

A solid straight line in an E-R Model depicts a(n) ____________________ relationship.

In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?

A database is a physical storage device for data.

Data is in third normal form if it is in second normal form and has no _________________________.

If a primary key has been identified for the data, then the data is considered to be in first normal form (1NF).

Only one type of relationship can be represented in an Entity-Relationship Model.

A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.

A(n) ____________________ is a group of related fields.

A(n) ______________________________ is used to create and maintain the structure of a database.

Which of the following is not a step in the Systems Development Life Cycle (SDLC)?

If at least one value in a record does not depend upon the primary key, then a _________________________ exists.

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

If the data has no partial dependencies, repeating groups, or transitive dependencies, and has a composite primary key, the data is in which form?

Which of the following may contain partial dependencies, but cannot contain repeating groups?

What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?

What steps/tasks are required to convert unnormalized data to third normal form (3NF)?

Analyzing historical data stored in a database is referred to as ____________________.

The multi-step process used when creating a new system is referred to as ____.

Which of the following terms refers to a group of related records?

A(n) ____________________ is used to uniquely identify each record.

Which of the following can be used to link the data in two or more tables together?

A solid straight line in an E-R Model depicts a(n) ____________________ relationship.

In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?

A database is a physical storage device for data.

Data is in third normal form if it is in second normal form and has no _________________________.

If a primary key has been identified for the data, then the data is considered to be in first normal form (1NF).

Only one type of relationship can be represented in an Entity-Relationship Model.

A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.

A(n) ____________________ is a group of related fields.

A(n) ______________________________ is used to create and maintain the structure of a database.

Which of the following is not a step in the Systems Development Life Cycle (SDLC)?

If at least one value in a record does not depend upon the primary key, then a _________________________ exists.

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