Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

Which of the following is True of single-user databases?

Accepted Answer

A)  They are displayed and processed using html5, css3, and JavaScript. 
B)  They use JavaScript for user-side processing. 
C)  The Internet is used to access the DBMS server computer. 
D)  The application, the DBMS, and the database all reside on the user's computer. 
A)  They are displayed and processed using html5, css3, and JavaScript. 
B)  They use JavaScript for user-side processing. 
C)  The Internet is used to access the DBMS server computer. 
D)  The application, the DBMS, and the database all reside on the user's computer.

Question 5

Describe database management system and the functions provided by DBMS. List some of the popular DBMS products.

Accepted Answer

A database management system (DBMS)is a

Question 6

The accuracy of a database design is not dependent on the corresponding data model.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following data elements is placed higher than records in the database hierarchy?

Accepted Answer

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

Question 8

The data integrity problem occurs only if data are duplicated.

Accepted Answer

A) True 
 B)False

Question 9

The process of normalization constructs tables such that every table has a ________.

Accepted Answer

A)  one-to-one relationship between entities 
B)  single theme 
C)  foreign key 
D)  specialized graphical query 
A)  one-to-one relationship between entities 
B)  single theme 
C)  foreign key 
D)  specialized graphical query

Question 10

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 11

A database is used instead of a spreadsheet when ________.

Accepted Answer

A)  lists of data involve a single theme 
B)  structures of data lists are simple 
C)  lists involve data with multiple themes 
D)  users do not want to store all data in one place 
A)  lists of data involve a single theme 
B)  structures of data lists are simple 
C)  lists involve data with multiple themes 
D)  users do not want to store all data in one place

Question 12

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

A line in an entity-relationship (E-R) diagram is used to represent the attributes of an entity.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Explain the different types of database applications.

Accepted Answer

Database applications fall into two broa

Question 16

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 17

A data integrity problem will occur only if ________.

Accepted Answer

A)  a database has multiple administrators 
B)  data are duplicated in a database 
C)  the database is very complex 
D)  there are complex relationships between entities in a database 
A)  a database has multiple administrators 
B)  data are duplicated in a database 
C)  the database is very complex 
D)  there are complex relationships between entities in a database

Question 18

Minimum cardinalities represent the lower limit on the number of entities required in a relationship.

Accepted Answer

A) True 
 B)False

Question 19

Identify the type of task performed by a database administrator when validating the data model to be used in a database management system.

Accepted Answer

A)  development 
B)  adaptation 
C)  backup and recovery 
D)  operation 
A)  development 
B)  adaptation 
C)  backup and recovery 
D)  operation

Question 20

An administrator should create a ________ before developing the 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

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

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

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

Which of the following is True of single-user databases?

Describe database management system and the functions provided by DBMS. List some of the popular DBMS products.

The accuracy of a database design is not dependent on the corresponding data model.

Which of the following data elements is placed higher than records in the database hierarchy?

The data integrity problem occurs only if data are duplicated.

The process of normalization constructs tables such that every table has a ________.

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

A database is used instead of a spreadsheet when ________.

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

A line in an entity-relationship (E-R) diagram is used to represent the attributes of an entity.

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

Explain the different types of database applications.

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

A data integrity problem will occur only if ________.

Minimum cardinalities represent the lower limit on the number of entities required in a relationship.

Identify the type of task performed by a database administrator when validating the data model to be used in a database management system.

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

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware, Software, and Mobile Systems

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Filters

Exam 5: Database Processing

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

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

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

Which of the following is True of single-user databases?

Describe database management system and the functions provided by DBMS. List some of the popular DBMS products.

The accuracy of a database design is not dependent on the corresponding data model.

Which of the following data elements is placed higher than records in the database hierarchy?

The data integrity problem occurs only if data are duplicated.

The process of normalization constructs tables such that every table has a ________.

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

A database is used instead of a spreadsheet when ________.

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

A line in an entity-relationship (E-R) diagram is used to represent the attributes of an entity.

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

Explain the different types of database applications.

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

A data integrity problem will occur only if ________.

Minimum cardinalities represent the lower limit on the number of entities required in a relationship.

Identify the type of task performed by a database administrator when validating the data model to be used in a database management system.

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

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware, Software, and Mobile Systems

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Filters