nerdexam
Oracle

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.

Managing the Database Instance

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)
  • A
    5% (1)
  • B
    90% (19)
  • C
    5% (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.

AConfigure Label Security

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.

BDatabase Vault in ORACLE_HOMECorrect

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.

COracle Suggested BackupStrategy

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.

DDatabase Resident Connection PoolingCorrect

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.

ENondefault blocksize tablespaces

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

#DBCA#database configuration#Database Vault#DRCP

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice