Computer, Chapter 11
Unlock all answers in this set
Unlock answersquestion
A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?
answer
Read-only
question
A data dictionary contains details about data. What term is used to describe this characteristic?
answer
Metadata
question
A DBMS uses which of the following to perform validation checks?
answer
Data dictionary
question
A form that sends entered data across a network or the Internet is called which of the following terms?
answer
e-form
question
A table that has rows and columns is what type of table?
answer
two-dimensional
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 is backup technique?
answer
Forward recovery
question
An application that supports a front-end program sometimes is called which of the following?
answer
Back end
question
Analyst often refer to the three___'s when describing characteristics of Big Data.
answer
V
question
Compared with relational databases, which of the following is true of object-oriented databases?
answer
They store data in objects
question
Complex DBMSs maintain a listing of activities that modify the contents of a database. What is the listing called?
answer
Log
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
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?
answer
Completeness
question
In a database which of the following is a connection within the data?
answer
Relationship
question
In a database, what is the smallest unit of data user accesses?
answer
A field
question
In managing a company's database, which of the following roles requires a technical inside view of data?
answer
Administrator
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?
answer
Forward
question
In what kind of recovery does the DBMS use the log to undo changes made to a database during a certain period?
answer
Backward
question
In which of the following databases is the physical location of the server on which it is stored is transparent and often unknown, to the user?
answer
Distributed
question
In your school's database, in which of the following is all the information about a particular student stored?
answer
A record
question
Many database programs perform which of the following in order to analyze entered data help ensure that it is correct?
answer
Validity check
question
Most data items are stored in only one file, which greatly reduces____
answer
Duplicate data
question
SQL stand for which of the following?
answer
Structured Query Language
question
What company did Larry Ellison help found?
answer
Oracle
question
What database term is use to describe a request for specific data from the database?
answer
Query
question
What does each byte in the ASCII coding scheme represent?
answer
Single character
question
What does the S in SQL stand for?
answer
Structured
question
What involves showing users exactly how they will use the new hardware and software in the system?
answer
Training
question
What is a database that stores data in tables that consists of rows and columns?
answer
Relational database
question
What is a feature that has a graphical user interface to assist users with retrieving data?
answer
QBE
question
What is more user-friendly interface some users use instead of interacting directly with a DBMS?
answer
front end
question
What is another term for a data dictionary?
answer
Repository
question
What is data redundancy?
answer
Each department has its own files, so the same data might be stored in multiple files
question
What is DBMS?
answer
software
question
What is the process of comparing data with a set of rules or vales to determine if the data meets certain criteria
answer
Validation
question
What is the process of presenting data graphically as charts, maps, or other pictorial formats in order to understand the resulting information easily?
answer
Data visualization
question
What is the smallest unit of data the computer can process?
answer
Bit
question
What is the term for a collection of data organized in a manner that allows access, retrieval, and use of the data?
answer
A database
question
What is the term for a feature that has a graphical user interface to assist users with retrieving data?
answer
QBE
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?
answer
Validation
question
What type of database are organizations MOST LIKELY to use for payroll, accounts receivable, inventory, and invoicing?
answer
relational
question
What type of database exists in many separate locations throughout a network or the Internet?
answer
distributed
question
What was Megan's Law designed to do?
answer
Create a list of names and addresses of people convicted crimes against children
question
What kind of database stores data in dimensions?
answer
Multidimensional
question
Which of the following consists of rules and standards that define how a database organizes data?
answer
Data model
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 does a back end interact with?
answer
DBMS
question
Which of the following does NOT improve with the database approach?
answer
Data security
question
Which of the following identifies the quality of data in a database?
answer
Data integrity
question
Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?
answer
Database
question
Which of the following is a database that stores data in tables that consist of rows and columns?
answer
Relational
question
Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?
answer
Data warehosue
question
Which of the following is a nonprocedural language that enables users and software developers to access data in a database?
answer
4GL
question
Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?
answer
Check digit
question
Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?
answer
front end
question
Which of the following is a query language that allows users to manage, update, and retrieve data?
answer
SQL
question
Which of the following is a request for specific data from a database?
answer
Query
question
Which of the following is a window on the screen that provides areas for entering or modifying data in a database
answer
Form
question
Which of the following is an advantage of multidimensional database?
answer
It can store data in two dimensions.
question
Which of the following is an item that contains data, as well as the actions that read or process data?
answer
Object
question
Which of the following is NOT a way that a DBMS deals with deleting records from a database?
answer
Records cannot be deleted fro ma DBMS
question
Which of the following is NOT considered a pat of file maintenance?
answer
The creation of a new database
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
Which of the following of checks is a validity check on data, which determines whether a number is within a specified group of numbers?
answer
Range
question
Which of the following kind of checks is a validity check performed on data, which ensures users ensures enter only alphabetic data into a field?
answer
Alphabetic
question
Which of the following kind of checks is a validity check performed a data, which ensures users enter only numeric data into a field?
answer
Numeric
question
Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?
answer
Continuous
question
Which of the following kinds of values is the one that a DBMS initially displays in a field?
answer
Default
question
Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?
answer
Query
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
Which of the following refers to the different formats to represent or store data for use by humans and computer applications?
answer
Variety
question
Which of the following statements about data types is FALSE?
answer
Text data types are used for lengthy memos
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 FALSE about relational databases?
answer
Applications best suited for relational databases are those whose data can be organized into a three-dimensional table
question
Which of the following statements is NOT true about multidimensional databases?
answer
Most multidimensional databases use standard query language
question
Which of the following statements is NOT true about object-oriented databases (OODBs)?
answer
A voice mail system is an example of groupware database
question
Which of the following statements is NOT true about the database approach?
answer
A disadvantage to the database approach is isolated data.
question
Which of the following stores data in objects?
answer
OODB
question
Which of the following, with regard to the entire database, should be made on regular basis?
answer
Backup
question
Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?
answer
Continuous backup
question
Which term describes a huge database that stores and manages data required to analyze historical and current transactions?
answer
Data warehouse
question
Which term does a user of a relational database use to refer to a file?
answer
Table
question
Which term does a user of relational database use to refer to a record?
answer
Row
question
Which term is use 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
Who was the inventor of the relational database model?
answer
E. F. Codd
question
You are creating a database for your computer club. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?
answer
Make it the default value
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
You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?
answer
Relational
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
Your database was damaged due to hardware failure. What can you use to restore it?
answer
A backup
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
