Chapter 1 Practice Questions

Microsoft Access 2013 database files are stored using the file extension:

.accbd

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

Access 2007 format

Which of the following is not a function of the database application in a database system?

Control concurrency

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

Create and transmit queries

The creation of a database and its tables is a function of which component of the database system?

DBMS

Which of the following is NOT a basic component of a database system?

ERD

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

Perform back up and recover

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

Queries against records in the database tables

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

SQL

SQL stands for:

Structured Query Language.

A relational database is:

a self-describing collection of related tables.

Which of the following problems associated with storing data in a list is avoided by storing data in a relational database?

a.) Inability to store partial data b.) Duplication of data items c.) Maintaining the data may require changing the same data value in many locations d.) Inconsistency when a data item is used multiple times *e.) All of the above

A database may be used to help people:

a.) know the current inventory levels of products their company sells. b.) track which student is assigned to a particular advisor. c.) look up their checking account balance over the Internet. d.) check on the estimated arrival time of an incoming flight at an airport. *e.) All of the above

The Microsoft Access application generator is not responsible for:

creating tables

Microsoft SQL Server is an example of a:

database management system

The component of a database that makes it self-describing is the:

metadata

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

surrogate key

A relational database stores data in the form of:

tables

Microsoft Access is a personal database system, and a personal database system is characterized by:

the DBMS product taking the role of the DBMS and the database application generator.

Today almost every commercial database is based on:

the relational model