MIS 2223 Ch. 11 Quiz

Your page rank:

Total word count: 1811
Pages: 7

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

Which of the following is not one of the qualities associated with identifying the value of information?

Expensive

In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period.

False

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

Backward

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

Continuous

Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

Continuous Backup

Which of the following is not true about the database approach?

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

Accurate information is error free.

True

What is the smallest unit of data the computer can process?

bit

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

A voicemail system is an example of a groupware database.

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

Row

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

True

All DBMSs have built-in backup utilities.

False

Timely information has an age suited to its use.

True

Verifiable information can be proven as correct or incorrect.

True

Which of the following kind of checks is a validity check on data like that in the accompanying figure, which determines whether a number is within a specified group of numbers?

Range

CAE aids in the development and testing of product designs, and often includes CAD.

True

Which of the following stores data in objects?

OODB

In a relational database, users can set up a relationship between tables at any time, but the tables must have a common row or field.

False

Whereas a relational database can store more than two dimensions, a multidimensional database is a two-dimensional table.

False

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

Check Digit

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

Metadata

It is often easier and faster to develop programs that use the database approach.

True

What is data redundancy?

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

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

False

Key fields link data together in a database.

True

Query by example uses a graphical user interface that assists users with retrieving data.

True

As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data?

SQL

A common reason to change a record is to update old data with new data.

True

What company did Larry Ellison help found?

Oracle

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

Which of the following contains a database that helps a group or department make decisions?

Data Mart

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

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

Table

What is the term for a collection of data organized in a manner that allows access, retrieval, and use of that data?

A Database

The developer of a relational database refers to a file as which of the following?

Relation

Which of the following is true in a relational database?

Each row has a primary key and each column has a unique name.

Object-oriented and object-relational databases often use a query language to manipulate and retrieve data. What is the name of this query language?

OQL

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

Backup

What is DBMS?

Software

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.

True

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

Administrator

What is another name for a database analyst?

Data Modeler

For a computer to produce correct information, the data that is input into a database must have integrity.

True

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

False

The developer of a relational database refers to a record as which of the following?

Tuple

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

Validity Check

Which term does the developer of a relational database use to describe a file?

Relation

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

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

Log

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

It can consolidate data much faster than a relational database.

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

While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

Guides you through the steps of creating a database object

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

False

In a relational database, where does the only data redundancy exist?

In the Fields

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

Front End

What is the process that large databases use to find patterns and relationships among data?

Data Mining

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?

Multi-dimensional

A larger version of a data warehouse is the data mart.

False

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 alphabetic data into a field?

Alphabetical

Which of the following about data types is not true?

Text data types are used for lengthy memos.

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

Form

A web database usually resides on a database server.

True

In a database such as that pictured in the accompanying figure, users can set up a relationship between tables at any time, but the tables must have which of the following in common?

A Column

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

Data Model

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

False

Which of the following is not true about the database approach?

A disadvantage to the database approach is isolated data.

Which of the following kinds of values is the one that DBMS initially displays in a field?

Default

A file is a group of related fields.

False

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

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

Object

Which of the following statements best describes a form?

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

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

e-form

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

True

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

They store unstructured information less efficiently.

What is the process of comparing data with a set of rules or values to find out if the data is correct?

Validation

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

True

Which term does the developer of a relational database use to describe a record?

Tuple

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

True

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?

Check Digit

To what does the term GIGO refer?

Data Integrity

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

One application that uses multidimensional databases is a data warehouse.

True

Which of the following kinds of programs interacts with a DBMS, which in turn interacts with the database?

Front End

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?

Read-Only

Which of the following is not true about multidimensional databases?

Most multidimensional databases use a standard query language.

The developer of a relational database refers to a field as which of the following?

Attribute

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

False

To assist with sound decision making, the information must have value.

True

Data integrity is important because computers and people use information to make decisions and take actions.

True

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

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

Materials Requirements Planning controls production equipment, such as drills, latches, and milling machines.

False

What does the S in SQL stand for?

Structured

Which kind of database stores data in dimensions?

Multidimensional

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?

Enterprise Resource Planning (ERP)

Share This
Flashcard

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more

NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message
sending