Exam 1: Getting Started

A possible problem with keeping data in lists is that if you delete a row of data from a list,you may also delete some data items that you want to keep.

Personal DBMS products,such as Microsoft Access,create a clear distinction between the DBMS and the database application.

SQL stands for Structural Question Language.

What components are included in a database?

In the general division of labor between database applications and the DBMS,the application program formats the results of a query into a report.

What problems with storing data on two themes in a list are addressed by database technology?

One problem with storing duplicated data is the potential for inconsistent values.

The purpose of a database is to help people keep track of things.

In relational databases,query requests use a language called ________.

A relational database can be defined as a self-describing collection of related tables.

Microsoft Access 2013 is a personal database that combines a DBMS with an application generator.

The default file format for Microsoft Access 2013 database files is the:

The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a:

A relational database stores data in the form of:

A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).

Microsoft Access is considered a "personal database" product.What is a personal database?

Briefly describe the four components of a database system.

Application programs are responsible for creating,maintaining,and supporting database backup and recovery systems.

Microsoft Access 2013 uses the AutoNumber data type to create surrogate keys.

A(n)________ is a set of one or more computer programs that serves as an intermediary between the user and the DBMS.