Q&A Hero

Q: Installation and fine tuning are part of the ____ phase of the SDLC.a. planning b. analysis c. detailed systems designd. implementation

Q: Coding, testing, and debugging are part of the ____ phase of the SDLC.a. planning b. analysis c. detailed systems designd. implementation

Q: A detailed system specification is part of the ____ phase of the SDLC.a. planning b. analysis c. detailed systems designd. implementation

Q: User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.a. planning b. analysisc. detailed systems design d. implementation

Q: The initial assessment and the feasibility study are part of the SDLC's ____ phase.a. planning b. analysis c. detailed systems designd. implementation

Q: The traditional SDLC is divided into ____ phases.a. two b. three c. fourd. five

Q: The primary objective of database design is ____. a. to create the most efficient database possible b. to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models c. to create the fastest queries d. to be able to add data quickly

Q: The process of database design and implementation is ____ development.a. systems b. database c. networkd. transformation

Q: The process of creating an information system is known as ____ development.a. systems b. databasec. network d. transformation

Q: Decentralized design is typical of relatively simple and/or small databases and can be successfully done by a single person.

Q: Physical design becomes simpler when data is distributed at different locations.

Q: The database administrator must be prepared to perform routine maintenance activities within the database.

Q: Performance evaluation is rendered more difficult by the fact that there are standard measurements for database performance.

Q: Database performance is one of the least important factors in all database implementations.

Q: The testing and evaluation phase occurs after applications programming.

Q: Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules.

Q: In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.

Q: After the initial declarations in a study, the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.

Q: To analyze the company situation, the database designer must discover what the company's operational components are, how they function, and how they interact.

Q: A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.

Q: Because every request for structural changes requires retracing the SDLC steps, the system is always at some stage of the SDLC.

Q: After testing is concluded, end-user training is not necessary.

Q: During the testing phase, the system is subjected to exhaustive testing until it is ready for use.

Q: During the implementation phase, the hardware, the DBMS software, and application programs are installed and the database design is implemented.

Q: The detailed systems design phase includes all the necessary technical specifications for the screens, menus, reports, and other devices used to make the system more efficient.

Q: Training principles and methodologies are planned during the implementation phase.

Q: In the detailed systems design phase, steps are laid out for conversion from the old system to the new system.

Q: In the detailed systems design phase, the designer starts the design of the system's processes.

Q: The result of analysis should be a better understanding of the system's functional areas, actual and potential problems, and opportunities.

Q: The existing hardware and software systems are studied during the planning phase.

Q: Problems defined during the planning phase are examined in greater detail during the analysis phase.

Q: The SDLC's planning phase yields a general overview of the company and its objectives.

Q: The SDLC provides the big picture within which the database design and application development can be mapped out and evaluated.

Q: The SDLCtraces the history of an information system.

Q: The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.

Q: The primary objective in database design is to create complete, denormalized, redundant, and fully integrated conceptual, logical, and physical database models.

Q: The term "database development" is used to describe the process of database design and implementation.

Q: Systems analysis is used to determine the need for an information system and to establish its limits.

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