Which four statements regarding the Clone Database tool are correct? (Choose four.)
A.
It clones Oracle databases from release 8.1.7 or later.
B.
It clones a source database while the database is in NOMOUNT state.
C.
It clones a source database while the database is in MOUNT state.
D.
It clones an Oracle database by using Recovery Manager (RMAN).
E.
It clones a source database at the specified Oracle home and starts the new database instance in the open mode.
F.
It clones a source database and makes the new database instance consistent with the source database up to the backup time of archived log.
Explanation:
Note: The question is wrong. There isn’t a "CLONE DATABASE tool". There are only DBCA and RMAN tools to clone a database.
Observation: If we want to clone a database using the DBCA, first we create a database template; after that dosen’t matter if the database source is in NOMOUNT or MOUNT state.
Cloning Databases Using DBCA
The "Template Management" section of the Database Configuration Assistant (DBCA) can be used to clone databases. The following method creates a clone of and existing database including both the structure and the data:
1. Start the Database Configuration Assistant (DBCA).
2. On the "Welcome" screen click the "Next" button.
3. On the "Operations" screen select the "Manage Templates" option and click the "Next" button.
4. On the "Template Management" screen select the "Create a database template" option and select the "From and existing database (structure as well as data)" sub-option then click the "Next" button.
5. On the "Source database" screen select the relevant database instance and click the "Next" button.
6. On the "Template properties" screen enter a suitable name and description for the template, confirm the location for the template files and click the "Next" button.
7. On the "Location of database related files" screen choose either to maintain the file locations or to convert to OFA structure (recommended) and click the "Finish" button.
8. On the "Confirmation" screen click the "OK" button.
9. Wait while the Database Configuration Assistant progress screen gathers information about the source database, backs up the database and creates the template.
By default the template files are located in the "$ORACLE_HOME/assistants/dbca/templates" directory.
Correct answer is ACDF