Oracle Database 12c: Installation and Administration — Question 17

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 is available 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 method to 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)?

Answer options

• A. 1, 2, 4, 5, 7, 8, 9 and 10
• B. 1, 2, 4, 5, 6 and 7
• C. 1, 2, 3, 8, 9 and 10
• D. 1, 2, 3, 4, 6, 8, 9 and 10
• E. 1, 2, 4, 5, 6, 7 and 8

Correct answer: D

Explanation

The correct answer is D because the Database Configuration Assistant (DBCA) can handle the requirements for shared server mode, ASM for database files, configuring the Fast Recovery Area, configuring Database Vault, enabling daily incremental backups, and setting a nondefault block size. Options A, B, C, and E include requirements that cannot be completed through DBCA, such as configuring a naming method or Enterprise Manager Database Express.