Which term describes a huge database that stores and manages data required to analyze historical and current transactions? |
Data Warehouse |
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 statements is NOT true about the database approach? |
A disadvantage to the database approach is isolated data |
T/F 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 |
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 |
T/F A data model defines how the operating system actually arranges the data on the disk |
False |
T/F Key fields link data together in a database |
True |
T/F Machine language is the only language the computer directly recognizes |
True |
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 |
A user of a database such as that pictured in the accompanying figure refers to a file as what? |
Table |
Which of the following identifies the quality of data in a database? |
Data Integrity |
T/F With a distributed database, the data is accessible through a variety of servers |
False |
What is a feature that has a graphical user interface to assist users with retrieving data? |
QBE |
T/F The data in a database is independent of programs that access that data |
True |
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 privileges for data involve establishing who can enter new data, change existing data, delete unwanted data, and view data? |
Access |
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 |
T/F A data mart defines how users view the organization of the data |
False |
Which of the following is a request for specific data from a database? |
Query |
Which of the following, with regard to the entire database, should be made on a regular basis? |
Backup |
An application that supports a front-end program sometimes is called which of the following? |
Back end |
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 |
Which of the following is an item that contains data, as well as the actions that read or process the data? |
Object |
T/F Software developers sometimes use the languages to maintain legacy systems |
True |
T/F Each higher level of data consists of one or more items from the lower level |
True |
Which of the following is an advantage of a multidimensional database? |
It can store data in two dimensions |
Which of the following consists of rules and standards that define how a database organizes data? |
Data Model |
In managing a company’s database, which of the following roles requires a technical inside view of data? |
Administrator |
If you are running a check that applies a formula to the primary key, what kind of check are you running? |
Check Digit |
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 |
What company did Larry Ellison help found? |
Oracle |
T/F A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed |
True |
A data dictionary contains details about data. What term is used to describe this characteristic? |
Metadata |
Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store? |
Query |
T/F For a computer to produce correct information, the data that is input into a database must have integrity |
True |
What involves showing users exactly how they will use the new hardware and software in the system? |
Training |
T/F In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period |
False |
T/F DBMSs that maintain inactive data for an extended period of time seldom flag records |
False |
T/F The graphical interface, called a fourth-generation language, allows system developers to drag and drop objects to build programs and apps |
False |
T/F DBMSs will process flagged records unless an instruction is issued to ignore them |
False |
SQL stands for which of the following? |
Structured Query Language |
Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions? |
Data warehouse |
T/F A compiler is a separate program that converts the entire source program into machine language before executing it |
True |
Which of the following refers to the procedures that keep data current? |
File Maintenance |
Which of the following contains data about each file in the database and each field in those files? |
Data Dictionary |
Which term does a user of a relational database use to refer to a record? |
Row |
What is DBMS? |
Software |
T/F A database eliminates redundant data |
False |
T/F Like a form, a report generator is used to maintain and retrieve data |
False |
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 refers to the different formats to represent or store data for use by humans and computer applications? |
Variety |
T/F All DBMSs have built-in backup utilities |
False |
Which of the following stores data in objects? |
OODB |
T/F An application generator is a program that creates source code or machine code from a specification of the required functionality |
True |
T/F In a file processing system, each department or area in an organization shares files collectively |
False |
What is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses? |
Field |
A form that sends entered data across a network or the Internet is called which of the following terms? |
e-form |
T/F ASP.NET is a web application framework that provides the tools necessary for the creation of dynamic websites |
True |
T/F A relational database stores data in objects |
False |
Which of the following statements is NOT true about multidimensional databases? |
Most multidimensional databases use a standard query language |
What is the smallest unit of data the computer can process? |
Bit |
T/F A file is a group of related fields |
False |
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 |
T/F Query by example uses a graphical user interface that assists users with retrieving data |
True |
Most data items are stored in only one file, which greatly reduces _____ |
Duplicate Data |
What is the term for a collection of data organized in a manner that allows access, retrieval, and use of that data? |
a database |
T/F Data in a database is less vulnerable than data in file processing systems |
False |
Which of the following is a query language that allows users to manage, update, and retrieve data? |
SQL |
T/F One application that uses multidimensional databases is a data warehouse |
True |
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 |
T/F A macro is a series of statements that instructs a program or app how to complete a task |
True |
What is data redundancy? |
Each department has its own files, so the same data might be stored in multiple files. |
Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field? |
Check Digit |
T/F Some report generators allow you to create a webpage, which can be interactive |
True |
T/F Whereas a relational database can store more than two dimensions, a multidimensional database is a two-dimensional table |
False |
Which of the following statements about data types is FALSE? |
Text data types are used for lengthy memos |
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 another term for data dictionary? |
Repository |
T/F Big Data refers to large-scale data sets that require advanced technologies |
True |
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 |
T/F To reduce data entry errors, well-designed forms should validate data as it is entered |
True |
What is the term for a feature that has a graphical user interface to assist users with retrieving data? |
QBE |
Which of the following is a window on the screen that provides areas for entering or modifying data in a database? |
Form |
A user of a database such as that pictured in the accompanying figure refers to a record as what? |
Row |
T/F You cannot maintain data in a database by importing data |
False |
T/F Most data items are stored in only one file, which greatly reduces _____ |
Duplicate Data |
T/F A data model defines how users view the organization of data |
True |
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 |
T/F With the database approach, most data items are stored in multiple files, which greatly reduces duplicate data |
False |
Which of the following kind of checks is a validity check on data, which determines whether a number is within a specified group of numbers? |
Range |
Which of the following kind of checks is a validity check performed on data, which ensures users enter only numeric data into a field? |
Numeric |
What does the S in SQL stand for? |
Structured |
T/F Many organizations use relational databases for payroll, accounts receivable, accounts payable, general ledger, inventory, order entry, invoicing, and other business-related functions |
True |
Which of the following statements is FALSE about relational databases? |
Applications best suited for relational databases are those whose data can be organized into a three-dimensional table |
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 |
What is a database that stores data in tables that consist of rows and columns? |
relational database |
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 is true about the database approach? |
Data in a database is less vulnerable than data in file processing systems |
In a database, what is the smallest unit of data a user accesses? |
a field |
What type of database exists in many separate locations throughout a network or the Internet? |
Distributed |
Which of the following kind of checks is a validity check on data, which determines whether a number is within a specified group of numbers? |
Range |
T/F 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 |
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 |
T/F Data redundancy decreases the chance of errors |
False |
Who was the inventor of the relational database model? |
E. F. Codd |
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 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 |
T/F 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 |
T/F Data integrity is important because computers and people use information to make decisions and take actions |
True |
T/F More than 30 years ago, the first macro viruses wreaked havoc with personal computers |
False |
MIS 2223 Chapter 11 Quiz
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price