|
What is the smallest unit of data the computer can process? |
bit |
|
A DBMS provides a variety of techniques to restore a database to a useable form in case it is damaged or destroyed. |
true |
|
Data redundancy decreases the chance of errors |
false |
|
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 optical disc? |
file |
|
What is DBMS? |
software |
|
What is the process that large databases use to find patterns and relationships among data? |
data mining |
|
What does the S in SQL stand for? |
structured |
|
DBMSs will process flagged records unless an instruction is issued to ignore the. |
False |
|
Which term is used to describe the practice that user’s access privileges are limited to the lowest level necessary to preform required tasks? |
principle of least privilege |
|
A DBMS uses which of the following to preform validation checks? |
data dictionary |
|
As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data? |
SQL |
|
To what does the term GIGO refer? |
data integrity |
|
Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS? |
front end |
|
Which of the following is true about the database approach? |
Selected |
|
Whereas a relational database can store more than two dimensions, a multidimensional database is a two-dimensional table. |
false |
|
Data redundancy decreases the chance of errors. |
false |
|
Which of the following statements is not true about the multidimensional database? |
Most multidimensional databases use a standard query language. |
|
CAE aids in the development and testing of product designs, and often includes CAD. |
True |
|
Which of the following statements about data types is not true? |
text data types are used for lengthy memos |
|
Which of the following is not considered a part of file maintenance? |
the creation of a new database |
|
Which of the following is not a way that DBMS deals with deleting records from a database? |
records cannot be deleted from a DBMS |
|
A user of a database such as that pictured in the accompanying figure refers to a field as what? |
column |
|
Which of the following does not improve with the database approach? |
data security |
|
Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions? |
continuous |
|
To reduce data entry error, well-designed forms should validate data as it is entered. |
True |
|
Which term does a user of a relational database use to refer to a record? |
row |
|
Which of the following statements is not true about multidimensional databases? |
Most multidimensional databases use a standard query language. |
|
Which of the following contains a database that helps a group or department make decisions? |
data mart |
|
A user of database such as that pictured in the accompanying figure refers to a recovered what? |
row |
|
A relational database typically processes and summarizes large numbers of records efficiently. |
False |
|
Key fields link data together in a database. |
True |
|
Which of the following kinds of checks is a validity check preformed on data, like that accompanying figure, ensures user enter only alphabetic data into a field? |
alphabetic |
|
What database term is used to describe a request for specific data from the database? |
query |
|
In your school’s database, in which of the following is all of the information about a particular student stored? |
a record |
|
Application best suited for relational databases are those whose data van be organized in a two-dimensional table. |
True |
|
Which term does the developer of a relational database use to describe a file? |
relation |
|
An application that supports a front-end program sometimes is called which of the following? |
back end |
|
You cannot maintain data in a database by importing data. |
false |
|
Which of the following consists of rules and standards that define how a database organizes data? |
data model |
|
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 |
|
Verifiable information can be proven as correct or incorrect. |
true |
|
In managing a company’s database, which of the following |
administrator |
|
Key fields link data together in a database |
true |
|
Which of the following of checks is a validity check preformed on data, like that in accompanying which ensures users enter only numeric data into a field? |
numeric |
|
Which of the following is a process designed to ensure the data within the relations (tables) contains the least amount of duplication? |
normalization |
|
Which of the following kinds of values is the one that a DBMS initially displays in a field? |
default |
|
Which of the following, with regard to the entire database, should be made on a regular basis? |
backup |
|
What term does a user of a relational database use to refer to a file? |
table |
|
Query by example uses a graphical user interface that assists users with retrieving data. |
True |
Share This
Flashcard
