Exam 6: Databases and Information Management

A DBMS includes capabilities and tools for ________,managing,and accessing the data in the database.

Many applications today require databases that can store and retrieve multimedia.

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

The data warehouse extracts current and future data from multiple operational systems inside the organization.

A ________ represents the smallest unit of data a computer can handle.

The ________ operation creates a subset consisting of all records in the file that meet stated criteria.

A ________ represents the smallest unit of data a computer can handle.

An ________ stores the data and procedures that act on those data as objects that can be automatically retrieved and shared.

Database designers document their data model with ________.

The specialized language programmers use to add and change data in the database is called

Data cleansing not only corrects errors but also

What types of relationships are possible in a relational database? Describe and give an example of each.

Microsoft Access has a rudimentary ________ capability that displays information about the size,format,and other characteristics of each field in a database.

List at least three conditions that contribute to data redundancy and inconsistency.

Helen just wants to design and implement a DBMS in her organization.She is very technical and has a great aptitude for this type of work.Her outside consultant is telling her that she must make some management decisions about information policy and data quality assurance because they are essential in managing the firm's resources.How would you advise her and why?

The confusion created by ________ makes it difficult for companies to create customer relationship management,supply chain management,or enterprise systems that integrate data from different sources.

Oracle Database Lite is a(n)

The process of creating small,stable,yet flexible and adaptive data structures from complex groups of data is called ________.

Data redundancy is the presence of duplicate data in multiple data files so that the same data are stored in more than one place or location.

Data access deals with the policies and processes for managing the availability,usability,integrity,and security of the data employed in an enterprise.