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
Answer: 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.
Explanation:
https://docs.oracle.com/cd/E17559_01/em.111/e16599/appdx_creating_db_templates.htm
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
khan
Highly Voted 5 years, 8 months agojackymak
Most Recent 2 years, 8 months ago