nerdexam
Oracle

1Z0-062 · Question #228

You want to create a database and you have the following: - Oracle Grid Infrastructure is installed and configured. - Oracle Database Vault is installed in ORACLE_HOME to be used for this database…

The correct answer is D. 1, 2, 3, 4, 6, 8, 9 and 10. When using DBCA to create a database with Grid Infrastructure, Database Vault in ORACLE_HOME, and an EM Cloud Control agent already deployed, most requirements are configurable through DBCA except Database Vault (automatically enabled by the ORACLE_HOME installation) and EM…

Exploring the Oracle Database Architecture

Question

You want to create a database and you have the following: - Oracle Grid Infrastructure is installed and configured. - Oracle Database Vault is installed in ORACLE_HOME to be used for this database. - Oracle Enterprise Manager Cloud Control isavailable and an agent is deployed on the database server. Examine the requirements: 1. configuring the database instance to support shared server mode 2. using Automatic Storage Management (ASM) for storing database files. 3. configuring a naming methodto help a remote user connect to a database instance 4. configuring the Fast Recovery Area 5. configuring Database Vault 6. configuring Enterprise Manager (EM) Database Express 7. registering with EM Cloud Control 8. configuring remote log archive destinations 9. enabling daily incremental backups 10. configuring a nondefault block size for nondefault block size tablespaces Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

Options

  • A1, 2, 4, 5,7, 8, 9 and 10
  • B1, 2, 4, 5, 6 and 7
  • C1, 2, 3, 8, 9 and 10
  • D1, 2, 3, 4, 6, 8, 9 and 10
  • E1, 2, 4, 5, 6, 7 and 8

How the community answered

(47 responses)
  • A
    11% (5)
  • B
    19% (9)
  • C
    4% (2)
  • D
    64% (30)
  • E
    2% (1)

Why each option

When using DBCA to create a database with Grid Infrastructure, Database Vault in ORACLE_HOME, and an EM Cloud Control agent already deployed, most requirements are configurable through DBCA except Database Vault (automatically enabled by the ORACLE_HOME installation) and EM Cloud Control registration (auto-discovered via the deployed agent).

A1, 2, 4, 5,7, 8, 9 and 10

This option incorrectly omits naming method configuration (3), which DBCA supports, and incorrectly treats Database Vault (5) as a standalone DBCA step when it is automatically handled by the ORACLE_HOME installation.

B1, 2, 4, 5, 6 and 7

This option omits naming method (3), remote log archive destinations (8), incremental backups (9), and the 10th requirement, all of which are configurable within DBCA during database creation.

C1, 2, 3, 8, 9 and 10

This option omits Fast Recovery Area (4) and EM Database Express (6), both of which are standard DBCA configuration options available during database creation.

D1, 2, 3, 4, 6, 8, 9 and 10Correct

DBCA natively supports configuring shared server mode (1), ASM storage (2), naming methods such as local naming via tnsnames.ora (3), the Fast Recovery Area (4), EM Database Express (6), remote log archive destinations (8), daily incremental backups (9), and the 10th requirement during database creation. Database Vault (5) is omitted because it is automatically configured as part of database creation when already installed in ORACLE_HOME, and EM Cloud Control registration (7) is omitted because the already-deployed agent handles discovery without a separate DBCA step.

E1, 2, 4, 5, 6, 7 and 8

This option incorrectly includes EM Cloud Control registration (7) as a discrete DBCA task when the agent already deployed on the server handles auto-discovery, making an explicit DBCA registration step unnecessary.

Concept tested: DBCA database creation tasks with pre-installed Grid Infrastructure and Database Vault

Source: https://docs.oracle.com/database/121/ADMIN/create.htm

Topics

#database creation#DBCA#shared server#ASM#Oracle Database Vault

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice