Reference no: EM131109167

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.