Oracle Database 12c: Installation and Administration — Question 30

You want to create a test database as a replica of your production database with minimum intervention from a DBA.
Which method would you use?

Answer options

• A. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.
• B. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.
• C. Create the database by using the CREATE DATAEASE. . . command and manually import data by using Data Pump.
• D. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the

Correct answer: A

Explanation

The correct answer, A, is appropriate as it allows for the creation of the database structure while enabling data transfer with minimal manual intervention. Option B does not involve data transfer, so it would not meet the requirement of replicating the production database fully. Option C is incorrect as it involves more manual steps, and D is incomplete and does not present a viable solution.