A " " relationship means data can have multiple occurrences in both entities
Many to Many
SQL commands can be issued in Oracle 12c through ____________________ which is an interface that allows users to interact with the database.
SQL*Plus
A bridging table can be used to eliminate a many-to-many relationship in a relational database.
TRUE
Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?
first normal form (1NF)
Which of the following terms represents a collection of fields?
record
Which of the following is an example of an attribute?
a person's hair color
A file is referred to as a(n) ____________________ in an Oracle10g database.
table
A(n) ____________________ is a group of interrelated files.
database
If a primary key has been identified for the data, then the data is considered to be in first normal form (1NF).
false
An entity is represented by a column in the Entity-Relationship Model.
false
A character is a basic unit of data and can consist of a number, letter, or special symbol.
true
Data in second normal form (2NF) may contain which of the following?
transitive dependencies
Data mining refers to ____.
analyzing data already stored in a database
Which of the following may contain partial dependencies, but cannot contain repeating groups?
first normal form (1NF)
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?
many-to-many
What type of relationship is depicted in Figure 2?
one-to-many
In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?
systems deployment
A field in the logical design of a database corresponds to a row in the physical table of a relational database.
False
Which of the following usually correlates to a primary key in another table?
foreign key
Analyzing historical data stored in a database is referred to as ____________________.
Correct data mining
Which of the following may contain partial dependencies, but cannot contain repeating groups?
first normal form (1NF)
A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.
false
What is added to a relational database to eliminate many-to-many relationships?
bridging table
A straight line with a crow's foot at one end depicts a(n) ____________________ relationship in an E-R Model.
Correct one to many
A collection of fields is a file.
False
Which of the following terms represents a collection of fields?
record
A(n) ____________________ is a storage structure that contains data.
database
What represents a characteristic or attribute that is being collected about an entity?
field
Data in third normal form (3NF) contains which of the following?
none of the above
Which of the following usually correlates to a primary key in another table?
foreign key
Data in second normal form (2NF) may contain which of the following?
transitive dependencies
A record in the logical design of a database corresponds to a ____ in the physical database.
row
A(n) ____________________ table can be added to the physical database to eliminate a many-to-many relationship.
bridging
A(n) ____________________ is used to uniquely identify each record.
primary key
A collection of records is a file.
True
A(n) ____________________ relationship means data can have multiple occurrences in both entities.
many-to-many
In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?
Systems Design
A(n) ____________________ is a basic unit of data that can consist of a letter, number, or special symbol.
character
Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?
first normal form (1NF)
A field in the logical design of a database corresponds to a ____ in the physical database.
column
Partial dependency can only exist if the data is uniquely identified by a composite primary key.
True
Which of the following is an interface tool that allows a user to create, edit, and manipulate data in Oracle11g?
SQL*Plus
Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?
field
Which of the following may contain repeating groups of data?
unnormalized data
Which of the following can be used to link the data in two or more tables together?
common field
A foreign key appears on the many side of a one-to-many relationship.
True
Data in first normal form (1NF) does not contain which of the following?
repeating groups
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?
many-to-many
A column represents a field in the physical database table.
True
The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.
True
Only one type of relationship can be represented in an Entity-Relationship Model.
False
A file is referred to as a(n) ____________________ in an Oracle10g database.
table
Which of the following may contain transitive dependencies, but not partial dependencies?
second normal form (2NF)
What represents a characteristic or attribute that is being collected about an entity?
field
Which of the following may contain partial dependencies, but cannot contain repeating groups?
first normal form (1NF)
Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely identify each record.
False