Question 1

When you modify or delete data present in a database,you are ________.

Accepted Answer

A)  creating a new database 
B)  forming a data model 
C)  simplifying the data structure 
D)  processing the database 
A)  creating a new database 
B)  forming a data model 
C)  simplifying the data structure 
D)  processing the database

Question 2

In a data model,a(n)________ is something that a user wants to track.

Accepted Answer

A)  record 
B)  byte 
C)  entity 
D)  primary key 
A)  record 
B)  byte 
C)  entity 
D)  primary key

Question 3

________ in an E-R diagram refer to the least number of entities required in a relationship.

Accepted Answer

A)  One-to-one relationships 
B)  Primary keys 
C)  Foreign keys 
D)  Minimum cardinalities 
A)  One-to-one relationships 
B)  Primary keys 
C)  Foreign keys 
D)  Minimum cardinalities

Question 4

Reports show data in a structured context.

Accepted Answer

A) True 
 B)False

Question 5

Most database applications meet all requirements for business needs.

Accepted Answer

A) True 
 B)False

Question 6

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 7

The purpose of a database is to keep track of things that involve a single theme.

Accepted Answer

A) True 
 B)False

Question 8

The easiest time to change the database structure is after the data modeling stage.

Accepted Answer

A) True 
 B)False

Question 9

Albert creates a relational database to store employee performance statistics.He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee.This column is referred to as a(n)________.

Accepted Answer

A)  primary key 
B)  identifier 
C)  foreign key 
D)  functionally dependent record 
A)  primary key 
B)  identifier 
C)  foreign key 
D)  functionally dependent record

Question 10

Columns that are keys to different tables other than the ones in which they reside are called ___________.

Accepted Answer

A)  attributes 
B)  foreign keys 
C)  primary keys 
D)  internal records 
A)  attributes 
B)  foreign keys 
C)  primary keys 
D)  internal records

Question 11

______________ products process large organizational and workgroup databases.

Accepted Answer

A)  Personal DBMS 
B)  Application Program 
C)  Enterprise DBMS 
D)  Forms and reporting 
A)  Personal DBMS 
B)  Application Program 
C)  Enterprise DBMS 
D)  Forms and reporting

Question 12

Which of the following is the smallest data element in a database?

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Data duplication is an example of a data integrity problem.

Accepted Answer

A) True 
 B)False

Question 17

A query shows the results of a search by a keyword.

Accepted Answer

A) True 
 B)False

Question 18

A data model describes data and relationships that will be stored in the database.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

When you modify or delete data present in a database,you are ________.

In a data model,a(n)________ is something that a user wants to track.

________ in an E-R diagram refer to the least number of entities required in a relationship.

Reports show data in a structured context.

Most database applications meet all requirements for business needs.

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

The purpose of a database is to keep track of things that involve a single theme.

The easiest time to change the database structure is after the data modeling stage.

Albert creates a relational database to store employee performance statistics.He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee.This column is referred to as a(n)________.

Columns that are keys to different tables other than the ones in which they reside are called ___________.

______________ products process large organizational and workgroup databases.

Which of the following is the smallest data element in a database?

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

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

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

Data duplication is an example of a data integrity problem.

A query shows the results of a search by a keyword.

A data model describes data and relationships that will be stored in the database.

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 ________.

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

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

When you modify or delete data present in a database,you are ________.

In a data model,a(n)________ is something that a user wants to track.

________ in an E-R diagram refer to the least number of entities required in a relationship.

Reports show data in a structured context.

Most database applications meet all requirements for business needs.

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

The purpose of a database is to keep track of things that involve a single theme.

The easiest time to change the database structure is after the data modeling stage.

Albert creates a relational database to store employee performance statistics.He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee.This column is referred to as a(n)________.

Columns that are keys to different tables other than the ones in which they reside are called ___________.

______________ products process large organizational and workgroup databases.

Which of the following is the smallest data element in a database?

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

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

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

Data duplication is an example of a data integrity problem.

A query shows the results of a search by a keyword.

A data model describes data and relationships that will be stored in the database.

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 ________.

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

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