Exam 4: Databases and Datawarehouses

A system's ability to handle rapidly increasing demand is called ________.

What are the characteristics of high-quality information?

A network database supports many-to-many relationships.

The database model that organizes information into tables of records that are connected to one another by linking a field in one table to a field in another table is called ________.

Which of the following is an early database approach that allowed flexible links to support many-to-many relationships?

What are the functions of database management software (DBMS)? Name some common database management software.

While creating a relational database for an organization, "Employees" would constitute one attribute with employee ID number, last name, first name, birth date, email address, and phone number as entities.

A company maintains a centralized repository of information from internal sources, competitor information, census reports, and metadata from documents and multimedia. This is known as a ________.

To balance the information needs of multiple stakeholders, top-level managers need clear, consistent, and accurate reports that summarize information from across the enterprise.

Which type of database architecture does Oracle use?

Flippy, an online shoe store, uses an information system to store sales transactions with clearly defined fields for date, customer number, item number, invoice number, and amount. What type of information resource does Flippy use?

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

An operational database is not a good candidate for high-level management reporting because it is not equipped to ________.

An integrated collection of information that is logically related and stored in such a way as to minimize duplication and facilitate rapid retrieval is called a ________.

A marketing representative who wants to put a positive spin on a tally of recent orders chooses to include orders that have been canceled in his report. This report exemplifies high-quality data.

Which of the following is the most widely used database architecture?

To collate innovative ideas for an important business project, a manager creates a database which is not integrated into the enterprise database. The new database is an example of a(n)________.

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

What are the requirements for successful master data management?

Which of the following is the best way to handle complex relationships, such as the data for a company where employees can be assigned to more than one project, and each project can have more than one employee assigned to it?