Question 1

Redundancy increases the risk of inconsistent data.

Accepted Answer

A) True 
 B)False

Question 2

Personal databases are designed to support a small group of individuals working together on a project.

Accepted Answer

A) True 
 B)False

Question 3

A data warehouse derives its data from:

Accepted Answer

A)  on-line transactions. 
B)  various operational data sources. 
C)  reports. 
D)  a datamart. 
A)  on-line transactions. 
B)  various operational data sources. 
C)  reports. 
D)  a datamart.

Question 4

Data that describe the properties of other data are:

Accepted Answer

A)  relationships. 
B)  logical. 
C)  physical. 
D)  metadata. 
A)  relationships. 
B)  logical. 
C)  physical. 
D)  metadata.

Question 5

The three-schema approach includes which of the following schemas?

Accepted Answer

A)  Internal 
B)  Logical 
C)  Cross-functional 
D)  Dissecting 
A)  Internal 
B)  Logical 
C)  Cross-functional 
D)  Dissecting

Question 6

A constraint is a rule in a database system that can be violated by users.

Accepted Answer

A) True 
 B)False

Question 7

Metadata are data that describe the properties of other data.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Many of the disadvantages of file processing systems can also be limitations of databases.

Accepted Answer

A) True 
 B)False

Question 10

________ is the most popular RDMS data model notation.

Accepted Answer

A)  ERD 
B)  END 
C)  DRE 
D)  RED 
A)  ERD 
B)  END 
C)  DRE 
D)  RED

Question 11

A user view is how the user sees the data when it is produced.

Accepted Answer

A) True 
 B)False

Question 12

E. F. Codd developed the relational data model during the 1970s.

Accepted Answer

A) True 
 B)False

Question 13

Each member of a workgroup accesses data located on a database server.

Accepted Answer

A) True 
 B)False

Question 14

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.

Accepted Answer

A) True 
 B)False

Question 15

All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The most common source of database failures in organizations is:

Accepted Answer

A)  lack of planning. 
B)  inadequate budget. 
C)  inadequate hardware. 
D)  failure to implement a strong database administration function. 
A)  lack of planning. 
B)  inadequate budget. 
C)  inadequate hardware. 
D)  failure to implement a strong database administration function.

Question 18

Which of the following is NOT an advantage of database systems?

Accepted Answer

A)  Redundant data 
B)  Program-data independence 
C)  Better data quality 
D)  Reduced program maintenance 
A)  Redundant data 
B)  Program-data independence 
C)  Better data quality 
D)  Reduced program maintenance

Question 19

A workgroup database is stored on a central device called a:

Accepted Answer

A)  client. 
B)  server. 
C)  remote PC. 
D)  network. 
A)  client. 
B)  server. 
C)  remote PC. 
D)  network.

Question 20

The need for consensus on data definitions is an example of which type of risk in the database environment?

Accepted Answer

A)  Specialized personnel needs 
B)  Organizational conflict 
C)  Conversion costs 
D)  Legacy systems 
A)  Specialized personnel needs 
B)  Organizational conflict 
C)  Conversion costs 
D)  Legacy systems

Redundancy increases the risk of inconsistent data.

Personal databases are designed to support a small group of individuals working together on a project.

A data warehouse derives its data from:

Data that describe the properties of other data are:

The three-schema approach includes which of the following schemas?

A constraint is a rule in a database system that can be violated by users.

Metadata are data that describe the properties of other data.

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.

Many of the disadvantages of file processing systems can also be limitations of databases.

________ is the most popular RDMS data model notation.

A user view is how the user sees the data when it is produced.

E. F. Codd developed the relational data model during the 1970s.

Each member of a workgroup accesses data located on a database server.

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.

All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.

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

The most common source of database failures in organizations is:

Which of the following is NOT an advantage of database systems?

A workgroup database is stored on a central device called a:

The need for consensus on data definitions is an example of which type of risk in the database environment?

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 1: The Database Environment and Development Process

Redundancy increases the risk of inconsistent data.

Personal databases are designed to support a small group of individuals working together on a project.

A data warehouse derives its data from:

Data that describe the properties of other data are:

The three-schema approach includes which of the following schemas?

A constraint is a rule in a database system that can be violated by users.

Metadata are data that describe the properties of other data.

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.

Many of the disadvantages of file processing systems can also be limitations of databases.

________ is the most popular RDMS data model notation.

A user view is how the user sees the data when it is produced.

E. F. Codd developed the relational data model during the 1970s.

Each member of a workgroup accesses data located on a database server.

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory.

All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.

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

The most common source of database failures in organizations is:

Which of the following is NOT an advantage of database systems?

A workgroup database is stored on a central device called a:

The need for consensus on data definitions is an example of which type of risk in the database environment?

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters