Chapter 10
the BLOB data type may be used for _____
photos, audio, or video
government agencies share information with a wide audience using a database service, which is a/n ___
portal for a database
you can use a report writer only to
retrieve data
in access, design view is used to ___
set parameters for the table's data
which of the following is not true about nonrelational databases?
they are not suited to manage the massive volume of Big Data
A company selling consumer data they collected through sales transactions is an example of function creep (T/F)
true
Relationships reduce the quantity of data stored in a database by minimizing data duplication across multiple tables (T/F)
true
with a nonrelational database, you can perform more flexible functions that allow your analysis to be more dynamic and vaired (T/F)
true
Magda is setting up a database to help manage inventory for the new store she is opening. She uses a primary key to _____.
uniquely identify each record in a table
sam uses a dashboard to ____
view data analysis with live upates
in access, the navigation pane lets you ___
move among objects in a database
Databases typically are more simple and require less memory and processing power than file processing systems (T/F)
False
When a database flags a deleted record, the record is deleted permanently (T/F)
False
a DBMS generally has a more user-friendly interface than a front-end (T/F)
False
A Yes/No data type is also called Boolean (T/F)
True
DBMS stands for database management system (T/F)
True
QBE is a feature that has a graphical user interface to assist users with retrieving data (T/F)
True
when searching for data in a database, you often specify the field name (T/F)
True
an index is a database object that is created based on ___
a field or combination of fields
which of the following is not true about database objects?
a query should include all the fields in a table
according to the principle of least privilege, ___
a user only can access the tables and records necessary to perform their job functions
In a database, a data file is a/n
collection of related records
a key-value pair consists of which two related items?
constant variable
Daniel decides to use a database system to avoid the issue of data redundancy, which occurs when ____
data is stored in more than one place
a consistency check is used to ___
ensure that the relationship between two fields are logical
a rollback is used to reenter changes made to the database since the last save or backup (T/F)
false
only a primary key can be indexed (T/F)
false
a complex DBMS might use a log to ____
list activities that modify the contents of the database
Han uses a data dictionary to ___
maintain the integrity of each table in his database and each field in each table
SQL allows users to ____
manage, update, and retrieve data
