CH 1 430
DBMS is software used for the following purpose:
A) Creation of databases B) Insertion, storage, retrieval, update, and deletion of the data in the database C) Maintenance of databases ALL OF THE ABOVE
Which of the following is a component of a database system?
A) Database B) DBMS C) Front-end applications ALL OF THE ABOVE
Requirements can be refined and/or expanded following:
A) Database deployment B) Logical modeling C) Database use ALL OF THE ABOVE
Which of the following is an example of a daily operational procedure or task supported by an operational database?
A) Deducting the correct amount of money from a customer's checking account upon an ATM withdrawal B) Issuing a correct bill to a customer who purchased an airline ticket BOTH A & B
End users can vary in:
A) Their level of technical sophistication B) The amount of data they need C) The frequency with which they access the database system ALL OF THE ABOVE
Which of the following is a part of the database requirements step?
Conceptual modeling
The difference in the scope of databases is reflected in the:
Cost in time and resources required for each of the development steps
Database implementation involves using ________ to implement the database model as an actual database
DBMS
Joe is an example of:
Data
Which of the following is typically found in the database metadata?
Data Types
________ are in charge of implementing the database model as a functioning database using the DBMS software
Database developers
Which of the following requires that the end user knows how to issue commands to the specific DBMS?
Direct interaction
A DBMS is a presentation software (such as MS Power Point).
FALSE
Analytical databases collect and present operational information in support of daily operational procedures and processes.
FALSE
Databases of different scope are developed following different fundamental development steps.
FALSE
During a proper requirements collection process, the requirements can be added iteratively and implicitly.
FALSE
Front-end applications are created in order to provide a mechanism for easy interaction between the database and the DBMS.
FALSE
Indirect interaction requires that the end user knows how to issue commands to the specific DBMS.
FALSE
Information that is collected in database systems can be used, in general, for two purposes: an operational purpose and a transactional purpose.
FALSE
Metadata is a subset of data that is most recently entered.
FALSE
The logical database model is created prior to the conceptual database model.
FALSE
The terms data and information should never be used as synonyms for each other.
FALSE
The type of interaction between the end user and the database that involves front-end applications is called direct interaction.
FALSE
Implicit changes of requirements are permitted during:
Implicit changes of requirements are not permitted
Front-end applications facilitate:
Indirect use
Which of the following is an example of analytical information?
Information showing which airline routes in the United States have the most sales
FirstName is an example of:
Metadata
The description of the structure and the properties of the data fits into which category?
Metadata
Which of the following is a database use action?
Modifying data
A DBMS can be used for creation of databases.
TRUE
A DBMS can be used for insertion and retrieval of the data in the database.
TRUE
Analytical information is based on operational information.
TRUE
Conceptual data modeling is another term for requirements visualization.
TRUE
Database administration encompasses the tasks related to the maintenance and supervision of a database system.
TRUE
The new version of a database is created following the same development steps as the initial version.
TRUE
The term data refers to facts that are recorded and can be accessed.
TRUE
The term information refers to the data that is accessed by a user for some particular purpose.
TRUE
The term operational information refers to the information collected and used in support of day-to-day operational needs.
TRUE