Exam 4: Databases and DataWarehouses

A credit card company wants to spot elusive patterns in credit card transaction records to be able to block fraudulent transactions. This company should use ________.

How is metadata related to information?

During mergers, integration of multiple databases becomes a major challenge.

A network database supports many-to-many relationships.

One of the uses of databases without boundaries is in ________.

Shards or slices of a database should be accessed from the same computer for improved performance.

A foreign key is ________.

The process of sequentially executing operations on each record in a large batch is called data integration.

Which product allows voice commands, sequenced like a natural conversation, as a means to access a database?

An approach that attempts to achieve consistent and uniform definitions for entities and their attributes across all business units is called ________.

In Aster Limited, the HR department did not include interns as employees in their database, while the finance department included them. Such inconsistencies can be avoided through ________.

What are the requirements for successful master data management?

The early file processing systems were very difficult to maintain because of ________.

Which process assigns incremental numbers to records as they are created to ensure that each record has a unique primary key?

What is a database? Why is it a better system of information organization compared to a file processing system?

Which of the following is a disadvantage of using shadow systems?

In a table, a field can contain either numeric data or text but not a combination of both.

In Robin Dave Hospital, visiting physicians use different spreadsheets to record the name, address, mobile number, and email of clients. These individual spreadsheets are then compiled by a data-entry operator into one spreadsheet. What type of information does the compiled spreadsheet represent?

A model used for planning the organization's database that identifies what kind of information is needed, what entities will be created, and how they are related to one another is called a(n) ________.

Database architecture that has multidimensional data grouped in logical dimensions, such as sales by product, city, region, and country, is called ________.