Which two statements are true about the Database Configuration Assistant (DBCA)?

Question

Options

• AIt can configure Automatic Storage Management (ASM) diskgroups.
• BIt can be used to copy an existing Oracle database to a new host and apply any patches
• CIt can be used to add a new tablespace.
• DIt can be used to create a database template from an existing database.
• EIt can generate SQL database creation scripts.

• A
  4% (2)
• B
  12% (6)
• C
  4% (2)
• D
  80% (39)

Explanation

D is correct because DBCA explicitly supports creating database templates from existing databases - this is one of its core features, allowing you to capture a database's structure (and optionally data) as a reusable template.

E is correct because DBCA can generate SQL scripts (such as CREATE DATABASE scripts) rather than executing the creation directly, which is useful for auditing, customization, or manual execution later.

Why the distractors are wrong:

• A - ASM diskgroup configuration is handled by ASMCA (ASM Configuration Assistant), not DBCA.
• B - DBCA can clone/duplicate databases, but applying patches is the job of OPatch, not DBCA.
• C - Adding tablespaces is done via SQL (CREATE TABLESPACE) or Enterprise Manager; DBCA focuses on database-level creation and configuration, not ongoing schema management.

Memory tip: Think of DBCA as a database-lifecycle tool - it creates, deletes, configures, and templates entire databases. Anything that sounds like day-to-day DBA work (tablespaces, patches) belongs to other tools. The acronym hint: DBCA handles Databases and Designs (templates + scripts).

No community discussion yet for this question.