Deck 1: Overview of Database Concepts

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

A database is a physical storage device for data.​

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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 12

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

Question 13

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

Question 14

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

Question 15

A collection of fields is a file.​

Question 16

A collection of records is a file.​

Question 17

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

Question 18

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

Question 19

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

Question 20

Data redundancy is created through a process known as normalization.​

Question 21

A foreign key uniquely identifies each row in a table.​

Question 22

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

Question 23

​Which of the following terms represents a collection of fields?​

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

Question 24

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

Question 25

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

Question 26

A ____ is a group of interrelated files.​

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

Question 27

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

Question 28

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

Question 29

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 30

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

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

Question 31

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 32

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 33

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

Question 34

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 35

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

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

Question 36

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 37

A column represents a field in the physical database table.​

Question 38

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

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

Question 39

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

Question 40

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

Question 41

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 42

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 43

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 44

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 45

​
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 46

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 47

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 48

​
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 49

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 50

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 51

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

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

Question 52

A DBMS includes which of the following capabilities?​

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

Question 53

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) ​one-to-all
C) ​many-to-many
D) ​one-to-one

Question 54

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 55

​
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 56

If uncontrolled,what can lead to data anomalies?​

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

Question 57

​
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 58

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 59

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

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

Question 60

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 61

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

Question 62

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 63

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 64

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

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

Question 65

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 66

Which of the following can lead to partial dependencies?​

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

Question 67

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 68

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 69

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 70

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 71

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 72

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 73

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 74

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 75

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 76

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

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

Question 77

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 78

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 79

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 80

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