Exam 1: Getting Started

There is no reason for serious database developers to learn many aspects of database processing technology because DBMS products like Microsoft Access hide these aspects.

Microsoft Access 2013 databases are stored using the file extension .accdb.

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

Microsoft Access 2013 generates surrogate key values when the ________ data type is used.

Most organizations create and use their own database management system (DBMS)products.

The Microsoft Access application generator is not responsible for:

An advantage of keeping data in lists is that if you add a new row of data to the list,you will never have null values occurring for any data item in the row.

Which of the following is a function of the DBMS in a database system?

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

Today almost every commercial database is based on:

It is almost always best to design a table in a database so that it contains data on ________ theme.

SQL stands for Structural Question Language.

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

Which of the following would not be an example of database metadata?

The Microsoft Access application generator adds the ability to create and store ________,________,and ________.

SQL stands for:

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.

Briefly describe the function of an application program in a database system.

What is a surrogate key and how does Microsoft Access 2013 create surrogate keys?

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