What is the best method to create the replica?

After being hired as a database administrator, you find that there is only one database that is functional and that is being accessed by the applications. You want to create a replica of the database, to be used for testing purposes. What is the best method to create the replica?

After being hired as a database administrator, you find that there is only one database that is functional and that is being accessed by the applications. You want to create a replica of the database, to be used for testing purposes. What is the best method to create the replica?

A.
create a database by using CREATE DATABASE .. command and manually copy the data

B.
use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure

C.
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

D.
use DBCA to create a template from the existing database to contain the database structure and then manually copy the data using Oracle Data Pump



Leave a Reply 0

Your email address will not be published. Required fields are marked *