WEEK 1
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
