You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier. The number of…

Question

Options

• Aa General Purpose database template with default memory allocation
• Ba Data Warehouse database template, with t he dedicated server mode option and AMM
• Ca General Purpose database template, with t he shared server mode option and Automatic
• Da default database configuration

• A
  11% (2)
• B
  5% (1)
• C
  79% (15)
• D
  5% (1)

Explanation

Option C is correct because the scenario explicitly describes two conditions that point to Shared Server mode: applications connecting via a middle tier and a high number of concurrent connections. Shared Server allows many clients to share a smaller pool of server processes, which is far more scalable in this context. The General Purpose template is correct for a mixed workload (both OLTP and nightly BI queries), and AMM (Automatic Memory Management) handles dynamic memory tuning for that variability.

Why the distractors fail:

• A uses General Purpose (correct template) but leaves memory and connection mode at defaults - it doesn't address the high-concurrency/middle-tier requirement with Shared Server.
• B picks the Data Warehouse template, which is optimized for read-heavy analytical workloads only, not mixed workloads. It also specifies Dedicated Server mode, which spawns one process per connection - the opposite of what high concurrency demands.
• D a default configuration makes no targeted decisions at all and ignores every stated requirement.

Memory tip: Use the phrase "Middle tier = Share the server." Whenever a question mentions a middle tier (app server, connection pool) plus high concurrency, that's the signal for Shared Server mode. Pair it with General Purpose whenever the workload is described as "mixed," and reserve the Data Warehouse template only for pure analytics environments.

No community discussion yet for this question.