Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Each entity in a database has a unique attribute called a(n)________.

Accepted Answer

A)  public key 
B)  identifier 
C)  foreign key 
D)  index field 
A)  public key 
B)  identifier 
C)  foreign key 
D)  index field

Question 3

Managing the impact of database structure changes on applications and users is an operational task for a database administrator.

Accepted Answer

A) True 
 B)False

Question 4

To modify an existing table,a developer can open the metadata form for that table and add a new row of metadata.

Accepted Answer

A) True 
 B)False

Question 5

NoSQL means nonrelational databases that support very high transaction rates processing relatively simple data structures,replicated on many servers in the cloud.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Question 8

Normalized tables are faster to process than tables that haven't been normalized.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Entities in a data model have ________ that describe the characteristics of the entity.

Accepted Answer

A)  characters 
B)  primary keys 
C)  codes 
D)  attributes 
A)  characters 
B)  primary keys 
C)  codes 
D)  attributes

Question 11

Normalization is the process of combining two or more tables into a single table.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Describe entities in the context of data models.

Accepted Answer

An entity is something that the users wa

Question 14

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 15

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

Accepted Answer

A)  MS Excel 
B)  BigData 
C)  NoSQL 
D)  Access 
A)  MS Excel 
B)  BigData 
C)  NoSQL 
D)  Access

Question 16

Metadata are ________.

Accepted Answer

A)  code used for server-side processing 
B)  error logs of databases 
C)  data that describe data 
D)  encrypted data transmissions 
A)  code used for server-side processing 
B)  error logs of databases 
C)  data that describe data 
D)  encrypted data transmissions

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

The accuracy of a database design is independent of the corresponding data model.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Reports refer to the structured presentation of data using sorting,grouping,filtering,and other operations.

Accepted Answer

A) True 
 B)False

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

Each entity in a database has a unique attribute called a(n)________.

Managing the impact of database structure changes on applications and users is an operational task for a database administrator.

To modify an existing table,a developer can open the metadata form for that table and add a new row of metadata.

NoSQL means nonrelational databases that support very high transaction rates processing relatively simple data structures,replicated on many servers in the cloud.

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

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

Normalized tables are faster to process than tables that haven't been normalized.

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

Entities in a data model have ________ that describe the characteristics of the entity.

Normalization is the process of combining two or more tables into a single table.

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

Describe entities in the context of data models.

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

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

Metadata are ________.

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

The accuracy of a database design is independent of the corresponding data model.

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

Reports refer to the structured presentation of data using sorting,grouping,filtering,and other operations.

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

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

Each entity in a database has a unique attribute called a(n)________.

Managing the impact of database structure changes on applications and users is an operational task for a database administrator.

To modify an existing table,a developer can open the metadata form for that table and add a new row of metadata.

NoSQL means nonrelational databases that support very high transaction rates processing relatively simple data structures,replicated on many servers in the cloud.

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

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

Normalized tables are faster to process than tables that haven't been normalized.

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

Entities in a data model have ________ that describe the characteristics of the entity.

Normalization is the process of combining two or more tables into a single table.

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

Describe entities in the context of data models.

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

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

Metadata are ________.

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

The accuracy of a database design is independent of the corresponding data model.

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

Reports refer to the structured presentation of data using sorting,grouping,filtering,and other operations.

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