Database Chapter 1 Quiz
The Microsoft Access application generator is not responsible for: A. creating forms B. creating reports C. creating queries D. creating tables E. sorting queries
D
Today almost every commercial database is based on: A. Lists B. The hierarchical model C. The linked-list model D. The relational model E. The object-oriented model
D
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) (T/F).
False
A database is self-describing because the user maintains a record of the database structure outside the database itself (T/F).
False
A relational database stores data in the form of lists (T/F).
False
Although users use database systems, they are not considered part of a database system (T/F).
False
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 (T/F).
False
An advantage of keeping data in lists is that if you update a data value in one row of data in a list, other occurrences of the same data item in other rows will be automatically updated as well (T/F).
False
Application programs are responsible for creating, maintaining, and supporting database backup and recovery systems (T/F).
False
In the general division of labor between database applications and the DBMS, the processing of forms is considered a DBMS task (T/F).
False
Metadata is the user data stored in the database (T/F).
False
Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files (T/F).
False
Most organizations create and use their own database management system (DBMS) products (T/F).
False
Personal DBMS products, such as Microsoft Access, create a clear distinction between the DBMS and the database application (T/F).
False
Referential integrity constraints must be enforced by the application program (T/F).
False
SQL stands for Structural Question Language (T/F).
False
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 (T/F).
False
Usually, a database table containing both rows and columns is designed to store data for exactly two themes (T/F).
False
Which of the following is not a basic component of a database system? A. Database B. User C. ERD D. DBMS E. Data applications
C
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 (T/F).
True
A relational database can be defined as a self-describing collection of related tables (T/F).
True
By separating data into tables containing data on only one theme each, making changes to the data is simplified (T/F).
True
In the general division of labor between database applications and the DBMS, the application program determines which tables need to be modified (T/F).
True
In the general division of labor between the database applications and the DBMS, the application programs format the results of a query into a report (T/F).
True
Microsoft Access 2013 databases are stored using the file extension .accdb (T/F).
True
Microsoft Access 2013 is a personal database that combines a DBMS with an application generator (T/F).
True
Microsoft Access 2013 uses the AutoNumber data type to create surrogate keys (T/F).
True
One problem with storing duplicate data is the potential for inconsistent values (T/F).
True
Relational database tables are commonly combined, queried, and processed using Structured Query Language (SQL) (T/F).
True
The DBMS is used to create the database itself (T/F).
True
The DBMS receives data update request from the application program (T/F).
True
The Microsoft Access 2013 application generator provides the ability to create and store forms, reports, and queries (T/F).
True
The purpose of a database is to help people keep track of things (T/F).
True
A relational database is: A. A self-describing collection of related tables B. A collection of forms and reports that support a given purpose C. A library of queries and data files for querying D. A set of applications and the data sets for those applications E. A set of metadata
A
The default file format for Microsoft Access 2013 database files is the: A. Access 2007 format B. Access 2003 format C. Access XP format D. SQL Server format E. XDB format
A
Which of the following is a function of the database application in a database system? A. Create and transmit queries B. Update database data C. Maintain database structures D. Create tables E. Backup and restore data
A
Microsoft Access is a personal database system, and a personal database system is characterized by: A. The DBMS removing the metadata from the database B. The DBMS product taking the role of the DBMS and the database application generator C. The database being stored inside the DBMS D. The DBMS product being limited to a maximum of ten tables in any given database E. The DBMS not supporting indexes
B
Microsoft SQL Server is an example of: A. Database B. DBMS C. Data manipulation system D. Table E. List manager
B
The statement SELECT STUDENT.StudentNumber, STUDENT.StudentName, FROM STUDENT WHERE STUDENT.StudentNumber = S12345678; is an example of: A. QBE B. SQL C. QLE D. C++ E. Java
B
Which of the following is not a function of the database application in a database system? A. Execute application logic B. Control concurrency C. Create and process forms D. Create and transmit queries E. Create and process reports
B
Microsoft Access 2013 database files are stores using the file extension: A. .adb B. .asp C. .accdb D. mdb E. .sql
C
SQL stands for: A. Standard Query Language B. Structural Question Language C. Structured Query Language D. Standard Question Language E. Structured Question Language
C
The Microsoft Access 2013 data type of AutoNumber is use when there is a specific need for a: A. foreign key B. primary key C. surrogate key D. spare key E. secondary key
C
The creation of a database and its tables is a function of which component of the database system? A. Users B. Application C. DBMS D. Database E. Web server
C
A relational database stores data in the form of: A. Lists B. Forms C. Columns D. Tables E. Spreadsheets
D
Which of the following is a function of the DBMS in a database system? A. Create and transmit queries B. Control applications C. Create and process forms D. Perform backup and recovery E. Process Web page requests
D
A database may be used to help people: A. Track which student is assigned a particular advisor B. Know the current inventory levels of products their company sells. C. Check on the estimated time of an incoming flight at an airport D. Look up their checking account balance over the Internet E. All of the above
E
The component of a database that makes it self-describing is the: A. Related tables B. Applications C. Library D. Data set E. Metadata
E
Which of the following problems associated with storing data in a list is avoided by storing data in a relational database? A. Maintaining the data may require changing the same data values in many locations B. Inconsistency when a data item is used multiple times C. Inability to store partial data D. Duplication of data items E. All of the above
E
Which of the following would not be an example of database metadata? A. Names of tables in a database B. Propertied of tables in a database C. Names of columns in a database and their associated tables D. Properties of columns E. Queries against records in the database tables
E