Exam 4: Databases and DataWarehouses

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

Data stewards ensure that people adhere to the definitions for the master data in their organizational units.

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

What approach do database developers use while choosing primary keys for a data model?

A relational database is less dependent on the hardware and its particular operating system.

An attribute of an entity in a table is called a ________.

A person who ensures that people adhere to the definitions for the master data in their organizational units is called a(n) ________.

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?

Which database architecture is especially used for managing web content and web-based resources?

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 data model that graphically shows the tables, attributes, keys, and logical relationships for a database is called a ________.

________ uses statistical techniques to explore a data warehouse and hunt for hidden patterns and relationships that are undetectable in routine reports.

A central data repository containing information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning is called a ________.

Julian, a database administrator, prepares data to be loaded to a data warehouse. He checks the zip code field against a reference database of zip codes to ensure that it conforms to standards. The zip codes that aren't in the standard format are reformatted. This process is called ________.

Which type of database architecture does Oracle use?

Trekking blindly into terabytes of data to sniff out meaningless relationships that occur just by accident is called ________.

When using databases without boundaries ________.

What are shadow systems? How do they hinder managers who are looking for company-wide summaries?

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

Pieces of information that cannot be linked together are called ________.