DB Chapter 1 True/False – Flashcards

question
The purpose of a database is to help people keep track of things.
answer
T
question
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.
answer
T
question
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.
answer
F
question
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.
answer
F
question
One problem with storing duplicated data is the potential for inconsistent values.
answer
T
question
A relational database stores data in the form of lists.
answer
F
question
Usually, a database table containing both rows and columns is designed to store data for exactly two themes.
answer
F
question
By separating data into tables containing data on only one theme each, making changes to the data is simplified.
answer
T
question
SQL stands for Structural Question Language.
answer
F
question
Relational database tables are commonly combined, queried, and processed using Structured Query Language (SQL).
answer
T
question
Although users use database systems, they are not considered part of a database system.
answer
F
question
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).
answer
F
question
A relational database can be defined as a self-describing collection of related tables.
answer
T
question
A database is self-describing because the user maintains a record of the database structure outside the database itself.
answer
F
question
Metadata is the user data stored in the database.
answer
F
question
Most organizations create and use their own database management system (DBMS) products.
answer
F
question
The DBMS is used to create the database itself.
answer
T
question
Referential integrity constraints must be enforced by the application program.
answer
F
question
Application programs are responsible for creating, maintaining, and supporting database backup and recovery systems.
answer
F
question
The DBMS receives data update requests from the application program.
answer
T
question
In the general division of labor between database applications and the DBMS, the processing of forms is considered a DBMS task.
answer
F
question
In the general division of labor between database applications and the DBMS, the application program determines which tables need to be modified.
answer
T
question
In the general division of labor between database applications and the DBMS, the application program formats the results of a query into a report.
answer
T
question
Personal DBMS products, such as Microsoft Access, create a clear distinction between the DBMS and the database application.
answer
F
question
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.
answer
F
question
Microsoft Access 2010 is a personal database that combines a DBMS with an application generator.
answer
T
question
The Microsoft Access 2010 application generator provides the ability to create and store forms, reports, and queries.
answer
T
question
Microsoft Access 2010 databases are stored using the file extension .accdb.
answer
F
question
Microsoft Access 2010 uses the Access 2003 .mdb file format as the default file format for database files.
answer
F
question
Microsoft Access 2010 uses the AutoNumber data type to create surrogate keys.
answer
T
1 of

Unlock all answers in this set

Unlock answers
question
The purpose of a database is to help people keep track of things.
answer
T
question
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.
answer
T
question
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.
answer
F
question
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.
answer
F
question
One problem with storing duplicated data is the potential for inconsistent values.
answer
T
question
A relational database stores data in the form of lists.
answer
F
question
Usually, a database table containing both rows and columns is designed to store data for exactly two themes.
answer
F
question
By separating data into tables containing data on only one theme each, making changes to the data is simplified.
answer
T
question
SQL stands for Structural Question Language.
answer
F
question
Relational database tables are commonly combined, queried, and processed using Structured Query Language (SQL).
answer
T
question
Although users use database systems, they are not considered part of a database system.
answer
F
question
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).
answer
F
question
A relational database can be defined as a self-describing collection of related tables.
answer
T
question
A database is self-describing because the user maintains a record of the database structure outside the database itself.
answer
F
question
Metadata is the user data stored in the database.
answer
F
question
Most organizations create and use their own database management system (DBMS) products.
answer
F
question
The DBMS is used to create the database itself.
answer
T
question
Referential integrity constraints must be enforced by the application program.
answer
F
question
Application programs are responsible for creating, maintaining, and supporting database backup and recovery systems.
answer
F
question
The DBMS receives data update requests from the application program.
answer
T
question
In the general division of labor between database applications and the DBMS, the processing of forms is considered a DBMS task.
answer
F
question
In the general division of labor between database applications and the DBMS, the application program determines which tables need to be modified.
answer
T
question
In the general division of labor between database applications and the DBMS, the application program formats the results of a query into a report.
answer
T
question
Personal DBMS products, such as Microsoft Access, create a clear distinction between the DBMS and the database application.
answer
F
question
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.
answer
F
question
Microsoft Access 2010 is a personal database that combines a DBMS with an application generator.
answer
T
question
The Microsoft Access 2010 application generator provides the ability to create and store forms, reports, and queries.
answer
T
question
Microsoft Access 2010 databases are stored using the file extension .accdb.
answer
F
question
Microsoft Access 2010 uses the Access 2003 .mdb file format as the default file format for database files.
answer
F
question
Microsoft Access 2010 uses the AutoNumber data type to create surrogate keys.
answer
T
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New