Deck 1: Overview of Database Concepts

Question 1

A collection of fields is a file.

Answer 1

False

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

Partial dependency means that at least one of the data values is dependent on only a portion of the primary key.

Question 5

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

Question 6

A database is a physical storage device for data.

Question 7

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

Question 8

A collection of records is a file.

Question 9

The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.

Question 10

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

Question 11

A character is a basic unit of data and can consist of a number, letter, or special symbol.

Question 12

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

Question 13

An entity is represented by a column in the Entity-Relationship Model.

Question 14

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

Question 15

Data redundancy is created through a process known as normalization.

Question 16

If a primary key has been identified for the data, then the data is considered to be in first normal form (1NF).

Question 17

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

Question 18

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

Question 19

A record in the logical design of a database corresponds to a row in the physical table of a relational database.

Question 20

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

Question 21

The multi-step process used when creating a new system is referred to as ____.

A) the Systems Development Life Cycle
B) data mining
C) E-R Modeling
D) SQL

Question 22

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

Question 23

Data mining refers to analyzing historical data stored in a database.

Question 24

A record in the logical design of a database corresponds to a ____ in the physical database.

A) column
B) row
C) table
D) file

Question 25

Which of the following is used to create and maintain the physical database?

A) Data mining
B) Database Management System (DBMS)
C) E-R Model
D) Systems Development Life Cycle (SDLC)

Question 26

A foreign key appears on the many side of a one-to-many relationship.

Question 27

A field in the logical design of a database corresponds to a ____ in the physical database.

A) column
B) row
C) table
D) file

Question 28

Which of the following terms is considered the basic unit of data in a database?

A) character
B) field
C) record
D) file

Question 29

Tables can be linked or joined together through their primary keys.

Question 30

Structured Query Language (SQL) is generally used to interact with a database.

Question 31

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

Question 32

Which of the following terms represents a collection of fields?

A) field
B) record
C) character
D) file

Question 33

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

Question 34

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?

A) record
B) file
C) field
D) database

Question 35

A foreign key uniquely identifies each row in a table.

Question 36

Which of the following terms refers to a group of related records?

A) database
B) character
C) field
D) file

Question 37

A column represents a field in the physical database table.

Question 38

A ____ is a group of interrelated files.

A) record
B) character
C) field
D) database

Question 39

A ____ is a storage structure designed to hold a collection of data.

A) column
B) row
C) table
D) database

Question 40

The occurrence of data anomalies would indicate an unnormalized database design.

Question 41

What type of relationship is depicted in Figure 2?

A) one-to-many
B) many-to-many
C) one-to-all
D) one-to-one

Question 42

A DBMS includes which of the following capabilities?

A) security
B) data dictionary
C) multiuser access
D) all of the above

Question 43

In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?

A) systems investigation
B) systems analysis
C) systems deployment
D) systems implementation and review

Question 44

Which of the following is used to uniquely identify each record?

A) primary key
B) row
C) partial dependency
D) account number

Question 45

In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?

A) entity
B) row
C) attribute
D) file

Question 46

Which of the following may contain repeating groups of data?

A) unnormalized data
B) first normal form (1NF)
C) second normal form (2NF)
D) third normal form (3NF)

Question 47

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?

A) one-to-many
B) many-to-many
C) one-to-all
D) one-to-one

Question 48

Which statement best describes the relationship shown in Figure 1?

A) For every occurrence of A, there can only be one occurrence of B.
B) For every occurrence of A, there can be multiple occurrences of B.
C) There can be multiple occurrences of A and B.
D) For every occurrence of B, there can be multiple occurrences of A.

Question 49

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?

A) systems recovery
B) systems analysis
C) systems design
D) systems implementation and review

Question 50

Which of the following is used to determine the correct organization for data that is to be stored in a database?

A) E-R model
B) normalization process
C) systems implementation and review
D) systems analysis

Question 51

Which of the following may contain partial dependencies, but cannot contain repeating groups?

A) unnormalized data
B) first normal form (1NF)
C) second normal form (2NF)
D) third normal form (3NF)

Question 52

Which of the following is not a step in the Systems Development Life Cycle (SDLC)?

A) systems analysis
B) systems investigation
C) systems design
D) all of the above are steps in the SDLC

Question 53

Which of the following may contain transitive dependencies, but not partial dependencies?

A) unnormalized data
B) first normal form (1NF)
C) second normal form (2NF)
D) third normal form (3NF)

Question 54

Partial dependency exists if what conditions exist?

A) a column is dependent on a portion of the table that is not identified as the primary key
B) a column is dependent only on a portion of a composite primary key
C) the data contains repeating groups
D) the table is not in first normal form (1NF)

Question 55

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?

A) one-to-many
B) many-to-many
C) one-to-all
D) one-to-one

Question 56

What type of relationship is depicted in Figure 1?

A) one-to-many
B) many-to-many
C) one-to-all
D) one-to-one

Question 57

If a recipe contains several ingredients, and those ingredients can also be used in other recipes, this would be an example of what type of relationship?

A) one-to-many
B) many-to-many
C) one-to-all
D) one-to-one

Question 58

In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?

A) systems investigation
B) systems analysis
C) systems design
D) systems implementation and review

Question 59

If uncontrolled, what can lead to data anomalies?

A) data normalization
B) data correlation
C) data redundancy
D) data suppression

Question 60

If entity A in Figure 2 represents customers and entity B represents automobiles, which of the following statements is correct?

A) Each customer can only own one car, but each car can be owned by many customers.
B) Each customer can only own one car and each car can only be owned by one customer.
C) Each customer can own many cars and each car can be owned by many customers.
D) Each customer can own many cars, but each car can be owned by only one customer.

Question 61

What represents a characteristic or attribute that is being collected about an entity?

A) record
B) row
C) field
D) both a and b

Question 62

What is added to a relational database to eliminate many-to-many relationships?

A) bridging table
B) transitive dependency
C) primary entity
D) secondary entity

Question 63

Which of the following can be used to link the data in two or more tables together?

A) repeating group
B) relationships
C) SDLC
D) common field

Question 64

A field in the logical design of a database is represented by what in the physical database?

A) column
B) row
C) field
D) row

Question 65

A record in the logical design of a database is represented by what in the physical database?

A) row
B) field
C) record
D) row

Question 66

Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?

A) unnormalized data
B) first normal form (1NF)
C) second normal form (2NF)
D) third normal form (3NF)

Question 67

Which of the following committees are responsible for establishing SQL guidelines?

A) ANSI and ASCII
B) ANSI and ISO
C) IEEE and OSI
D) OSI and ASCII

Question 68

Analyzing historical sales data stored in a database is commonly referred to as ____.

A) data storage
B) data mining
C) data manipulation
D) archived data

Question 69

A foreign key is usually found on which side of a relationship?

A) one
B) many
C) unnormalized
D) primary entity

Question 70

Which of the following is an example of an attribute?

A) a person's hair color
B) the people who live in a particular town
C) the patients in a doctor's office
D) vendors

Question 71

Which of the following types of relationships cannot exist in a relational database?

A) one-to-many
B) many-to-many
C) one-to-all
D) one-to-one

Question 72

Data mining refers to ____.

A) discovering new data to include in the database
B) analyzing data already stored in a database
C) selling data to other organizations
D) all of the above

Question 73

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?

A) duplicate key
B) foreign key
C) composite primary key
D) distinct key

Question 74

If the data has no partial dependencies, repeating groups, or transitive dependencies, and has a composite primary key, the data is in which form?

A) first normal
B) second normal
C) third normal
D) unnormalized

Question 75

Which of the following can lead to partial dependencies?

A) composite primary key
B) common fields
C) foreign keys
D) normalization

Question 76

Data in third normal form (3NF) contains which of the following?

A) repeating groups
B) transitive dependencies
C) partial dependencies
D) none of the above

Question 77

Which of the following usually correlates to a primary key in another table?

A) transitive dependency
B) composite primary key
C) foreign key
D) partial dependency

Question 78

Which of the following is an interface tool that allows a user to create, edit, and manipulate data in Oracle11g?

A) SQL
B) SQL*Plus
C) ASCII
D) Script

Question 79

Data in second normal form (2NF) may contain which of the following?

A) repeating groups
B) transitive dependencies
C) partial dependencies
D) both a and b

Question 80

Data in first normal form (1NF) does not contain which of the following?

A) primary key
B) repeating groups
C) partial dependencies
D) both a and b