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