Question 1

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

Accepted Answer

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

Question 2

A many-to-many (N:M)relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Accepted Answer

A) True 
 B)False

Question 3

In a database,when data items disagree with one another,it leads to a(n)________.

Accepted Answer

A)  data integrity problem 
B)  crow's-foot paradigm 
C)  adaptation conflict 
D)  lost-update problem 
A)  data integrity problem 
B)  crow's-foot paradigm 
C)  adaptation conflict 
D)  lost-update problem

Question 4

The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.

Accepted Answer

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

Question 5

A DBMS and database mean the same thing and are synonymous terms that can be used interchangeably.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A database management system (DBMS)is a

Question 7

Which of the following is true of N:M relationships?

Accepted Answer

A)  They are the same as N:N relationships. 
B)  They represent minimum cardinalities in a relationship. 
C)  They are also called one-to-many relationships. 
D)  They can have more than one entity on each side of the relationship. 
A)  They are the same as N:N relationships. 
B)  They represent minimum cardinalities in a relationship. 
C)  They are also called one-to-many relationships. 
D)  They can have more than one entity on each side of the relationship.

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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 11

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Accepted Answer

A) True 
 B)False

Question 12

A ________ is a collection of forms,reports,queries,and programs that serves as an intermediary between users and database data.

Accepted Answer

A)  database application 
B)  database design 
C)  data field 
D)  data model 
A)  database application 
B)  database design 
C)  data field 
D)  data model

Question 13

The general goal of normalization is to construct tables such that every table has a single topic or theme.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

A data model is a ________.

Accepted Answer

A)  logical representation of database data 
B)  repository of unprocessed data 
C)  collection of isolated databases 
D)  set of programs used to retrieve data 
A)  logical representation of database data 
B)  repository of unprocessed data 
C)  collection of isolated databases 
D)  set of programs used to retrieve data

Question 16

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.She should use a ________ to obtain the information that she wants from the database.

Accepted Answer

A)  report 
B)  data model 
C)  database administrative function 
D)  query 
A)  report 
B)  data model 
C)  database administrative function 
D)  query

Question 17

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

Accepted Answer

A) True 
 B)False

Question 18

Special data that describes the structure of a database is called metadata.

Accepted Answer

A) True 
 B)False

Question 19

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 
A)  small oval 
B)  vertical bar 
C)  arrow 
D)  triangular block

Question 20

Explain the role of users in the database development process.

Accepted Answer

A database is a model of how the users v

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

A many-to-many (N:M)relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

In a database,when data items disagree with one another,it leads to a(n)________.

The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.

A DBMS and database mean the same thing and are synonymous terms that can be used interchangeably.

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

Which of the following is true of N:M relationships?

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

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 an international standard language for processing a database?

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

A ________ is a collection of forms,reports,queries,and programs that serves as an intermediary between users and database data.

The general goal of normalization is to construct tables such that every table has a single topic or theme.

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

A data model is a ________.

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.She should use a ________ to obtain the information that she wants from the database.

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

Special data that describes the structure of a database is called metadata.

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

Explain the role of users in the database development process.

The Importance of Mis

Business Processes, information Systems, and Information

Hardware, software, and Networks

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

Mis Management Processes: Process Management, systems Development, and Security

Filters

Exam 4: Database Processing

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

A many-to-many (N:M)relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

In a database,when data items disagree with one another,it leads to a(n)________.

The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.

A DBMS and database mean the same thing and are synonymous terms that can be used interchangeably.

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

Which of the following is true of N:M relationships?

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

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 an international standard language for processing a database?

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

A ________ is a collection of forms,reports,queries,and programs that serves as an intermediary between users and database data.

The general goal of normalization is to construct tables such that every table has a single topic or theme.

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

A data model is a ________.

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.She should use a ________ to obtain the information that she wants from the database.

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

Special data that describes the structure of a database is called metadata.

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

Explain the role of users in the database development process.

The Importance of Mis

Business Processes, information Systems, and Information

Hardware, software, and Networks

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

Mis Management Processes: Process Management, systems Development, and Security

Filters