Question 1

Browser-based applications ________.

Accepted Answer

A)  need to be pre-installed on the users' computers 
B)  run within a corporate network that is protected from the Internet 
C)  eliminate the need to check for data consistency 
D)  are more vulnerable to security threats than are traditional applications 
A)  need to be pre-installed on the users' computers 
B)  run within a corporate network that is protected from the Internet 
C)  eliminate the need to check for data consistency 
D)  are more vulnerable to security threats than are traditional applications

Question 2

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 3

Which of the following is an international standard language for processing a database?

Accepted Answer

A)  Cassandra 
B)  DB2 
C)  SQL 
D)  MS Access 
A)  Cassandra 
B)  DB2 
C)  SQL 
D)  MS Access

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

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

________ are used by users to read, insert, modify, and delete data in a database.

Accepted Answer

A)  Reports 
B)  Forms 
C)  Queries 
D)  DBMS 
A)  Reports 
B)  Forms 
C)  Queries 
D)  DBMS

Question 10

A data model is a ________.

Accepted Answer

A)  logical representation of database data 
B)  repository of unprocessed data 
C)  collection of isolated databases 
D)  set of programs used to retrieve data 
A)  logical representation of database data 
B)  repository of unprocessed data 
C)  collection of isolated databases 
D)  set of programs used to retrieve data

Question 11

Attributes are used to describe characteristics of entities.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

A)  They are the same as N:N relationships. 
B)  They represent minimum cardinalities in a relationship. 
C)  They are also called one-to-many relationships. 
D)  They can have more than one entity on each side of the relationship. 
A)  They are the same as N:N relationships. 
B)  They represent minimum cardinalities in a relationship. 
C)  They are also called one-to-many relationships. 
D)  They can have more than one entity on each side of the relationship.

Question 14

Traditional database applications programs are ________.

Accepted Answer

A)  browser-based and display dynamic content 
B)  written in languages such as html5 and JavaScript 
C)  entirely dependent on the database server for application logic 
D)  thick applications that need to be installed on users' computers 
A)  browser-based and display dynamic content 
B)  written in languages such as html5 and JavaScript 
C)  entirely dependent on the database server for application logic 
D)  thick applications that need to be installed on users' computers

Question 15

What is the purpose of a database?

Accepted Answer

The purpose of a database is to keep tra

Question 16

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Explain the different types of database applications.

Accepted Answer

Database applications fall into two broa

Browser-based applications ________.

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

Which of the following is an international standard language for processing a database?

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

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

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

Relational databases represent relationships using ________.

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

________ are used by users to read, insert, modify, and delete data in a database.

A data model is a ________.

Attributes are used to describe characteristics of entities.

Metadata are ________.

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

Traditional database applications programs are ________.

What is the purpose of a database?

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

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

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

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

Explain the different types of database applications.

The Importance of MIS

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

The International Dimension

Filters

Exam 5: Database Processing

Browser-based applications ________.

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

Which of the following is an international standard language for processing a database?

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

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

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

Relational databases represent relationships using ________.

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

________ are used by users to read, insert, modify, and delete data in a database.

A data model is a ________.

Attributes are used to describe characteristics of entities.

Metadata are ________.

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

Traditional database applications programs are ________.

What is the purpose of a database?

One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

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

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

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

Explain the different types of database applications.

The Importance of MIS

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

The International Dimension

Filters