Ch.1/ Lab 6 Quiz Flashcards
Data in second normal form (2NF) may contain which of the following?
- repeating groups
- transitive dependencies
- partial dependencies
- both a and b
transitive dependencies
Analyzing historical sales data stored in a database is commonly referred to as ____.
- data storage
- data mining
- data manipulation
- archived data
data mining
Which of the following may contain partial dependencies, but cannot contain repeating groups?
- unnormalized data
- first normal form (1NF)
- second normal form (2NF)
- third normal form (3NF)
first normal form (1NF)
What is added to a relational database to eliminate many-to-many relationships?
- bridging table
- transitive dependency
- primary entity
- secondary entity
bridging table
A DBMS includes which of the following capabilities?
- security
- data dictionary
- multiuser access
- all of the above
all of the above
Which of the following is an interface tool that allows a user to create, edit, and manipulate data in Oracle11g?
- SQL
- SQL*Plus
- ASCII
- Script
SQL*Plus
In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?
- systems recovery
- systems analysis
- systems design
- systems implementation and review
systems design
If entity A in Figure 2 represents customers and entity B represents automobiles, which of the following statements is correct?
- Each customer can only own one car, but each car can be owned by many customers.
- Each customer can only own one car and each car can only be owned by one customer.
- Each customer can own many cars and each car can be owned by many customers.
- Each customer can own many cars, but each car can be owned by only one customer
Each customer can own many cars, but each car can be owned by only one customer.
Which of the following is used to determine the correct organization for data that is to be stored in a database?
- E-R model
- normalization process
- systems implementation and review
- systems analysis
normalization process
A ____ is a storage structure designed to hold a collection of data.
- column
- row
- table
- database
database
Which of the following is used to uniquely identify each record?
- primary key
- row
- partial dependency
- account number
primary key
Which of the following is not a step in the Systems Development Life Cycle (SDLC)?
- systems analysis
- -systems investigation
- systems design
- all of the above are steps in the SDLC
all of the above are steps in the SDLC
Data in third normal form (3NF) contains which of the following?
- repeating groups
- transitive dependencies
- partial dependencies
- none of the above
none of the above
What represents a characteristic or attribute that is being collected about an entity?
- record
- row
- field
- both a and b
field
Suppose that a patient in a hospital can only be assigned to one room. However, the room may be assigned to more than one patient at a time. This is an example of what type of relationship?
- one-to-many
- many-to-many
- one-to-all
- one-to-one
one-to-many
A record in the logical design of a database is represented by what in the physical database?
- attribute
- field
- tuple
- row
row
Which of the following can be used to link the data in two or more tables together?
- repeating group
- relationships
- SDLC
- common field
common field
Which of the following committees are responsible for establishing SQL guidelines?
- ANSI and ASCII
- ANSI and ISO
- IEEE and OSI
- OSI and ASCII
ANSI and ISO
Which of the following terms refers to a group of related records?
- database
- character
- field
- file
file
A field in the logical design of a database is represented by what in the physical database?
- column
- row
- field
- row
column
A foreign key is usually found on which side of a relationship?
- one
- many
- unnormalized
- primary entity
many
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?
- one-to-many
- many-to-many
- one-to-all
- one-to-one
many-to-many
Which of the following usually correlates to a primary key in another table?
- transitive dependency
- composite primary key
- foreign key
- partial dependency
foreign key
Which of the following is used to create and maintain the physical database?
- Data mining
- Database Management System (DBMS)
- E-R Model
- Systems Development Life Cycle (SDLC)
Database Management System (DBMS)
Partial dependency exists if what conditions exist?
- a column is dependent on a portion of the table that is not identified as the primary key
- a column is dependent only on a portion of a composite primary key
- the data contains repeating groups
- the table is not in first normal form (1NF)
a column is dependent only on a portion of a composite primary key
In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?
- entity
- row
- attribute
- file
entity
The multi-step process used when creating a new system is referred to as ____.
- Systems Development Life Cycle (SDLC)
- data mining
- E-R Modeling
- SQL
Systems Development Life Cycle (SDLC)
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?
- duplicate key
- foreign key
- composite primary key
- distinct key
-foreign key
Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?
- unnormalized data
- first normal form (1NF)
- second normal form (2NF)
- third normal form (3NF)
-first normal form (1NF)
Which of the following can lead to partial dependencies?
- composite primary key
- common fields
- foreign keys
- normalization
composite primary key
