Discovering Computers Ch. 11

25 July 2022
4.7 (114 reviews)
30 test answers

Unlock all answers in this set

Unlock answers (26)
question
Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions? -collaborative -continuous -dynamic -interactive
answer
continuous
question
Which term does a user of a relational database use to refer to a file? -relation -column -table -row
answer
table
question
An application that supports a front-end program sometimes is called which of the following? -RDBMS -GUI -collaborative database -back end
answer
back end
question
Which of the following consists of rules and standards that define how a database organizes data? -data model -object-relation -data standard -rules-based intergration
answer
data model
question
Which of the following kinds of programs interacts with a DBMS, which in turn interacts with the database? -after image -before image -back end -front end
answer
front end
question
What was Megan's Law designed to do? -compile a list of database techniques and processes to share with DBMS users -predict the accuracy of data in a database and ways to improve the data integrity -make unauthorized access or data entry in a database illegal -create a list of names and addresses of people convicted of crimes against children
answer
create a list of names and addresses of people convicted of crimes against children
question
In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup? -instant -forward -baseline -integrated
answer
forward
question
A user of a database such as that pictured in the accompanying figure refers to a record as what? -row -table -relationship -column
answer
row
question
Which of the following statements best describes a form? -a screen that enables a database user to add or delete tables -the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve data -a window on the screen that provides areas for entering or modifying data in a database -a formatted, printable retrieval of specific data
answer
a window on the screen that provides areas for entering or modifying data in a database
question
Compared with relational databases, which of the following is NOT true of object-oriented databases? -They allow programmers to reuse objects. -They store unstructured information less efficiently. -They access data faster. -They can store more types of data.
answer
They store unstructured information less efficiently.
question
What does the S in SQL stand for? -System -Structured -Serial -Server
answer
Structured
question
Which of the following statements is not true about object-oriented databases (OODBs)? -OODBs can store more types of data and access it faster than relational databases. -A voice mail system is an example of a groupware database. -An object is an item that contains data, as well as the actions that read or process the data. -An OODB stores unstructured data more efficiently than a relational database.
answer
A voice mail system is an example of a groupware database.
question
Which of the following contains a database that helps a group or department make decisions? -data speedset -data market -data warehouse -data mart
answer
data mart
question
If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running? -completeness -range -check digit -alphabetic
answer
completeness
question
Which of the following is true in a relational database? -Each row and each column has a primary key. -Each row has a primary key and each column has a unique name. -Each row and each column has a unique name. -Each row has a unique name and each column has a primary key.
answer
Each row has a primary key and each column has a unique name.
question
What is the term for the process of comparing data with a set of rules or values to find out if the data is correct? -query -validation -procedure -verification
answer
validation
question
Which of the following is not one of the qualities associated with identifying the value of information? -expensive -accurate -useful -verifiable
answer
expensive
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? -relational -object-relational -object-oriented -multi-dimensional
answer
multi-dimensional
question
Which of the following is a window on the screen that provides areas for entering or changing data in a database? -form -recovery screen -change screen -report
answer
form
question
Your database was damaged due to hardware failure. What can you use to restore it? -restoration hardware -imaging software -a backup -a wizard
answer
a backup
question
Which of the following statements is not true about relational databases? -To set up a relationship between tables, they must have a common field. -Applications best suited for relational databases are those whose data can be organized into a three-dimensional table. - A relationship is a link within the data. -Many organizations use relational databases for payroll, accounts receivable, order entry, and invoicing.
answer
Applications best suited for relational databases are those whose data can be organized into a three-dimensional table.
question
Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions? -data storehouse -data storage unit -data warehouse -data stockyard
answer
data warehouse
question
Which of the following is an advantage of a multidimensional database? -It can consolidate data much faster than a relational database. -All multidimensional databases have a dimension of time. -The content of all dimensions is the same regardless of the subject. -There is a common query language.
answer
It can consolidate data much faster than a relational database.
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 optical disc? -file -rubric -set -validator
answer
file
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? -identifier -member -field -record
answer
field
question
Which of the following integrates MRP II with the information flow across an organization to manage and coordinate the ongoing activities of the enterprise, including product planning, manufacturing and distribution, accounting and finance, sales, human resources, and customer support? -CAE -ERP -CMS -DMS
answer
ERP
question
The developer of a relational database refers to a file as which of the following? -attribute -record -tuple -relation
answer
relation
question
As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data? -DBMS -SQL -QBE -XML
answer
SQL
question
Which of the following manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions? -MRP -CRM -CAM -SFA
answer
CRM
question
Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only numeric data into a field? -numeric -consistency -completeness -range
answer
numeric