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