Exam 4: Organizing and Manipulating the Data in Databases

An update query in Microsoft Access is an example of an action query that enables you to increase the prices by ten percent for all those products starting with product code "123."

Using Access, which of these terms is not associated with defining a data field within a record?

The conventional prefix for the name of a table is "tbl."

All of these are characteristics of the data stored in a data warehouse except:

If you wish to create a select query with alternate criteria using Microsoft Access e.g., you wish to see a list of all customers living in zip codes 12345 or 12366), you should specify them on separate Criteria lines of the query.

A disadvantage of database management systems is that:

An example of a data type for a data field in the record of an Access table is "Text."

It is not necessary for data to be "clean" or accurate if they are stored in a data warehouse.

DDL is an acronym for "data definition language."

Data warehouses are only used for analyzing current accounting data.

Which of these is an example of a data query language?

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:

It is not possible to save a table in Microsoft Access unless you also identify a primary record key.

The proper prefix to use when naming a table in Microsoft Access is:

If you require a data entry in an Access database to fall between two dates rather than between two numeric values):

DML stands for "data management logic."

An advantage of a multimedia database is that:

OLAP is notable for its "drill-down capability."