Question 1

A foreign key is essential in relational databases to represent the relationship between two tables.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  The easiest time to change the database structure is during the data modeling stage. 
B)  Changing a relationship from 1:N to N:M in an existing database is simply a matter of changing 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 easiest time to change the database structure is during the data modeling stage. 
B)  Changing a relationship from 1:N to N:M in an existing database is simply a matter of changing 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 refers to the problem that exists in database applications when two users modify the same data item,but only one of those changes is recorded?

Accepted Answer

A)  lost update problem 
B)  crow's foot paradigm 
C)  bullwhip effect 
D)  update query problem 
A)  lost update problem 
B)  crow's foot paradigm 
C)  bullwhip effect 
D)  update query problem

Question 4

A user does not need user account credentials to access and process a database.

Accepted Answer

A) True 
 B)False

Question 5

An administrator should create a ________ 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 6

An example of a byte is a character of data.

Accepted Answer

A) True 
 B)False

Question 7

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 8

Relational DBMS are the workhorse of the information systems industry today and likely will be for many years to come.

Accepted Answer

A) True 
 B)False

Question 9

________ is the process of converting a data model into tables,relationships,and data constraints.

Accepted Answer

A)  Database design 
B)  Database querying 
C)  Data mining 
D)  Database aggregation 
A)  Database design 
B)  Database querying 
C)  Data mining 
D)  Database aggregation

Question 10

________ is both a DBMS and an application development product.

Accepted Answer

A)  Paradox 
B)  Access 
C)  Enterprise DBMS 
D)  IBM's DB2 
A)  Paradox 
B)  Access 
C)  Enterprise DBMS 
D)  IBM's DB2

Question 11

A(n)________ is a search request for data from a database.

Accepted Answer

A)  form 
B)  report 
C)  query 
D)  application 
A)  form 
B)  report 
C)  query 
D)  application

Question 12

________ are used by users to read,insert,modify,and delete data in a database.

Accepted Answer

A)  Reports 
B)  Forms 
C)  Queries 
D)  DBMSs 
A)  Reports 
B)  Forms 
C)  Queries 
D)  DBMSs

Question 13

Which of the following is an international standard language for processing a database?

Accepted Answer

A)  Cassandra 
B)  DB2 
C)  SQL 
D)  MS Access 
A)  Cassandra 
B)  DB2 
C)  SQL 
D)  MS Access

Question 14

When using the relational model to represent two tables,one must ________.

Accepted Answer

A)  add a foreign key to one of the tables 
B)  have more than two identifiers in the model 
C)  establish only N:M relationships between the tables 
D)  use metadata instead of foreign keys 
A)  add a foreign key to one of the tables 
B)  have more than two identifiers in the model 
C)  establish only N:M relationships between the tables 
D)  use metadata instead of foreign keys

Question 15

What are the steps involved in transforming a data model into a relational database design?

Accepted Answer

First,the database designer creates a ta

Question 16

Summarize the database design process.

Accepted Answer

Interviews with users lead to database r

Question 17

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

Accepted Answer

A)  MS Excel 
B)  Big Data 
C)  SQL Server 
D)  Access 
A)  MS Excel 
B)  Big Data 
C)  SQL Server 
D)  Access

Question 18

Describe a DBMS and its functions.List some of the popular DBMS products.

Accepted Answer

A database management system (DBMS)is a

Question 19

Multi-user processing is common and generally problem free.

Accepted Answer

A) True 
 B)False

Question 20

Constraints on the number of entities in a relationship are called ________ cardinalities.

Accepted Answer

A)  specific 
B)  minimum 
C)  primary 
D)  critical 
A)  specific 
B)  minimum 
C)  primary 
D)  critical

A foreign key is essential in relational databases to represent the relationship between two tables.

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

Which of the following refers to the problem that exists in database applications when two users modify the same data item,but only one of those changes is recorded?

A user does not need user account credentials to access and process a database.

An administrator should create a ________ before developing a database design.

An example of a byte is a character of data.

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 DBMS are the workhorse of the information systems industry today and likely will be for many years to come.

________ is the process of converting a data model into tables,relationships,and data constraints.

________ is both a DBMS and an application development product.

A(n)________ is a search request for data from a database.

________ are used by users to read,insert,modify,and delete data in a database.

Which of the following is an international standard language for processing a database?

When using the relational model to represent two tables,one must ________.

What are the steps involved in transforming a data model into a relational database design?

Summarize the database design process.

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

Describe a DBMS and its functions.List some of the popular DBMS products.

Multi-user processing is common and generally problem free.

Constraints on the number of entities in a relationship are called ________ cardinalities.

The Importance of MIS

Business Processes, Information Systems, and Information

Networks and the Cloud

Information Systems Security

Using Is to Improve Processes

Supporting Processes With ERP Systems

Supporting the Procurement Process With SAP

Supporting the Sales Process With SAP

Collaboration and IS

Social Media and IS

Business Intelligence and IS

Filters

Exam 4: Database Processing

A foreign key is essential in relational databases to represent the relationship between two tables.

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

Which of the following refers to the problem that exists in database applications when two users modify the same data item,but only one of those changes is recorded?

A user does not need user account credentials to access and process a database.

An administrator should create a ________ before developing a database design.

An example of a byte is a character of data.

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 DBMS are the workhorse of the information systems industry today and likely will be for many years to come.

________ is the process of converting a data model into tables,relationships,and data constraints.

________ is both a DBMS and an application development product.

A(n)________ is a search request for data from a database.

________ are used by users to read,insert,modify,and delete data in a database.

Which of the following is an international standard language for processing a database?

When using the relational model to represent two tables,one must ________.

What are the steps involved in transforming a data model into a relational database design?

Summarize the database design process.

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

Describe a DBMS and its functions.List some of the popular DBMS products.

Multi-user processing is common and generally problem free.

Constraints on the number of entities in a relationship are called ________ cardinalities.

The Importance of MIS

Business Processes, Information Systems, and Information

Networks and the Cloud

Information Systems Security

Using Is to Improve Processes

Supporting Processes With ERP Systems

Supporting the Procurement Process With SAP

Supporting the Sales Process With SAP

Collaboration and IS

Social Media and IS

Business Intelligence and IS

Filters