Question 1

Metadata refers to entities of a database that users want to process.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is true of MySQL?

Accepted Answer

A)  It is offered by Microsoft. 
B)  It is license-free for most applications. 
C)  It is a closed-source database product. 
D)  It is yet to be widely adopted. 
A)  It is offered by Microsoft. 
B)  It is license-free for most applications. 
C)  It is a closed-source database product. 
D)  It is yet to be widely adopted.

Question 3

What is a database application?

Accepted Answer

A database application is a collection o

Question 4

Brad,a project manager,wants to build a database to integrate information about employees and tasks that they handle.Brad wants to track information such as task name,percentage completed,and employee name.These aspects that Brad wants to track are called ________.

Accepted Answer

A)  identifiers 
B)  records 
C)  primary keys 
D)  entities 
A)  identifiers 
B)  records 
C)  primary keys 
D)  entities

Question 5

________ is the process of converting a poorly structured table into two or more well-structured tables.

Accepted Answer

A)  Optimization 
B)  Normalization 
C)  Refactoring 
D)  Standardization 
A)  Optimization 
B)  Normalization 
C)  Refactoring 
D)  Standardization

Question 6

Define primary key,foreign key,and relational databases:

Accepted Answer

A primary key is a column or group of co

Question 7

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 8

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

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 9

Each table in a database must have two or more primary keys.

Accepted Answer

A) True 
 B)False

Question 10

A spreadsheet can be used to store data if the structure of a list is simple.

Accepted Answer

A) True 
 B)False

Question 11

Relational databases are databases that are not an organized format.

Accepted Answer

A) True 
 B)False

Question 12

Today,there are many personal DBMS products available including Paradox,dBase,rBase,and Fox-Pro.

Accepted Answer

A) True 
 B)False

Question 13

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 14

Explain the role of users in the database development process.

Accepted Answer

A database is a model of how the users v

Question 15

Developers generally construct a logical representation of database data,called a data model,after building a database.

Accepted Answer

A) True 
 B)False

Question 16

SQL is an international standard language for processing a database.

Accepted Answer

A) True 
 B)False

Question 17

A group of similar rows or records in a table is called a field.

Accepted Answer

A) True 
 B)False

Question 18

A database is best described as a collection of unrelated tables.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

The rows in a database are called ________.

Accepted Answer

A)  records 
B)  tables 
C)  files 
D)  fields 
A)  records 
B)  tables 
C)  files 
D)  fields

Metadata refers to entities of a database that users want to process.

Which of the following is true of MySQL?

What is a database application?

Brad,a project manager,wants to build a database to integrate information about employees and tasks that they handle.Brad wants to track information such as task name,percentage completed,and employee name.These aspects that Brad wants to track are called ________.

________ is the process of converting a poorly structured table into two or more well-structured tables.

Define primary key,foreign key,and relational databases:

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

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

Each table in a database must have two or more primary keys.

A spreadsheet can be used to store data if the structure of a list is simple.

Relational databases are databases that are not an organized format.

Today,there are many personal DBMS products available including Paradox,dBase,rBase,and Fox-Pro.

Relational databases represent relationships using ____________.

Explain the role of users in the database development process.

Developers generally construct a logical representation of database data,called a data model,after building a database.

SQL is an international standard language for processing a database.

A group of similar rows or records in a table is called a field.

A database is best described as a collection of unrelated tables.

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

The rows in a database are called ________.

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

Metadata refers to entities of a database that users want to process.

Which of the following is true of MySQL?

What is a database application?

Brad,a project manager,wants to build a database to integrate information about employees and tasks that they handle.Brad wants to track information such as task name,percentage completed,and employee name.These aspects that Brad wants to track are called ________.

________ is the process of converting a poorly structured table into two or more well-structured tables.

Define primary key,foreign key,and relational databases:

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

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

Each table in a database must have two or more primary keys.

A spreadsheet can be used to store data if the structure of a list is simple.

Relational databases are databases that are not an organized format.

Today,there are many personal DBMS products available including Paradox,dBase,rBase,and Fox-Pro.

Relational databases represent relationships using ____________.

Explain the role of users in the database development process.

Developers generally construct a logical representation of database data,called a data model,after building a database.

SQL is an international standard language for processing a database.

A group of similar rows or records in a table is called a field.

A database is best described as a collection of unrelated tables.

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

The rows in a database are called ________.

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