MIS Chapter 11. User of a database, bag data
Unlock all answers in this set
Unlock answersquestion
A user of a database such as that pictured in the accompanying figure refers to a record as what?
answer
row
question
Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or on cloud storage?
answer
file
question
One application that uses multidimensional databases is an object-oriented database.
answer
false
question
In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?
answer
field
question
The data in a database environment belongs to and is shared, usually over a network, by an entire organization.
answer
true
question
What is another term used for data dictionary?
answer
repository
question
The data in a database is independent of programs that access that data.
answer
true
question
Big Data refers to large-scale data sets that require advanced technologies.
answer
true
question
Which of the following is true about the database approach?
answer
Data in a database is less vulnerable than data in file processing systems.
question
In a file processing system, each department or area in an organization shares files collectively.
answer
false
question
Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?
answer
log
question
Which of the following refers to the procedures that keep data current?
answer
file maintenance
question
Which of the following is a database that stores data in tables that consist of rows and columns?
answer
relational
question
With the database approach, most data items are stored in multiple files, which greatly reduces duplicate data.
answer
false
question
Each higher level of data consists of one or more items from the lower level.
answer
true
question
Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?
answer
data warehouse
question
Analysts often refer to the three ____'s when describing characteristics of Big Data.
answer
V
question
In managing a company's database, which of the following roles requires a technical inside view of data?
answer
administrator
question
Whereas a relational database can store more than two dimensions, a multidimensional database is a two-dimensional table.
answer
false
question
A macro is a series of statements that instructs a program or app how to complete a task.
answer
true
question
Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?
answer
principle of least privilege
question
In a database which of the following is a connection within the data?
answer
relationship
question
What does each byte in the ASCII coding scheme represent?
answer
single character
question
What is another term for data dictionary?
answer
repository
question
Which term does a user of a relational database use to refer to a file?
answer
table
question
What is the term for a feature that has a graphical user interface to assist users with retrieving data?
answer
QBE
question
A data dictionary contains details about data. What term is used to describe this characteristic?
answer
metadata
question
Check digits are the only type of validity check that is NOT able to validate data accuracy.
answer
false
question
Which of the following contains data about each file in the database and each field in those files?
answer
data dictionary
question
Which of the following refers to the different formats to represent or store data for use by humans and computer applications?
answer
variety
question
What is a more user-friendly interface some users use instead of interacting directly with a DBMS?
answer
front-end
question
In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?
answer
backward
question
What is the term for a collection of data organized in a manner that allows access, retrieval, and use of that data?
answer
a database
question
Which of the following identifies the quality of data in a database?
answer
data integrity
question
What type of database are organizations MOST LIKELY to use for payroll, accounts receivable, inventory, and invoicing?
answer
relational
question
What is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?
answer
field
question
Key fields link data together in a database.
answer
true
question
Data integrity is important because computers and people use information to make decisions and take actions.
answer
true
question
You store all of your photographs on a website that uses a database to store the photos users post. What is this type of database called?
answer
collaborative database
question
What does the S in SQL stand for?
answer
Structured
question
Your database was damaged due to hardware failure. What can you use to restore it?
answer
a backup
question
A form that sends entered data across a network or the Internet is called which of the following terms?
answer
e-form
question
Some report generators allow you to create a webpage, which can be interactive.
answer
true
question
More than 30 years ago, the first macro viruses wreaked havoc with personal computers.
answer
false
question
After a power failure, you instruct the DBMS to use the log to reenter any changes made to the database since the last save or backup. What term is used to describe this backup technique?
answer
forward recovery
question
You create a computer-aided design database that stores data including a list of components of an item being designed, the relationship among the components, and previous versions of the design drafts. Which data model did you use?
answer
multidimensional
question
SQL stands for which of the following?
answer
Structured Query Language
question
Metadata describes the widespread growth of data, the variety of formats in which this data is available, and the processing required to make this data accessible in a timely manner.
answer
False
question
What is a feature that has a graphical user interface to assist users with retrieving data?
answer
QBE
question
Which of the following statements best describes a form?
answer
a window on the screen that provides areas for entering or modifying data in a database
question
Which of the following statements is NOT true about multidimensional databases?
answer
Most multidimensional databases use a standard query language.
question
What company did Larry Ellison help found?
answer
Oracle
question
Which of the following is NOT considered a part of file maintenance?
answer
the creation of a new database
question
What is the process of comparing data with a set of rules or values to determine if the data meets certain criteria?
answer
validation
question
Which of the following does a back end interact with?
answer
DBMS
question
A file is a group of related fields.
answer
false
question
A compiler is a separate program that converts the entire source program into machine language before executing it.
answer
true
question
What type of database exists in many separate locations throughout a network or the Internet?
answer
distributed
question
Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?
answer
access
question
If you are running a check that applies a formula to the primary key, what kind of check are you running?
answer
check digit
question
Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?
answer
validity check
