1Z0-062 · Question #188
Which two statements are true about the Database Configuration Assistant (DBCA)?
The correct answer is D. It can be used to create a database template from an existing database E. It can generate SQL database creation scripts.. DBCA is primarily a database creation and configuration tool. It supports generating SQL scripts and creating templates from existing databases, but tablespace management and patching are handled by other tools.
Question
Which two statements are true about the Database Configuration Assistant (DBCA)?
Options
- AIt can be used to add an new tablespace
- BIt can be used to copy an existing Oracle database to a new host and apply any patches
- CIt can configure Automatic Storage Management (ASM) diskgroups.
- DIt can be used to create a database template from an existing database
- EIt can generate SQL database creation scripts.
How the community answered
(45 responses)- B2% (1)
- C4% (2)
- D93% (42)
Why each option
DBCA is primarily a database creation and configuration tool. It supports generating SQL scripts and creating templates from existing databases, but tablespace management and patching are handled by other tools.
Tablespace creation and management is performed through SQL commands (CREATE TABLESPACE) or Oracle Enterprise Manager, not through DBCA.
Copying a database to a new host is handled by RMAN duplicate or Data Pump, and applying patches is done with OPatch - neither is a DBCA function.
ASM diskgroup creation and configuration is performed by the ASM Configuration Assistant (ASMCA), not DBCA.
DBCA can connect to an existing database and export its structure and optionally its data into a reusable template file (.dbc/.dbt), which can later be used to create identically configured databases.
DBCA provides a 'Generate Database Creation Scripts' option that produces the full set of SQL and shell scripts needed to create the database manually, without actually executing the creation.
Concept tested: DBCA capabilities for template and script generation
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/creating-and-configuring-an-oracle-database.html
Topics
Community Discussion
No community discussion yet for this question.