Database MCQS
1. The design of data structures and the documentation of that design produces a set of:
a. Data tables
b. Data files
c. Data models
d. Data procedures
2. In a data model data is organized into:
a. Process steps
b. Tables
c. Logical objects
d. Data objects
3. A data model plays a key role in achieving good data quality by:
a. Reducing performance concerns
b. Avoiding unnecessary index creation
c. Establishing a common understanding of what is to be held in each table and column
d. Creating a complete set of documentation for future expansion
4. The recommended approach for handling the issues of performance of a proposed database design model is to:
a. Reduce the number of tables as much as possible
b. Create any needed index's on table with large amounts of data
c. Develop the data model without considering any performance-related issues and then implement it with the available hardware and software
d. Establish a testing approach to identify potential issues
5. Rapid Application Development (RAD) and the use of prototyping can bring many benefits to a development project, but this does not eliminate the need for:
a. A good data model developed early in the project
b. A complete set of documentation for system enhancements
c. A good three-schema architecture
d. Well-designed index structures to avoid performance issues.