Question 1

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.

Question 2

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.

Question 3

What is the disadvantage of multiuser processing?

Accepted Answer

Most traditional and browser-based Inter...

Question 4

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

Question 5

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

What is the purpose of a database?

Accepted Answer

The purpose of a database is to keep tra...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

________ 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

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

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 15

What is a database application?

Accepted Answer

A database application is a collection o...

Question 16

The columns in a database are also called ________.

Accepted Answer

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

Question 17

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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.

Question 20

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

Accepted Answer

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

Exam 5: Database Processing

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

Correct AnswerverifiedShow Answer

What is the disadvantage of multiuser processing?

Correct AnswerverifiedMost traditional and browser-based Inter...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is the purpose of a database?

Correct AnswerverifiedThe purpose of a database is to keep tra...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

What is a database application?

Correct AnswerverifiedA database application is a collection o...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

The columns in a database are also called ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Traditional database application programs are ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
Most traditional and browser-based Inter...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The purpose of a database is to keep tra...
View Answer

Correct Answer
verified

Correct Answer
verified
A database application is a collection o...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified