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