Oracle Database Administration II — Question 65

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

Answer options

• A. defining primary keys for all tables to speed up all queries
• B. using check constraints to speed up updates
• C. defining foreign keys for all tables to speed up joins
• D. the physical data model
• E. the configuration of storage arrays

Correct answer: D, E

Explanation

The correct answers, D and E, are essential because the physical data model influences how data is structured and accessed, while the configuration of storage arrays impacts the speed and efficiency of data retrieval. Options A, B, and C, while relevant to database design, do not directly address broader performance planning aspects like physical modeling and storage configuration.