FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Organizing and Manipulating the Data in Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

As a general rule, creating data warehouses is:

A) Easy
B) Habit forming
C) Challenging but often worth the cost
D) Challenging, and historically rarely worth the cost

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

An OR operation query)in Microsoft Access requires you to use multiple Criteria lines to create the query.

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

A database management system is:

A DBMS is an efficient database table in third normal form.

A delete query in Microsoft Access is an example of an action query that enables you to delete all those records in a table satisfying specific criteria.

You could append the term "Jr." to selected names in a customer database using Microsoft's:

A useful guideline to follow when creating data fields containing text is to limit data fields to reasonable lengths.

Another word for "cleaning" the data in preparation for storing it in a data warehouse in order to ensure uniform accuracy is:

The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Parental Hierarchy" in Microsoft Access.

Using Microsoft Access to create a select query with multiple criteria all of which you want satisfied at the same time), you should specify them on the same Criteria line of the query.

A school administrator wishes to select the names of all students who have taken at least 130 units of credit at your university to see if they qualify for graduation.Which of these is the best type of query to use for this task?

If creating a data mart is not cost effective, management should consider creating a data warehouse, which typically uses less money and time to design.

When purchasing a new database management system, managers should focus on the system's technological capabilities rather than its compatibility with current systems.

All of the following are advantages of drop-down boxes in Access except:

Database management systems can be implemented on:

One purpose of a data manipulation language is to:

All of these are examples of action queries that you can create in Microsoft Access except:

An example of an input mask for an Access data field is "000\-00\-0000."

Using Microsoft Access, you can delete a record from the "many" side of a one-to-many relationship, even if referential integrity is enforced.

Pivot tables are powerful statistical tools, but allow the user little flexibility in selecting what data can be analyzed.