FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Databases and Information Management

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

Data cleansing not only corrects errors but also

A) establishes logical relationships between data.
B) structures data.
C) normalizes data.
D) enforces consistency among different sets of data.

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

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

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

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

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

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.

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

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

Database designers document their data model with ________.

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

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

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?

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

Oracle Database Lite is a(n)

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

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.

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

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