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) |
MIS 2223 Ch. 11 Quiz
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price