Exam 1: Getting Started

Microsoft Access 2013 database files are stored using the ________ file extension.

Although users use database systems,they are not considered part of a database system.

The statement SELECT STUDENT.StudentNumber,STUDENT.StudentName, FROM STUDENT WHERE STUDENT.StudentNumber = S12345678; Is an example of:

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?

Microsoft Access is a(n)________,which combines a DBMS and an application generator.

SQL stands for:

The DBMS receives data update requests from the application program.

Microsoft SQL Server is an example of a:

In a database system,the ________ creates and processes forms.

In the general division of labor between database applications and the DBMS,the processing of forms is considered a DBMS task.

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

A relational database stores data in the form of ________.

What are "referential integrity constraints"? Give an example.

Briefly describe the function of the DBMS in a database system.

Relational database tables are commonly combined,queried,and processed using Structured Query Language (SQL).

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

________ constraints are rules that the DBMS enforces to ensure that data values in one table have corresponding values in another related table.

A relational database is:

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.