Question 1

Which of the following terms represents a collection of fields?

Accepted Answer

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

Question 2

In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?

Accepted Answer

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

Question 3

What is the purpose of an E-R Model?

Accepted Answer

An E-R Model is used by designers to det

Question 4

What is the purpose of a foreign key?

Accepted Answer

A foreign key is used to link data toget

Question 5

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?

Accepted Answer

A)  systems recovery 
B)  systems analysis 
C)  systems design 
D)  systems implementation and review 
A)  systems recovery 
B)  systems analysis 
C)  systems design 
D)  systems implementation and review

Question 6

A(n) ____________________ is a storage structure that contains data.

Accepted Answer

The answer of A(n) ____________________ is a storage structure that...

Question 7

A many-to-many relationship cannot exist in a relational database.

Accepted Answer

A) True 
 B)False

Question 8

A ____ is a storage structure designed to hold a collection of data.

Accepted Answer

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

Question 9

A(n) ____________________ table can be added to the physical database to eliminate a many-to-many relationship.

Accepted Answer

The answer of A(n) ____________________ table can be added to...

Question 10

Transitive dependency can only exist if the data is uniquely identified by a composite primary key.

Accepted Answer

A) True 
 B)False

Question 11

A character is a basic unit of data and can consist of a number, letter, or special symbol.

Accepted Answer

A) True 
 B)False

Question 12

Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely identify each record.

Accepted Answer

A) True 
 B)False

Question 13

A(n) ____________________ is a basic unit of data that can consist of a letter, number, or special symbol.

Accepted Answer

The answer of A(n) ____________________ is a basic unit of...

Question 14

The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a 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 15

Data in first normal form (1NF) does not contain which of the following?

Accepted Answer

A)  primary key 
B)  repeating groups 
C)  partial dependencies 
D)  both a and b 
A)  primary key 
B)  repeating groups 
C)  partial dependencies 
D)  both a and b

Question 16

A field is a basic unit of data also referred to as a record.

Accepted Answer

A) True 
 B)False

Question 17

Partial dependency means that at least one of the data values is dependent on only a portion of the primary key.

Accepted Answer

A) True 
 B)False

Question 18

-What type of relationship is depicted in Figure 1?

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 19

A field is a group of related ____________________.

Accepted Answer

The answer of A field is a group of related...

Question 20

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

Accepted Answer

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

Which of the following terms represents a collection of fields?

In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?

What is the purpose of an E-R Model?

What is the purpose of a foreign key?

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?

A(n) ____________________ is a storage structure that contains data.

A many-to-many relationship cannot exist in a relational database.

A ____ is a storage structure designed to hold a collection of data.

A(n) ____________________ table can be added to the physical database to eliminate a many-to-many relationship.

Transitive dependency can only exist if the data is uniquely identified by a composite primary key.

A character is a basic unit of data and can consist of a number, letter, or special symbol.

Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely identify each record.

A(n) ____________________ is a basic unit of data that can consist of a letter, number, or special symbol.

The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?

Data in first normal form (1NF) does not contain which of the following?

A field is a basic unit of data also referred to as a record.

Partial dependency means that at least one of the data values is dependent on only a portion of the primary key.

-What type of relationship is depicted in Figure 1?

A field is a group of related ____________________.

A field is referred to as a(n) ____________________ in the physical 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

Which of the following terms represents a collection of fields?

In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?

What is the purpose of an E-R Model?

What is the purpose of a foreign key?

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?

A(n) ____________________ is a storage structure that contains data.

A many-to-many relationship cannot exist in a relational database.

A ____ is a storage structure designed to hold a collection of data.

A(n) ____________________ table can be added to the physical database to eliminate a many-to-many relationship.

Transitive dependency can only exist if the data is uniquely identified by a composite primary key.

A character is a basic unit of data and can consist of a number, letter, or special symbol.

Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely identify each record.

A(n) ____________________ is a basic unit of data that can consist of a letter, number, or special symbol.

The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?

Data in first normal form (1NF) does not contain which of the following?

A field is a basic unit of data also referred to as a record.

Partial dependency means that at least one of the data values is dependent on only a portion of the primary key.

-What type of relationship is depicted in Figure 1?

A field is a group of related ____________________.

A field is referred to as a(n) ____________________ in the physical 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