WEEK 1

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

A foreign key is usually found on which side of a relationship? one many unnormalized primary entity

B

Analyzing historical sales data stored in a database is commonly referred to as ____. data storage data mining data manipulation archived data

B

Data in first normal form (1NF) does not contain which of the following? primary key repeating groups partial dependencies both a and b

B

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

B

In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood? systems investigation systems analysis systems design systems implementation and review

B

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

B

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)

B

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

B

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

B

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)

B

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

C

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

C

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

C

A DBMS includes which of the following capabilities? security data dictionary multiuser access all of the above

D

A ____ is a storage structure designed to hold a collection of data. column row table database

D

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

F

Only one type of relationship can be represented in an Entity-Relationship Model. True False

F

SQL commands can be issued in Oracle11g through ___SQL*Plus___ which is an interface that allows users to interact with the database. A field in the logical design of a database corresponds to a row in the physical table of a relational database. True False

F

Two tables can be linked or joined together through a common field. True False

T

A field is referred to as a(n) __column__ in the physical database. Which of the following can be used to link the data in two or more tables together? repeating group relationships SDLC common field

D

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

D

A collection of fields is a file. True False

F

A collection of fields is a file. True False

F

A database is a physical storage device for data. True False

F

A field in the logical design of a database corresponds to a row in the physical table of a relational database. True False

F

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

F

A one-to-many relationship cannot be included in a relational database. True False

F

A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table. True False

F

A bridging table can be used to eliminate a many-to-many relationship in a relational database. True False

T

A collection of records is a file. True False

T

A foreign key uniquely identifies each row in a table. True False

T

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

T

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

T

The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system. True False

T

The simplest approach to remove a partial dependency is to use each portion of the primary key to create separate tables. True False

T

A field in the logical design of a database corresponds to a ____ in the physical database. column row table file

A

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

A

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

A

What is added to a relational database to eliminate many-to-many relationships? bridging table transitive dependency primary entity secondary entity

A

What type of relationship is depicted in Figure 2? one-to-many many-to-many one-to-all one-to-one

A

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

Which of the following is used to uniquely identify each record? primary key row partial dependency account number

A


Ensembles d'études connexes

Chapter 34: Pediatric Emergencies

View Set

MGT449 Chapter 2 Quiz (for exam)

View Set

Finance Skills for Managers - D076

View Set

Medical Terminology Final Exam #12

View Set

Organization Behavior Chapter 13 Power & Politics

View Set