Question 1

Which of the following notations in an E-R diagram means that the entity is optional and a relationship need not have an entity of that type?

Accepted Answer

A) vertical bar 
B) arrow 
C) double line 
D) small oval 
A) vertical bar 
B) arrow 
C) double line 
D) small oval

Question 2

Which of the following is an example of a database management system?

Accepted Answer

A) MS Excel 
B) BigData 
C) NoSQL 
D) Access 
A) MS Excel 
B) BigData 
C) NoSQL 
D) Access

Question 3

Samuel is the database administrator for Zimline Constructions. He determines the processing rights of employees based on their designation. Team leaders are given greater access to the database than their team members. This procedure of giving selective access is part of Samuel's ________ task.

Accepted Answer

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

Question 4

In a database, ________ are grouped into columns.

Accepted Answer

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

Question 5

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 6

Explain how a database management system processes a database.

Accepted Answer

A function of the DBMS is to process the

Question 7

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

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

Question 9

What are the steps involved in transforming a data model into a relational database design?

Accepted Answer

To transform a data model into a relatio

Question 10

The term ________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed.

Accepted Answer

A) consistent 
B) atomic 
C) durable 
D) isolated 
A) consistent 
B) atomic 
C) durable 
D) isolated

Question 11

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, productivity of an employee on daily basis, 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 12

Constraints on the minimum number of entities in a relationship are called ________ cardinalities.

Accepted Answer

A) specific 
B) minimum 
C) primary 
D) critical 
A) specific 
B) minimum 
C) primary 
D) critical

Question 13

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 14

What is database administration?

Accepted Answer

Database administration involves a wide

Question 15

Which of the following is used to process and display browser database application forms, reports, and queries?

Accepted Answer

A) C++ 
B) html 
C) COBOL 
D) VisualBasic 
A) C++ 
B) html 
C) COBOL 
D) VisualBasic

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n)________.

Accepted Answer

A) data integrity problem 
B) crow's-foot paradigm 
C) adaptation conflict 
D) security problem 
A) data integrity problem 
B) crow's-foot paradigm 
C) adaptation conflict 
D) security problem

Question 18

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

Accepted Answer

A) True 
 B)False

Question 19

What are traditional database applications?

Accepted Answer

A traditional database is shared among m

Question 20

What is the disadvantage of multiuser processing?

Accepted Answer

Most traditional and browser-based Inter

Which of the following notations in an E-R diagram means that the entity is optional and a relationship need not have an entity of that type?

Which of the following is an example of a database management system?

Samuel is the database administrator for Zimline Constructions. He determines the processing rights of employees based on their designation. Team leaders are given greater access to the database than their team members. This procedure of giving selective access is part of Samuel's ________ task.

In a database, ________ are grouped into columns.

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

Explain how a database management system processes a database.

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

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

What are the steps involved in transforming a data model into a relational database design?

The term ________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed.

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, productivity of an employee on daily basis, and employee name. These aspects that Brad wants to track are called ________.

Constraints on the minimum number of entities in a relationship are called ________ cardinalities.

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

What is database administration?

Which of the following is used to process and display browser database application forms, reports, and queries?

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

In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n)________.

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

What are traditional database applications?

What is the disadvantage of multiuser processing?

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 notations in an E-R diagram means that the entity is optional and a relationship need not have an entity of that type?

Which of the following is an example of a database management system?

Samuel is the database administrator for Zimline Constructions. He determines the processing rights of employees based on their designation. Team leaders are given greater access to the database than their team members. This procedure of giving selective access is part of Samuel's ________ task.

In a database, ________ are grouped into columns.

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

Explain how a database management system processes a database.

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

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

What are the steps involved in transforming a data model into a relational database design?

The term ________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed.

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, productivity of an employee on daily basis, and employee name. These aspects that Brad wants to track are called ________.

Constraints on the minimum number of entities in a relationship are called ________ cardinalities.

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

What is database administration?

Which of the following is used to process and display browser database application forms, reports, and queries?

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

In a database, when data items are inaccurate and inconsistent with one another, it leads to a(n)________.

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

What are traditional database applications?

What is the disadvantage of multiuser processing?

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