Question 1

Database development begins with ________, which establishes the range and general contents of organizational databases.

Accepted Answer

A)  database design 
B)  cross-functional analysis 
C)  departmental data modeling 
D)  enterprise data modeling 
A)  database design 
B)  cross-functional analysis 
C)  departmental data modeling 
D)  enterprise data modeling D

Question 2

A knowledge base of information or facts about an enterprise is called a(n):

Accepted Answer

A)  enterprise information system. 
B)  repository. 
C)  systems information unit. 
D)  database process. 
A)  enterprise information system. 
B)  repository. 
C)  systems information unit. 
D)  database process. B

Question 3

A graphical system used to capture the nature and relationships among data is called a(n):

Accepted Answer

A)  XML data model. 
B)  hypertext graphic. 
C)  relational database. 
D)  data model. 
A)  XML data model. 
B)  hypertext graphic. 
C)  relational database. 
D)  data model. D

Question 4

A person is an example of an entity.

Accepted Answer

A) True 
 B)False

Question 5

Organizational commitment to a database project is not necessary for its success.

Accepted Answer

A) True 
 B)False

Question 6

The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase.

Accepted Answer

A)  planning 
B)  design 
C)  analysis 
D)  implementation 
A)  planning 
B)  design 
C)  analysis 
D)  implementation

Question 7

Database maintenance is typically the longest step of the database development process.

Accepted Answer

A) True 
 B)False

Question 8

The user interface includes languages, menus, and other facilities by which users interact with various system components.

Accepted Answer

A) True 
 B)False

Question 9

Because applications are often developed independently in file processing systems:

Accepted Answer

A)  the data is always non-redundant. 
B)  unplanned duplicate data files are the rule rather than the exception. 
C)  data can always be shared with others. 
D)  there is a large volume of file I/O. 
A)  the data is always non-redundant. 
B)  unplanned duplicate data files are the rule rather than the exception. 
C)  data can always be shared with others. 
D)  there is a large volume of file I/O.

Question 10

An enterprise data model describes the scope of data for only one information system.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is NOT an objective that drove the development and evolution of database technology?

Accepted Answer

A)  The need to provide greater independence between programs and data. 
B)  The desire to manage increasing complex data types and structures. 
C)  The desire to require programmers to write all file handling functionality. 
D)  The need to provide ever more powerful platforms for decision support applications. 
A)  The need to provide greater independence between programs and data. 
B)  The desire to manage increasing complex data types and structures. 
C)  The desire to require programmers to write all file handling functionality. 
D)  The need to provide ever more powerful platforms for decision support applications.

Question 12

A relational database establishes the relationships between entities by means of a common field.

Accepted Answer

A) True 
 B)False

Question 13

The data repository assists database administrators in enforcing standards.

Accepted Answer

A) True 
 B)False

Question 14

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

Accepted Answer

A)  entity. 
B)  relationship. 
C)  relation. 
D)  association. 
A)  entity. 
B)  relationship. 
C)  relation. 
D)  association.

Question 15

File processing systems have been replaced by database systems in most critical business applications today.

Accepted Answer

A) True 
 B)False

Question 16

Discuss who is involved in the database development process.

Accepted Answer

There are many different types of indivi

Question 17

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):

Accepted Answer

A)  index. 
B)  data warehouse. 
C)  repository. 
D)  database management system. 
A)  index. 
B)  data warehouse. 
C)  repository. 
D)  database management system.

Question 18

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

Accepted Answer

A)  relationship. 
B)  object. 
C)  attribute. 
D)  entity. 
A)  relationship. 
B)  object. 
C)  attribute. 
D)  entity.

Question 19

The term legacy system refers to a newly installed database management system.

Accepted Answer

A) True 
 B)False

Question 20

Separation of metadata from application programs that use the data is called data independence.

Accepted Answer

A) True 
 B)False

Database development begins with ________, which establishes the range and general contents of organizational databases.

A knowledge base of information or facts about an enterprise is called a(n):

A graphical system used to capture the nature and relationships among data is called a(n):

A person is an example of an entity.

Organizational commitment to a database project is not necessary for its success.

The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase.

Database maintenance is typically the longest step of the database development process.

The user interface includes languages, menus, and other facilities by which users interact with various system components.

Because applications are often developed independently in file processing systems:

An enterprise data model describes the scope of data for only one information system.

Which of the following is NOT an objective that drove the development and evolution of database technology?

A relational database establishes the relationships between entities by means of a common field.

The data repository assists database administrators in enforcing standards.

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

File processing systems have been replaced by database systems in most critical business applications today.

Discuss who is involved in the database development process.

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

The term legacy system refers to a newly installed database management system.

Separation of metadata from application programs that use the data is called data independence.

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 1: The Database Environment and Development Process

Database development begins with ________, which establishes the range and general contents of organizational databases.

A knowledge base of information or facts about an enterprise is called a(n):

A graphical system used to capture the nature and relationships among data is called a(n):

A person is an example of an entity.

Organizational commitment to a database project is not necessary for its success.

The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase.

Database maintenance is typically the longest step of the database development process.

The user interface includes languages, menus, and other facilities by which users interact with various system components.

Because applications are often developed independently in file processing systems:

An enterprise data model describes the scope of data for only one information system.

Which of the following is NOT an objective that drove the development and evolution of database technology?

A relational database establishes the relationships between entities by means of a common field.

The data repository assists database administrators in enforcing standards.

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

File processing systems have been replaced by database systems in most critical business applications today.

Discuss who is involved in the database development process.

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

The term legacy system refers to a newly installed database management system.

Separation of metadata from application programs that use the data is called data independence.

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters