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?
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 database in the new location.
CORRECT ANSWER: D
Since the wording do not explicitly ask for the new database to reside on a different server, option D would be a better option, with less effort too.
https://docs.oracle.com/database/121/ADMQS/GUID-30EAECFB-26D2-4D97-8450-75838B8229F4.htm
• From an existing database (structure as well as data)
You can create a new template that has both the structural information and physical data files of an existing database. Databases created using such a template are identical to the source database. User-defined schemas and their data will be part of the created template. The source database must be local. Select this option when you want a template from which you can create an exact replica of the source database.
What about data? you only create a database using the template with no data…
I think A is the only correct answer