Question 1

A logical representation of database data, called the data model, is constructed by developers after building a database.

Accepted Answer

A) True 
 B)False

Question 2

Maria creates a relational database to keep track of cars in her repair shop. She stores information about each car in the "vehicle" table, and creates a column labeled "vehicle_ID" where she stores the vehicle VIN number. The "vehicle_ID" column is referred to as a ________.

Accepted Answer

A)  primary key 
B)  key attribute 
C)  foreign key 
D)  functionally dependent record 
E)  secondary key 
A)  primary key 
B)  key attribute 
C)  foreign key 
D)  functionally dependent record 
E)  secondary key

Question 3

A(n) ________ is a request for data from a database.

Accepted Answer

A)  form 
B)  report 
C)  query 
D)  application 
E)  db pull 
A)  form 
B)  report 
C)  query 
D)  application 
E)  db pull

Question 4

What is the purpose of a database?

Accepted Answer

The purpose of a database is to keep tra

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 
E)  Banding 
A)  Optimization 
B)  Normalization 
C)  Refactoring 
D)  Standardization 
E)  Banding

Question 6

A DBMS and database are synonymous terms that can be used interchangeably.

Accepted Answer

A) True 
 B)False

Question 7

What is the disadvantage of multiuser processing?

Accepted Answer

Most traditional and browser-based Inter

Question 8

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. 
E)  They run on clustered Linux or Unix systems 
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. 
E)  They run on clustered Linux or Unix systems

Question 9

A significant difference between using Access versus Mongo DB to store Falcon Security's video information is:

Accepted Answer

A)  with Mongo DB the video footage and the metadata are stored in separate databases, while in Access the video footage and the metadata are stored in the same database. 
B)  with Mongo DB the video footage and the metadata are stored in the same database, while in Access the video footage and the metadata are stored in separate databases. 
C)  there is no significant difference in using Access versus Mongo DB for storing Falcon's video information. 
D)  Mongo DB cannot be used for querying because it is a NoSQL database. 
E)  Access can retrieve data more quickly than Mongo DB. 
A)  with Mongo DB the video footage and the metadata are stored in separate databases, while in Access the video footage and the metadata are stored in the same database. 
B)  with Mongo DB the video footage and the metadata are stored in the same database, while in Access the video footage and the metadata are stored in separate databases. 
C)  there is no significant difference in using Access versus Mongo DB for storing Falcon's video information. 
D)  Mongo DB cannot be used for querying because it is a NoSQL database. 
E)  Access can retrieve data more quickly than Mongo DB.

Question 10

Traditional database application 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 
E)  cloud-based applications 
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 
E)  cloud-based applications

Question 11

The columns in a database are also called ________.

Accepted Answer

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

Question 12

Lists that involve data with multiple themes can be stored in a spreadsheet.

Accepted Answer

A) True 
 B)False

Question 13

The purpose of a database is to keep track of lists of data that involve multiple themes.

Accepted Answer

A) True 
 B)False

Question 14

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. 
E)  They connect different data types. 
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. 
E)  They connect different data types.

Question 15

Browser applications are thin-client applications that need to be preinstalled on the users' computers.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  operating system 
B)  database management system 
C)  information system 
D)  database system 
E)  operating system driver 
A)  operating system 
B)  database management system 
C)  information system 
D)  database system 
E)  operating system driver

Question 18

Which of the following is True of in-memory DBMS products?

Accepted Answer

A)  They support or extend the relational model. 
B)  They do not provide ACID transaction support. 
C)  They are a hotbed of development. 
D)  MongoDB is an in-memory DBMS product. 
E)  They are low-volume, but high integrity DBMS product. 
A)  They support or extend the relational model. 
B)  They do not provide ACID transaction support. 
C)  They are a hotbed of development. 
D)  MongoDB is an in-memory DBMS product. 
E)  They are low-volume, but high integrity DBMS product.

Question 19

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

Accepted Answer

A)  database application 
B)  database design 
C)  data field 
D)  data model 
E)  data bridge 
A)  database application 
B)  database design 
C)  data field 
D)  data model 
E)  data bridge

Question 20

What is a database application?

Accepted Answer

A database application is a collection o

A logical representation of database data, called the data model, is constructed by developers after building a database.

Maria creates a relational database to keep track of cars in her repair shop. She stores information about each car in the "vehicle" table, and creates a column labeled "vehicle_ID" where she stores the vehicle VIN number. The "vehicle_ID" column is referred to as a ________.

A(n) ________ is a request for data from a database.

What is the purpose of a database?

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

A DBMS and database are synonymous terms that can be used interchangeably.

What is the disadvantage of multiuser processing?

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

A significant difference between using Access versus Mongo DB to store Falcon Security's video information is:

Traditional database application programs are ________.

The columns in a database are also called ________.

Lists that involve data with multiple themes can be stored in a spreadsheet.

The purpose of a database is to keep track of lists of data that involve multiple themes.

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

Browser applications are thin-client applications that need to be preinstalled on the users' computers.

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

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

Which of the following is True of in-memory DBMS products?

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

What is a database application?

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

A logical representation of database data, called the data model, is constructed by developers after building a database.

Maria creates a relational database to keep track of cars in her repair shop. She stores information about each car in the "vehicle" table, and creates a column labeled "vehicle_ID" where she stores the vehicle VIN number. The "vehicle_ID" column is referred to as a ________.

A(n) ________ is a request for data from a database.

What is the purpose of a database?

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

A DBMS and database are synonymous terms that can be used interchangeably.

What is the disadvantage of multiuser processing?

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

A significant difference between using Access versus Mongo DB to store Falcon Security's video information is:

Traditional database application programs are ________.

The columns in a database are also called ________.

Lists that involve data with multiple themes can be stored in a spreadsheet.

The purpose of a database is to keep track of lists of data that involve multiple themes.

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

Browser applications are thin-client applications that need to be preinstalled on the users' computers.

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

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

Which of the following is True of in-memory DBMS products?

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

What is a database application?

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