Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

An identifier is an attribute or a group of attributes whose value is associated with one, and only one, entity instance.

Accepted Answer

A) True 
 B)False

Question 3

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Accepted Answer

A) Administrators 
B) Developers 
C) Users 
D) Designers 
A) Administrators 
B) Developers 
C) Users 
D) Designers

Question 4

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

Accepted Answer

A) The number of entities on each side must be equal. 
B) They are common examples of minimum cardinalities. 
C) They are also called one-to-many relationships. 
D) They can have more than one entity on each side of the relationship. 
A) The number of entities on each side must be equal. 
B) They are common examples of minimum cardinalities. 
C) They are also called one-to-many relationships. 
D) They can have more than one entity on each side of the relationship.

Question 5

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) primary record 
A) primary key 
B) identifier 
C) foreign key 
D) primary record

Question 6

Which of the following is a nonrelational data store developed by Facebook?

Accepted Answer

A) Cassandra 
B) Dynamo 
C) Bigtable 
D) SharePoint 
A) Cassandra 
B) Dynamo 
C) Bigtable 
D) SharePoint

Question 7

Which of the following database administration tasks is related to adaptation?

Accepted Answer

A) monitoring backup procedures 
B) conducting training for users 
C) monitoring database performance 
D) managing configuration changes in systems 
A) monitoring backup procedures 
B) conducting training for users 
C) monitoring database performance 
D) managing configuration changes in systems

Question 8

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 9

A data integrity problem will occur only if ________.

Accepted Answer

A) there are multiple administrators 
B) data are duplicated 
C) the database is very large 
D) there are complex relationships 
A) there are multiple administrators 
B) data are duplicated 
C) the database is very large 
D) there are complex relationships

Question 10

A drawback of DBMS programs is that they do not provide comprehensive and robust features for querying database data.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is a nonrelational data store developed by Google?

Accepted Answer

A) Cassandra 
B) Dynamo 
C) SharePoint 
D) Bigtable 
A) Cassandra 
B) Dynamo 
C) SharePoint 
D) Bigtable

Question 12

MySQL is an open source DBMS product which is license-free for most database applications.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following types of DBMS products is designed for smaller and simpler database applications?

Accepted Answer

A) object-oriented DBMS 
B) strategic DBMS 
C) personal DBMS 
D) enterprise DBMS 
A) object-oriented DBMS 
B) strategic DBMS 
C) personal DBMS 
D) enterprise DBMS

Question 14

A key is a column or group of columns that identifies a unique row in a table.

Accepted Answer

A) True 
 B)False

Question 15

A(n)________ is a program used to create, process, and administer a database.

Accepted Answer

A) operating system 
B) DBMS 
C) KMS 
D) data mart 
A) operating system 
B) DBMS 
C) KMS 
D) data mart

Question 16

Minimum cardinalities are a measure of the constraints on the number of entities required in a relationship.

Accepted Answer

A) True 
 B)False

Question 17

A(n)________ DBMS is designed to process large organizational and workgroup databases.

Accepted Answer

A) operational 
B) process 
C) personal 
D) enterprise 
A) operational 
B) process 
C) personal 
D) enterprise

Question 18

Microsoft Access is both a DBMS and an application development product.

Accepted Answer

A) True 
 B)False

Question 19

The small oval on a line in an E-R diagram means that the entity is optional.

Accepted Answer

A) True 
 B)False

Question 20

The columns in a database are called ________.

Accepted Answer

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

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

An identifier is an attribute or a group of attributes whose value is associated with one, and only one, entity instance.

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

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

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

Which of the following is a nonrelational data store developed by Facebook?

Which of the following database administration tasks is related to adaptation?

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

A data integrity problem will occur only if ________.

A drawback of DBMS programs is that they do not provide comprehensive and robust features for querying database data.

Which of the following is a nonrelational data store developed by Google?

MySQL is an open source DBMS product which is license-free for most database applications.

Which of the following types of DBMS products is designed for smaller and simpler database applications?

A key is a column or group of columns that identifies a unique row in a table.

A(n)________ is a program used to create, process, and administer a database.

Minimum cardinalities are a measure of the constraints on the number of entities required in a relationship.

A(n)________ DBMS is designed to process large organizational and workgroup databases.

Microsoft Access is both a DBMS and an application development product.

The small oval on a line in an E-R diagram means that the entity is optional.

The columns in a database are called ________.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters

Exam 5: Database Processing

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

An identifier is an attribute or a group of attributes whose value is associated with one, and only one, entity instance.

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

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

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

Which of the following is a nonrelational data store developed by Facebook?

Which of the following database administration tasks is related to adaptation?

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

A data integrity problem will occur only if ________.

A drawback of DBMS programs is that they do not provide comprehensive and robust features for querying database data.

Which of the following is a nonrelational data store developed by Google?

MySQL is an open source DBMS product which is license-free for most database applications.

Which of the following types of DBMS products is designed for smaller and simpler database applications?

A key is a column or group of columns that identifies a unique row in a table.

A(n)________ is a program used to create, process, and administer a database.

Minimum cardinalities are a measure of the constraints on the number of entities required in a relationship.

A(n)________ DBMS is designed to process large organizational and workgroup databases.

Microsoft Access is both a DBMS and an application development product.

The small oval on a line in an E-R diagram means that the entity is optional.

The columns in a database are called ________.

The Importance of MIS

Collaboration Information Systems

Strategy and Information Systems

Hardware and Software

Data Communication and the Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Development Processes

Information Systems Management

Information Security Management

The International Dimension

Filters