Q&A Hero

Q: Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful.

Q: Describe the five types of users identified in a database system.

Q: What are some reasons for studying file systems?

Q: Discuss some considerations when designing a database.

Q: What are the advantages of having the DBMS between the end user's applications and the database?

Q: Describe what metadata are and what value they provide to the database system.

Q: A(n) ____________________ develops when all required changes in the redundant data are not made successfully.

Q: ____________________ exists when the same data are stored unnecessarily at different places.

Q: ____________________ exists when different and conflicting versions of the same data appear in different places.

Q: The term _________________________ refers to scattered locations storing the same basic data.

Q: ____________________ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.

Q: In early computer file systems, a(n) ___________________________________ was hired to create a computer-based system that would track data and produce required reports.

Q: ___________________________________ is a special language used to represent and manipulate data elements in a textual format.

Q: ____________________ databases focus primarily on storing data used to generate information required to make tactical or strategic decisions.

Q: A(n) ____________________ is a specific request issued to the DBMS for data manipulation.

Q: A(n) ___________________________________ is a collection of programs that manages the database structure and controls access to the data stored in the database.

Q: ____________________ is data about data through which the end-user data are integrated and managed.

Q: Data ____________________ is a discipline that focuses on proper generation, storage and retrieval of data.

Q: Raw data must be properly ____________________ for storage, processing and presentation.

Q: To reveal meaning, information requires ____________________.

Q: ____________________ is the result of processing raw data to reveal its meaning.

Q: ____ relates to the activities that make the database perform more efficiently in terms of storage and access speed.a. Performance tuning b. Database designc. Query access d. Database management

Q: The phrase ____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.a. database management system b. database managementc. management system d. database system

Q: A ____ is a character or group of characters that has a specific meaning.a. database b. fieldc. record d. file

Q: A ____ is a collection of related records.a. databaseb. fieldc. column d. file

Q: A ____ is a logically connected set of one or more fields that describes a person, place, or thing.a. database b. column c. recordd. file

Q: The organization of the data within the folders in a manual file system was determined by ____.a. the date of creationb. its expected use c. the title of the documents in the folder d. the data processing specialist

Q: XML data is ____.a. structuredb. multistructured c. unstructuredd. semistructured

Q: Which of the following is an example of structured data?a. A Web pageb. An e-mail c. A memo d. A spreadsheet

Q: Most data you encounter is best classified as ____.a. structuredb. semistructured c. unstructured d. historical

Q: ____ data are the result of formatting to facilitate storage, use and generation of information.a. Structured b. Semistructured c. Unstructuredd. Historical

Q: ____ data exist in a format that does not lend itself to processing that yields information.a. Structured b. Semistructuredc. Unstructured d. Historical

Q: ____ data exist in the format in which they were collected.a. Structured b. Semistructuredc. Unstructured d. Historical

Q: ____ is a set of tools that work together to provide an advanced data analysis environment for retrieving, processing, and modeling data from the data warehouse.a. Online analytical processing b. Semistructured processing c. Enterprise processingd. XML processing

Q: Most decision-support data are based on historical data obtained from ____.a. operational databases b. data warehousesc. enterprise databases d. workgroup databases

Q: A desktop database is a ____ database.a. single-user b. multiuser c. workgroupd. distributed

Q: A workgroup database is a(n)____ database.a. single-user b. multiuser c. enterprised. distributed

Q: A ____ database supports data distributed across several different sites.a. single-user b. multiuser c. centralizedd. distributed

Q: A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.a. desktop b. workgroup c. enterprised. transactional

Q: A(n) ____ database is used by an organization and supports many users across many departments.a. desktop b. workgroup c. enterprised. transactional

Q: A(n) ____ database is designed to support a company's day-to-day operations.a. desktop b. workgroup c. enterprised. transactional

Q: The response of the DBMS to a query is the ____.a. ad hoc query b. ad hoc response c. query result setd. integrated view of the data

Q: ____ exists when different versions of the same data appear in different places.a. Data inconsistency b. Data consistency c. Better data integrationd. Improved decision making

Q: A(n) ____ might be written by a programmer or it might be created through a DBMS utility program.a. query b. operating system c. database management systemd. application program

Q: The database structure in a DBMS is stored as a ____.a. file b. collection of files c. set of key/value pairsd. collection of queries

Q: The ____ serve(s) as the intermediary between the user and the database.a. DBMS b. metadata c. end-user datad. programming language

Q: ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.a. Queries b. End-user data c. Metadatad. Information

Q: End-user data is ____. a. raw facts about the end-user b. raw facts of interest to the end-user c. data about data d. accurate, relevant and timely information

Q: ____ is the body of information and facts about a specific subject.a. Data b. Informationc. Knowledged. A database

Q: Accurate, relevant, and timely information is the key to ____.a. data management b. good decision making c. knowledged. understanding

Q: ____ is used to reveal the meaning of data.a. Raw facts b. Knowledge c. Formattingd. Information

Q: One advantage of a database system over previous data management approaches is that the database system is considerably less complex.

Q: One disadvantage of a database system over previous data management approaches is increased costs.

Q: A query language is a procedural language.

Q: Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

Q: Initially the files within a computer file system were similar to manual files.

Q: Historically, a manual file system was composed of a system of file folders and filing cabinets.

Q: Corporations use only structured data.

Q: The same data might be simultaneously structured and unstructured depending on the intended processing.

Q: A data warehouse can store data derived from many sources.

Q: An operational database is sometimes referred to as an enterprise database.

Q: One disadvantage of the DBMS is that it increases the risk of data security breaches.

Q: The DBMS reveals much of the database's internal complexity to the application programs and users.

Q: Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.

Q: The only way to access the data in a database is through the DBMS.

Q: Metadata present a more complete picture of the data in the database than the data itself.

Q: Data constitute the building blocks of information.

Q: Information implies familiarity, awareness, and understanding knowledge as it applies to an environment.

Q: We are now said to be entering the "knowledge age."

Q: Data processing can be as simple as organizing data to reveal patterns.

Q: Data and information are essentially the same thing.

Q: Configure GridView control for customer table so that you can update an existing record of your choice.

Q: Using DetailsView control, delete the record you added in question 92.

Q: Using DetailsView control, update a record of your choice in customer table.

Q: Using DetailsView control, insert a new record of your choice into customer table.

Q: Exposures is a specialty retailer of fine gifts, picture frames, albums, scrapbooks, as well as occasional gift ideas. Visit their Web site at www.exposureonline.com, and using the registration, billing, catalog, and shopping cart screens below, go through each of the five ER design steps.For questions 92-96, please refer to the preceding paragraph and web screens.Configure DetailsView control for customer table in exposures database so that new records can be inserted and existing records updated and deleted.

Q: Configure GridView control for flower table so that you can update an existing record of your choice.

Q: Using DetailsView control, delete the record of you inserted in question 89.

Q: Using DetailsView control, update a record of your choice in flower table.

Q: Using DetailsView control, insert a new record of your choice into flower table.