Question 1

The database administrator of an organization constantly manages the processing rights and responsibilities of employees.This is an example of a(n)________ task.

Accepted Answer

A)  development 
B)  recovery 
C)  adaptation 
D)  operational 
A)  development 
B)  recovery 
C)  adaptation 
D)  operational

Question 2

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

Accepted Answer

A)  The database structure cannot be changed during the data modeling stage. 
B)  Changing a relationship from 1:N to N:M is simply a matter of changing the notations. 
C)  User review of the data model is avoided as it is not helpful in data modeling. 
D)  A database is a model of how the developers view their business world. 
A)  The database structure cannot be changed during the data modeling stage. 
B)  Changing a relationship from 1:N to N:M is simply a matter of changing the notations. 
C)  User review of the data model is avoided as it is not helpful in data modeling. 
D)  A database is a model of how the developers view their business world.

Question 3

Which of the following is a nonrelational data store developed by Facebook?

Accepted Answer

A)  Cassandra 
B)  Dynamo 
C)  Bigtable 
D)  SharePoint 
A)  Cassandra 
B)  Dynamo 
C)  Bigtable 
D)  SharePoint

Question 4

An administrator should create a(n)________ before developing a database design.

Accepted Answer

A)  data aggregator 
B)  query model 
C)  data model 
D)  data application 
A)  data aggregator 
B)  query model 
C)  data model 
D)  data application

Question 5

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year.After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants.

Accepted Answer

A)  report 
B)  reference 
C)  data entry 
D)  query 
A)  report 
B)  reference 
C)  data entry 
D)  query

Question 6

Describe the elements of a data model.Provide examples.

Accepted Answer

An entity is something that the users wa

Question 7

Some type of locking must be used to coordinate the activities of users who know nothing about one another in order to prevent the lost-update problem.

Accepted Answer

A) True 
 B)False

Question 8

Google developed a nonrelational data store called Dynamo.

Accepted Answer

A) True 
 B)False

Question 9

In an E-R diagram, an entity is represented by a single triangle and the relationships between entities are represented by dotted lines.

Accepted Answer

A) True 
 B)False

Question 10

A database is a self-describing collection of integrated records.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is a nonrelational data store developed by Amazon?

Accepted Answer

A)  Cassandra 
B)  Dynamo 
C)  SharePoint 
D)  Bigtable 
A)  Cassandra 
B)  Dynamo 
C)  SharePoint 
D)  Bigtable

Question 12

Which of the following types of DBMS products is designed for smaller and simpler database applications?

Accepted Answer

A)  object-oriented DBMS 
B)  strategic DBMS 
C)  personal DBMS 
D)  enterprise DBMS 
A)  object-oriented DBMS 
B)  strategic DBMS 
C)  personal DBMS 
D)  enterprise DBMS

Question 13

Which of the following data elements is placed higher than records in the data hierarchy?

Accepted Answer

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

Question 14

The format of metadata depends on the software product that is processing the database.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

Accepted Answer

A)  vertical bar 
B)  arrow 
C)  double line 
D)  small oval 
A)  vertical bar 
B)  arrow 
C)  double line 
D)  small oval

Question 16

Relational databases represent relationships using ________.

Accepted Answer

A)  foreign keys 
B)  file systems 
C)  metadata 
D)  unique identifiers 
A)  foreign keys 
B)  file systems 
C)  metadata 
D)  unique identifiers

Question 17

The crow's-foot notation of an E-R diagram shows the maximum number of entities that can be involved in a relationship.

Accepted Answer

A) True 
 B)False

Question 18

To modify an existing table, a developer opens the metadata form for that table and adds a new row of metadata.

Accepted Answer

A) True 
 B)False

Question 19

Developers need to construct a data model before building a database.

Accepted Answer

A) True 
 B)False

Question 20

Every table in a normalized database has a(n)________.

Accepted Answer

A)  duplicated data model 
B)  single theme 
C)  maximum cardinality 
D)  specialized query format 
A)  duplicated data model 
B)  single theme 
C)  maximum cardinality 
D)  specialized query format

The database administrator of an organization constantly manages the processing rights and responsibilities of employees.This is an example of a(n)________ task.

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

Which of the following is a nonrelational data store developed by Facebook?

An administrator should create a(n)________ before developing a database design.

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year.After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants.

Describe the elements of a data model.Provide examples.

Some type of locking must be used to coordinate the activities of users who know nothing about one another in order to prevent the lost-update problem.

Google developed a nonrelational data store called Dynamo.

In an E-R diagram, an entity is represented by a single triangle and the relationships between entities are represented by dotted lines.

A database is a self-describing collection of integrated records.

Which of the following is a nonrelational data store developed by Amazon?

Which of the following types of DBMS products is designed for smaller and simpler database applications?

Which of the following data elements is placed higher than records in the data hierarchy?

The format of metadata depends on the software product that is processing the database.

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

Relational databases represent relationships using ________.

The crow's-foot notation of an E-R diagram shows the maximum number of entities that can be involved in a relationship.

To modify an existing table, a developer opens the metadata form for that table and adds a new row of metadata.

Developers need to construct a data model before building a database.

Every table in a normalized database has a(n)________.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Structured Processes and Information Systems

Social Media Information Systems

Business Intelligence Systems

Business Process and Information Systems Development

Information Systems Management

Information Security Management

The International Dimension

Filters

Exam 5: Database Processing

The database administrator of an organization constantly manages the processing rights and responsibilities of employees.This is an example of a(n)________ task.

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

Which of the following is a nonrelational data store developed by Facebook?

An administrator should create a(n)________ before developing a database design.

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year.After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants.

Describe the elements of a data model.Provide examples.

Some type of locking must be used to coordinate the activities of users who know nothing about one another in order to prevent the lost-update problem.

Google developed a nonrelational data store called Dynamo.

In an E-R diagram, an entity is represented by a single triangle and the relationships between entities are represented by dotted lines.

A database is a self-describing collection of integrated records.

Which of the following is a nonrelational data store developed by Amazon?

Which of the following types of DBMS products is designed for smaller and simpler database applications?

Which of the following data elements is placed higher than records in the data hierarchy?

The format of metadata depends on the software product that is processing the database.

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

Relational databases represent relationships using ________.

The crow's-foot notation of an E-R diagram shows the maximum number of entities that can be involved in a relationship.

To modify an existing table, a developer opens the metadata form for that table and adds a new row of metadata.

Developers need to construct a data model before building a database.

Every table in a normalized database has a(n)________.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Structured Processes and Information Systems

Social Media Information Systems

Business Intelligence Systems

Business Process and Information Systems Development

Information Systems Management

Information Security Management

The International Dimension

Filters