1Z0-062 · Question #229
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?
The correct answer is B. Database Vault in ORACLE_HOME D. Database Resident Connection Pooling. Of the listed options, DBCA can configure Database Vault and Database Resident Connection Pooling for an existing database, but not Label Security, backup strategies, or non-default block size tablespaces.
Question
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?
Options
- AConfigure Label Security
- BDatabase Vault in ORACLE_HOME
- COracle Suggested BackupStrategy
- DDatabase Resident Connection Pooling
- ENondefault blocksize tablespaces
How the community answered
(21 responses)- A5% (1)
- B90% (19)
- C5% (1)
Why each option
Of the listed options, DBCA can configure Database Vault and Database Resident Connection Pooling for an existing database, but not Label Security, backup strategies, or non-default block size tablespaces.
Oracle Label Security requires configuration through its own administrative API (SA_SYSDBA package) or Enterprise Manager, and is not available as a DBCA option for managing an existing database.
DBCA provides a dedicated option to configure Oracle Database Vault on an existing database when the Database Vault binaries are present in ORACLE_HOME, allowing DBAs to enable its realm and rule-based access controls post-creation. This avoids the need for manual SQL-based configuration of the Database Vault owner and account manager accounts.
Applying an Oracle Suggested Backup Strategy is performed through RMAN scripting or EM Cloud Control backup wizards, not through DBCA's existing database configuration options.
DBCA allows enabling and configuring Database Resident Connection Pooling (DRCP) for an existing database, which establishes a server-side shared connection pool. DRCP reduces the overhead of creating dedicated server processes for each client connection, and DBCA handles setting the pool parameters through its interface.
Creating tablespaces with non-default block sizes is a SQL DDL operation requiring the CREATE TABLESPACE ... BLOCKSIZE clause, and DBCA does not expose this as a configuration option for existing databases.
Concept tested: DBCA configuration options for existing Oracle databases
Source: https://docs.oracle.com/database/121/ADMIN/create.htm
Topics
Community Discussion
No community discussion yet for this question.