MIS.CHP 11

Which of the following statements is NOT true about the database approach?

A disadvantage to the database approach is isolated data.

Which of the following statements is NOT true about object-oriented databases (OODBs)?

A voice mail system is an example of a groupware database.

Which of the following does a back end interact with?

DBMS

Which of the following is true about the database approach?

Data in a database is less vulnerable than data in file processing systems.

Who was the inventor of the relational database model?

E.F.Codd

What is data redundancy?

Each department has its own files, so the same data might be stored in multiple files

Like a form, a report generator is used to maintain and retrieve data

False

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.

False

With a distributed database, the data is accessible through a variety of servers.

False

Which of the following is an advantage of a multidimensional database?

It can store data in two dimensions.

Which of the following statements is NOT true about multidimensional databases?

Most multidimensional databases use a standard query language.

Which of the following stores data in objects?

OODB

What company did Larry Ellison help found?

Oracle

Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

Principle of least privilege

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

QBE

What is a feature that has a graphical user interface to assist users with retrieving data?

QBE

What is the term for a feature that has a graphical user interface to assist users with retrieving data?

QBE

A compiler is a separate program that converts the entire source program into machine language before executing it.

True

Multiple dimensions allow users to access and analyze any view of the database data.

True

Analysts often refer to the three ____'s when describing characteristics of Big Data.

V

Your database was damaged due to hardware failure. What can you use to restore it?

a backup

In a database, what is the smallest unit of data a user accesses?

a field

In your school's database, in which of the following is all of the information about a particular student stored?

a record

Which of the following statements best describes a form?

a window on the screen that provides areas for entering or modifying data in a database

Which of the following privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data?

access

In managing a company's database, which of the following roles requires a technical inside view of data?

administer

Which of the following kind of checks is a validity check performed on data, which ensures users enter only alphabetic data into a field?

alphabetic

Which of the following, with regard to the entire database, should be made on a regular basis?

backup

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

backward

If you are running a check that applies a formula to the primary key, what kind of check are you running?

check digit

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?

collaborative database

A user of a database such as that pictured in the accompanying figure refers to a field as what?

column

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

continuous

What was Megan's Law designed to do?

create a list of names and addresses of people convicted of crimes against children

Which of the following contains data about each file in the database and each field in those files?

data dictionary

Which of the following consists of rules and standards that define how a database organizes data?

data model

Which of the following does NOT improve with the database approach?

data security

Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?

data warehouse

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

database

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?

distributed

Most data items are stored in only one file, which greatly reduces _____

duplicate data

A form that sends entered data across a network or the Internet is called which of the following terms?

e-form

A data mart defines how users view the organization of the data.

false

A database eliminates redundant data.

false

A file is a group of related fields

false

A relational database stores data in objects

false

A relational database typically processes and summarizes large numbers of records efficiently.

false

All DBMSs have built-in backup utilities.

false

Check digits are the only type of validity check that is NOT able to validate data accuracy.

false

DBMSs that maintain inactive data for an extended period of time seldom flag records.

false

DBMSs will process flagged records unless an instruction is issued to ignore them.

false

Data in a database is less vulnerable than data in file processing systems

false

In a file processing system, each department or area in an organization shares files collectively.

false

In a forward recovery, the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

false

Many database programs today have a webpage as their back end.

false

More than 30 years ago, the first macro viruses wreaked havoc with personal computers.

false

One application that uses multidimensional databases is an object-oriented database

false

The graphical interface, called a fourth-generation language, allows system developers to drag and drop objects to build programs and apps.

false

With the database approach, most data items are stored in multiple files, which greatly reduces duplicate data.

false

You cannot maintain data in a database by importing data.

false

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?

field

What is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

field

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?

file

Which of the following is a window on the screen that provides areas for entering or modifying data in a database?

form

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

forward

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?

forward recovery

What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

front end

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

front end

Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?

log

A data dictionary contains details about data. What term is used to describe this characteristic?

metadata

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?

multidimensional

Which of the following is an item that contains data, as well as the actions that read or process the data?

object

What database term is used to describe a request for specific data from the database?

query

Which of the following is NOT a way that a DBMS deals with deleting records from a database?

records cannot be deleted from a DBMS

What type of database are organizations MOST LIKELY to use for payroll, accounts receivable, inventory, and invoicing?

relational

Which of the following is a database that stores data in tables that consist of rows and columns?

relational

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?

relational

What is another term used for data dictionary?

repository

A user of a database such as that pictured in the accompanying figure refers to a record as what?

row

Which term does a user of a relational database use to refer to a record?

row

What does each byte in the ASCII coding scheme represent?

single character

What is DBMS?

software

A user of a database such as that pictured in the accompanying figure refers to a file as what?

table

Which term does a user of a relational database use to refer to a file?

table

Compared with relational databases, which of the following is true of object-oriented databases?

they store data in objects

What involves showing users exactly how they will use the new hardware and software in the system?

training

A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed.

true

A web database usually resides on a database server.

true

ASP.NET is a web application framework that provides the tools necessary for the creation of dynamic websites.

true

An application generator is a program that creates source code or machine code from a specification of the required functionality.

true

Key fields link data together in a database.

true

Many organizations use relational databases for payroll, accounts receivable, accounts payable, general ledger, inventory, order entry, invoicing, and other business-related functions.

true

Some report generators allow you to create a webpage, which can be interactive

true

The data in a database is independent of programs that access that data.

true

To reduce data entry errors, well-designed forms should validate data as it is entered

true

A table that has rows and columns is what type of table?

two-dimensional

What is the process of comparing data with a set of rules or values to determine if the data meets certain criteria?

validation

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?

validation

Which of the following refers to the different formats to represent or store data for use by humans and computer applications?

variety