nerdexam
Oracle

1Z0-052 · Question #71

You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration…

The correct answer is C. 1, 2, 4, 5, and 6. DBCA can configure shared server mode, disable automatic maintenance tasks, use ASM storage, set up backup to FRA, and configure Enterprise Manager during database creation. However, configuring naming methods for remote connectivity is handled by Oracle Net Configuration…

Managing the Database Instance

Question

You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA). Some of the requirements set for your database creation task are: 1. Configure the database to operate in shared server mode. 2. Disable automatic maintenance tasks such as optimizer statistics collection. 3. Configure a naming method to help the remote user connect to the database instance. 4. Use Automatic Storage Management (ASM) for storing the database files. 5. Configure daily database backup to flash recovery area. 6. Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database?

Options

  • A4 and 6
  • B2, 3, 4, and 6
  • C1, 2, 4, 5, and 6
  • D1, 2, 3, 4, 5, and 6

How the community answered

(50 responses)
  • A
    6% (3)
  • B
    10% (5)
  • C
    82% (41)
  • D
    2% (1)

Why each option

DBCA can configure shared server mode, disable automatic maintenance tasks, use ASM storage, set up backup to FRA, and configure Enterprise Manager during database creation. However, configuring naming methods for remote connectivity is handled by Oracle Net Configuration Assistant (NETCA), not DBCA.

A4 and 6

This option omits requirements 1, 2, and 5, all of which are directly configurable within DBCA's creation wizard.

B2, 3, 4, and 6

This option excludes requirements 1 and 5 and incorrectly includes requirement 3; shared server and backup configuration are both available in DBCA, while naming methods are not.

C1, 2, 4, 5, and 6Correct

DBCA provides wizard screens for shared server connection mode (requirement 1), enabling or disabling automated maintenance tasks like statistics collection (requirement 2), selecting ASM as the storage mechanism (requirement 4), scheduling backup jobs to the flash recovery area (requirement 5), and registering the database with Enterprise Manager Database Control (requirement 6). Requirement 3 - configuring a naming method such as tnsnames.ora or LDAP - is outside DBCA's scope and belongs to NETCA.

D1, 2, 3, 4, 5, and 6

Requirement 3 - configuring a client-side naming method - cannot be fulfilled by DBCA; it requires a separate invocation of Oracle Net Configuration Assistant after database creation.

Concept tested: Oracle DBCA database creation configuration capabilities

Source: https://docs.oracle.com/cd/E11882_01/server.112/e22490/create.htm

Topics

#DBCA#database creation#ASM#shared server mode

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice