Question 1

COGNITIVE ASSESSMENT Which of the following contains a database that helps a group or department make decisions?
A) data speedset
B) data mart
C) data warehouse
D) data market

Accepted Answer

A data mart is a subset of a data warehouse, focused on a specific department or group within an organization. It contains a database that helps that specific group make decisions. A data warehouse, on the other hand, contains data from multiple sources and may serve a wider range of decision-making needs. Data speedset and data market are not standard terms in database management.

Question 2

COGNITIVE ASSESSMENT Which term describes a huge database that stores and manages data required to analyze historical and current transactions?
A) data mine
B) data archive
C) data market
D) data warehouse

Accepted Answer

A data warehouse is a huge database that is specifically designed to store and manage data required to analyze historical and current transactions. The purpose is to provide reliable, consistent, and integrated data to decision-makers to inform their strategic decisions. Data archives and data markets are different concepts that do not accurately describe a data warehouse. A data mine is similar to a data warehouse, but it specifically focuses on discovering patterns and relationships in data.

Question 3

COGNITIVE ASSESSMENT What is the process that large databases use to find patterns and relationships among data?
A) data distribution
B) data marketing
C) data mining
D) data analysis

Accepted Answer

The process that large databases use to find patterns and relationships among data is called data mining. Choice C is the only option that accurately describes this process. Data distribution refers to the way data is spread out or divided. Data marketing is the use of data to promote products or services. Data analysis involves examining data to draw conclusions or make decisions.

Question 4

COGNITIVE ASSESSMENT You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?
A) object-oriented
B) object-relational
C) relational
D) multi-dimensional

Accepted Answer

The description given matches the relational data model, which is based on tables that have rows and columns with unique names and primary keys. The other options - object-oriented, object-relational, and multi-dimensional - are different data models that may use different structures for storing data.

Question 5

COGNITIVE ASSESSMENT You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?
A) object-oriented
B) object-relational
C) relational
D) multi-dimensional

Accepted Answer

The answer of COGNITIVE ASSESSMENT You create a computer-aided design...

Question 6

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a record?
A) tuple
B) attribute
C) table
D) relation

Accepted Answer

In a relational database, a record is commonly referred to as a tuple. An attribute is a characteristic or property of the data within the record, a table is a collection of related records, and a relation is a connection between two or more tables.

Question 7

COGNITIVE ASSESSMENT Which term does a user of a relational database use to refer to a record?
A) row
B) table
C) column
D) attribute

Accepted Answer

In a relational database, a row is also known as a record. Therefore, the user of a relational database would use the term "row" to refer to a record.

Question 8

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?
A) restoration principle
B) forward recovery
C) continuous backup
D) rollback

Accepted Answer

The backup technique being described is forward recovery, which involves using the transaction log to reapply changes made to the database since the last save or backup. Restoration principle refers to the principle of restoring data to its original state after an error or failure. Continuous backup involves backing up data constantly rather than at specific intervals. Rollback refers to the process of undoing transactions that were not completed successfully.

Question 9

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?
A) rollforward
B) rollbackward
C) continuous backup
D) instant restoration

Accepted Answer

The answer of COGNITIVE ASSESSMENT Which recovery technique is more...

Question 10

COGNITIVE ASSESSMENT What is another name for a database analyst?
A) data query designer
B) data modeler
C) database administrator
D) data master

Accepted Answer

The answer of COGNITIVE ASSESSMENT What is another name for...

Question 11

COGNITIVE ASSESSMENT Which of the following integrates MRP II with the information flow across an organization to manage and coordinate the ongoing activities of the enterprise, including product planning, manufacturing and distribution, accounting and finance, sales, human resources, and customer support?
A) CMS
B) DMS
C) ERP
D) CAE

Accepted Answer

ERP (Enterprise Resource Planning) integrates MRP II with the information flow across an organization to manage and coordinate the ongoing activities of the enterprise, including product planning, manufacturing and distribution, accounting and finance, sales, human resources, and customer support. CMS (Content Management System), DMS (Document Management System), and CAE (Computer-Aided Engineering) are not related to the integration of MRP II and information flow across an organization.

Question 12

COGNITIVE ASSESSMENT Which term does a user of a relational database use to refer to a file?
A) row
B) table
C) column
D) relation

Accepted Answer

In a relational database, a user would refer to a file as a table. A table is a collection of data that is organized into rows and columns. Each row represents a record, and each column represents a field in that record. Therefore, table is the appropriate term that would be used to refer to a file in a relational database.

Question 13

COGNITIVE ASSESSMENT You store all of your photographs on a website that uses a database to store the photos users post. What is this type of database called?
A) collaborative database
B) group database
C) social database
D) visual database

Accepted Answer

The answer of COGNITIVE ASSESSMENT You store all of your...

Question 14

COGNITIVE ASSESSMENT Which of the following statements is not true about object-oriented databases (OODBs)?
A) A voice mail system is an example of a groupware database.
B) An object is an item that contains data, as well as the actions that read or process the data.
C) An OODB stores unstructured data more efficiently than a relational database.
D) OODBs can store more types of data and access it faster than relational databases.

Accepted Answer

None of the other statements are contradicted by common knowledge or facts about OODBs. A voice mail system is not typically considered a groupware database, which is a type of database designed for collaborative work.

Question 15

COGNITIVE ASSESSMENT Which of the following statements is not true about relational databases?
A) A relationship is a link within the data.
B) To set up a relationship between tables, they must have a common field.
C) Many organizations use relational databases for payroll, accounts receivable, order entry, and invoicing.
D) Applications best suited for relational databases are those whose data can be organized into a three-dimensional table.

Accepted Answer

Relational databases are best suited for applications whose data can be organized into a two-dimensional table, not a three-dimensional table.

Question 16

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a file?
A) tuple
B) attribute
C) table
D) relation

Accepted Answer

The answer of COGNITIVE ASSESSMENT Which term does the developer...

Question 17

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?
A) The number of dimensions in a multidimensional database varies.
B) Most multidimensional databases use a standard query language.
C) Nearly every multidimensional database has a dimension of time.
D) A multidimensional database can consolidate data much faster than a relational database.

Accepted Answer

The answer of COGNITIVE ASSESSMENT Which of the following statements...

Question 18

COGNITIVE ASSESSMENT Which of the following manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions?
A) SFA
B) MRP
C) CAM
D) CRM

Accepted Answer

CRM (Customer Relationship Management) manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions. SFA (Sales Force Automation) manages sales-related activities such as lead management, sales forecasting, and order management. MRP (Material Requirements Planning) manages the manufacturing process and inventory levels. CAM (Computer-Aided Manufacturing) manages the automation of the manufacturing process.

Question 19

COGNITIVE ASSESSMENT What company did Larry Ellison help found?
A) Oracle
B) Sun Microsystems
C) Sybase
D) Microsoft

Accepted Answer

Larry Ellison is the co-founder of Oracle Corporation, a multinational computer technology corporation that specializes in developing and marketing database software and technology, cloud engineered systems, and enterprise software products.

Question 20

COGNITIVE ASSESSMENT Which statement is not a recognized guideline for designing a database?
A) Each table or file should contain data about one subject.
B) Create fields for every piece of data you might need, such as fields for Date and Age.
C) Every record needs a primary key.
D) Use separate fields for logically distinct items, such as First Name and Last Name.

Accepted Answer

While it is important to include all necessary fields in a database, creating fields for every possible piece of data can lead to clutter and inefficiency. It is better to include only the necessary fields and use other methods, such as grouping or combining fields, to display the data in meaningful ways.

Quiz 11: Information and Data Management

COGNITIVE ASSESSMENT Which of the following contains a database that helps a group or department make decisions?

COGNITIVE ASSESSMENT Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

COGNITIVE ASSESSMENT What is the process that large databases use to find patterns and relationships among data?

COGNITIVE ASSESSMENT You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?

COGNITIVE ASSESSMENT You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a record?

COGNITIVE ASSESSMENT Which term does a user of a relational database use to refer to a record?

COGNITIVE ASSESSMENT After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

COGNITIVE ASSESSMENT What is another name for a database analyst?

COGNITIVE ASSESSMENT Which term does a user of a relational database use to refer to a file?

COGNITIVE ASSESSMENT You store all of your photographs on a website that uses a database to store the photos users post. What is this type of database called?

COGNITIVE ASSESSMENT Which of the following statements is not true about object-oriented databases (OODBs) ?

COGNITIVE ASSESSMENT Which of the following statements is not true about relational databases?

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a file?

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?

COGNITIVE ASSESSMENT Which of the following manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions?

COGNITIVE ASSESSMENT What company did Larry Ellison help found?

COGNITIVE ASSESSMENT Which statement is not a recognized guideline for designing a database?