database concepts Ch1
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)
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
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
Which of the following is an example of an attribute? a person's hair color the people who live in a particular town the patients in a doctor's office vendors
a person's hair color
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 mining refers to ____. discovering new data to include in the database analyzing data already stored in a database selling data to other organizations all of the above
analyzing data already stored in a database
What is added to a relational database to eliminate many-to-many relationships? bridging table transitive dependency primary entity secondary entity
bridging table
Which of the following terms is considered the basic unit of data in a database? character field record file
character
A field in the logical design of a database corresponds to a ____ in the physical database. column row table file
column
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 can lead to partial dependencies? composite primary key common fields foreign keys normalization
composite primary key
Analyzing historical sales data stored in a database is commonly referred to as ____. data storage data mining data manipulation archived data
data mining
A ____ is a storage structure designed to hold a collection of data. column row table database
database
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
What represents a characteristic or attribute that is being collected about an entity? record row field both a and b
field
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? record file field database
field
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 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)
A foreign key is usually found on which side of a relationship? one many unnormalized primary entity
many
Data in first normal form (1NF) does not contain which of the following? primary key repeating groups partial dependencies both a and b
repeating groups
Which of the following may contain transitive dependencies, but not partial dependencies? unnormalized data first normal form (1NF) second normal form (2NF) third normal form (3NF)
second normal form (2NF)
In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis? systems investigation systems analysis systems deployment systems implementation and review
systems deployment
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
The multi-step process used when creating a new system is referred to as ____. the Systems Development Life Cycle data mining E-R Modeling SQL
the Systems Development Life Cycle
If the data has no partial dependencies, repeating groups, or transitive dependencies, and has a composite primary key, the data is in which form? first normal second normal third normal unnormalized
third normal
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