Question 1

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

Question 2

Entities in a data model have ________ that describe the characteristics of the entity.

Accepted Answer

A) characters 
B) primary keys 
C) codes 
D) attributes 
A) characters 
B) primary keys 
C) codes 
D) attributes

Question 3

Managing the impact of database structural changes on applications and users is an operational task for a database administrator.

Accepted Answer

A) True 
 B)False

Question 4

Metadata are ________.

Accepted Answer

A) codes used for server-side processing 
B) error logs of databases 
C) data that describe data 
D) data that are encrypted 
A) codes used for server-side processing 
B) error logs of databases 
C) data that describe data 
D) data that are encrypted

Question 5

Identify the first step in transforming a data model into a relational database design.

Accepted Answer

A) representing the entity relationships 
B) normalizing the data and files 
C) creating foreign keys 
D) creating a table for each entity 
A) representing the entity relationships 
B) normalizing the data and files 
C) creating foreign keys 
D) creating a table for each entity

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

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

A primary key in a database is a ________.

Accepted Answer

A) group of rows that identifies a unique table or file 
B) column or group of columns that identifies a unique row in a table 
C) group of fields or columns that represent metadata 
D) group of tables or files formed to identify a unique field or row 
A) group of rows that identifies a unique table or file 
B) column or group of columns that identifies a unique row in a table 
C) group of fields or columns that represent metadata 
D) group of tables or files formed to identify a unique field or row

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

For Falcon Security, the primary purpose of creating a database of video information is to ________.

Accepted Answer

A) keep track of a single theme 
B) eliminate concern about the lost update problem 
C) enable querying based on video characteristics 
D) avoid the use of spreadsheets 
A) keep track of a single theme 
B) eliminate concern about the lost update problem 
C) enable querying based on video characteristics 
D) avoid the use of spreadsheets

Question 12

How does normalization resolve the data integrity problem?

Accepted Answer

Normalization is the process of converti

Question 13

The process of normalization constructs tables such that every table has a ________.

Accepted Answer

A) one-to-one relationship between entities 
B) single theme 
C) foreign key 
D) specialized graphical query 
A) one-to-one relationship between entities 
B) single theme 
C) foreign key 
D) specialized graphical query

Question 14

________ in an E-R diagram refer to the least number of entities required in a relationship.

Accepted Answer

A) Minimum candidate keys 
B) Primary keys 
C) Foreign keys 
D) Minimum cardinalities 
A) Minimum candidate keys 
B) Primary keys 
C) Foreign keys 
D) Minimum cardinalities

Question 15

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

Accepted Answer

A) True 
 B)False

Question 16

Describe a database and its elements.

Accepted Answer

A database is a self-describing collecti

Question 17

Browser applications are thin-client applications that ________.

Accepted Answer

A) use COBOL as the standard language for user-side processing 
B) are processed using VisualBasic and C++ 
C) need not be preinstalled on the users' computers 
D) depend on internal networks and not the Internet to transmit data 
A) use COBOL as the standard language for user-side processing 
B) are processed using VisualBasic and C++ 
C) need not be preinstalled on the users' computers 
D) depend on internal networks and not the Internet to transmit data

Question 18

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 
A) database application 
B) database design 
C) data field 
D) data model

Question 19

NoSQL databases refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

Accepted Answer

A) True 
 B)False

Question 20

The format of metadata depends on the software product that processes the database.

Accepted Answer

A) True 
 B)False

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

Entities in a data model have ________ that describe the characteristics of the entity.

Managing the impact of database structural changes on applications and users is an operational task for a database administrator.

Metadata are ________.

Identify the first step in transforming a data model into a relational database design.

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

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

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

A primary key in a database is a ________.

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

For Falcon Security, the primary purpose of creating a database of video information is to ________.

How does normalization resolve the data integrity problem?

The process of normalization constructs tables such that every table has a ________.

________ in an E-R diagram refer to the least number of entities required in a relationship.

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

Describe a database and its elements.

Browser applications are thin-client applications that ________.

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

NoSQL databases refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

The format of metadata depends on the software product that processes the database.

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 is true of in-memory DBMS products?

Entities in a data model have ________ that describe the characteristics of the entity.

Managing the impact of database structural changes on applications and users is an operational task for a database administrator.

Metadata are ________.

Identify the first step in transforming a data model into a relational database design.

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

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

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

A primary key in a database is a ________.

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

For Falcon Security, the primary purpose of creating a database of video information is to ________.

How does normalization resolve the data integrity problem?

The process of normalization constructs tables such that every table has a ________.

________ in an E-R diagram refer to the least number of entities required in a relationship.

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

Describe a database and its elements.

Browser applications are thin-client applications that ________.

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

NoSQL databases refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

The format of metadata depends on the software product that processes the database.

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