Question 1

Identify the first step in transforming a data model into a relational database design.

Accepted Answer

A)  representing the entity relationships 
B)  normalizing the data and files 
C)  creating foreign keys 
D)  creating a table for each entity 
E)  creating data triggers for export 
A)  representing the entity relationships 
B)  normalizing the data and files 
C)  creating foreign keys 
D)  creating a table for each entity 
E)  creating data triggers for export

Question 2

Which of the following is True about the database development process?

Accepted Answer

A)  The database structure is easy to change during the data modeling stage. 
B)  Changing a relationship from 1:N to N:M in an existing database is a complex and lengthy process. 
C)  User review of the data model is avoided as it is not helpful in data modeling. 
D)  Databases are easier to develop than spreadsheets. 
E)  Normalization is unnecessary for large databases. 
A)  The database structure is easy to change during the data modeling stage. 
B)  Changing a relationship from 1:N to N:M in an existing database is a complex and lengthy process. 
C)  User review of the data model is avoided as it is not helpful in data modeling. 
D)  Databases are easier to develop than spreadsheets. 
E)  Normalization is unnecessary for large databases.

Question 3

Each entity in a database has a unique attribute called a(n) ________.

Accepted Answer

A)  public key 
B)  identifier 
C)  foreign key 
D)  index field 
E)  prime value 
A)  public key 
B)  identifier 
C)  foreign key 
D)  index field 
E)  prime value

Question 4

Metadata refers to special data that describes the structure of a database.

Accepted Answer

A) True 
 B)False

Question 5

Explain how a database management system processes a database.

Accepted Answer

A function of the DBMS is to process the

Question 6

Katrina is a sales representative for an online retailer. She needs to update her customer list with new contact information for five customers. Which of the following elements will help Katrina modify her data?

Accepted Answer

A)  reports 
B)  forms 
C)  queries 
D)  operations 
E)  triggers 
A)  reports 
B)  forms 
C)  queries 
D)  operations 
E)  triggers

Question 7

A foreign key is a key of a different (foreign) table than the one in which it resides.

Accepted Answer

A) True 
 B)False

Question 8

Jed is a database administrator for a mid-sized computer component manufacturer. Part of his duties include managing security, tracking problems, and monitoring the performance of the database. This is an example of Jed's ________ tasks.

Accepted Answer

A)  development 
B)  adaptation 
C)  backup and recovery 
D)  operation 
E)  data audit 
A)  development 
B)  adaptation 
C)  backup and recovery 
D)  operation 
E)  data audit

Question 9

In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.

Accepted Answer

A)  small oval 
B)  vertical bar 
C)  arrow 
D)  triangular block 
E)  wave 
A)  small oval 
B)  vertical bar 
C)  arrow 
D)  triangular block 
E)  wave

Question 10

Which of the following is an example of a database management system?

Accepted Answer

A)  MS Excel 
B)  BigData 
C)  NoSQL 
D)  Access 
E)  MS Visio 
A)  MS Excel 
B)  BigData 
C)  NoSQL 
D)  Access 
E)  MS Visio

Question 11

A line in an entity-relationship (E-R) diagram is used to represent the relationships between two entities.

Accepted Answer

A) True 
 B)False

Question 12

Entities in a data model have ________ that describe the characteristics of the entity.

Accepted Answer

A)  characters 
B)  primary keys 
C)  codes 
D)  attributes 
E)  scribes 
A)  characters 
B)  primary keys 
C)  codes 
D)  attributes 
E)  scribes

Question 13

The lost-update problem can be resolved by implementing single-user database processing.

Accepted Answer

A) True 
 B)False

Question 14

The forked lines on the lines representing relationship between two related entities are referred to as ________.

Accepted Answer

A)  identifiers 
B)  foreign keys 
C)  crow's feet 
D)  entities 
E)  switch 
A)  identifiers 
B)  foreign keys 
C)  crow's feet 
D)  entities 
E)  switch

Question 15

Identify an open source DBMS product.

Accepted Answer

A)  MySQL 
B)  DB2 
C)  Access 
D)  Oracle Database 
E)  TableOS 
A)  MySQL 
B)  DB2 
C)  Access 
D)  Oracle Database 
E)  TableOS

Question 16

The modification or deletion of data in a database is an example of ________ operations of a database management system.

Accepted Answer

A)  statistical 
B)  analytical 
C)  administrative 
D)  processing 
E)  technical 
A)  statistical 
B)  analytical 
C)  administrative 
D)  processing 
E)  technical

Question 17

The term ________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed.

Accepted Answer

A)  consistent 
B)  atomic 
C)  durable 
D)  isolated 
E)  iconic 
A)  consistent 
B)  atomic 
C)  durable 
D)  isolated 
E)  iconic

Question 18

Which of the following is a developmental task of database administration?

Accepted Answer

A)  evaluating an application design 
B)  monitoring backup procedures 
C)  conducting training for users 
D)  managing configuration changes in systems 
E)  testing backup procedures 
A)  evaluating an application design 
B)  monitoring backup procedures 
C)  conducting training for users 
D)  managing configuration changes in systems 
E)  testing backup procedures

Question 19

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.

Accepted Answer

A) True 
 B)False

Question 20

Describe entities in the context of data models.

Accepted Answer

An entity is something that the users wa

Identify the first step in transforming a data model into a relational database design.

Which of the following is True about the database development process?

Each entity in a database has a unique attribute called a(n) ________.

Metadata refers to special data that describes the structure of a database.

Explain how a database management system processes a database.

Katrina is a sales representative for an online retailer. She needs to update her customer list with new contact information for five customers. Which of the following elements will help Katrina modify her data?

A foreign key is a key of a different (foreign) table than the one in which it resides.

Jed is a database administrator for a mid-sized computer component manufacturer. Part of his duties include managing security, tracking problems, and monitoring the performance of the database. This is an example of Jed's ________ tasks.

In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.

Which of the following is an example of a database management system?

A line in an entity-relationship (E-R) diagram is used to represent the relationships between two entities.

Entities in a data model have ________ that describe the characteristics of the entity.

The lost-update problem can be resolved by implementing single-user database processing.

The forked lines on the lines representing relationship between two related entities are referred to as ________.

Identify an open source DBMS product.

The modification or deletion of data in a database is an example of ________ operations of a database management system.

The term ________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed.

Which of the following is a developmental task of database administration?

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.

Describe entities in the context of data models.

The Importance of Mis

Collaboration Information Systems

Strategy and Information Systems

Hardware, Software, and Mobile Systems

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Filters

Exam 5: Database Processing

Identify the first step in transforming a data model into a relational database design.

Which of the following is True about the database development process?

Each entity in a database has a unique attribute called a(n) ________.

Metadata refers to special data that describes the structure of a database.

Explain how a database management system processes a database.

Katrina is a sales representative for an online retailer. She needs to update her customer list with new contact information for five customers. Which of the following elements will help Katrina modify her data?

A foreign key is a key of a different (foreign) table than the one in which it resides.

Jed is a database administrator for a mid-sized computer component manufacturer. Part of his duties include managing security, tracking problems, and monitoring the performance of the database. This is an example of Jed's ________ tasks.

In an E-R diagram, a(n) ________ on a line means that at least one entity of that type is required.

Which of the following is an example of a database management system?

A line in an entity-relationship (E-R) diagram is used to represent the relationships between two entities.

Entities in a data model have ________ that describe the characteristics of the entity.

The lost-update problem can be resolved by implementing single-user database processing.

The forked lines on the lines representing relationship between two related entities are referred to as ________.

Identify an open source DBMS product.

The modification or deletion of data in a database is an example of ________ operations of a database management system.

The term ________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed.

Which of the following is a developmental task of database administration?

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.

Describe entities in the context of data models.

The Importance of Mis

Collaboration Information Systems

Strategy and Information Systems

Hardware, Software, and Mobile Systems

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Filters