OCP CBT Question 563

Please solve the following question.

You need to create a test database `TESTDB` on a separate server using a backup of your production database `PRODDB`. You want to use RMAN's `DUPLICATE` command for this purpose. Which statement about the `DUPLICATE` command is true?

RMAN Duplication Command
# On the auxiliary instance, start RMAN and connect to target and auxiliary:
# rman target sys/password@PRODDB auxiliary sys/password@TESTDB
# Then run the DUPLICATE command.

The DUPLICATE TARGET DATABASE command requires the auxiliary instance to be mounted with the PFILE of the target database.

The DUPLICATE TARGET DATABASE command can only be used to create a physical standby database.

The DUPLICATE TARGET DATABASE command automatically creates a control file for the auxiliary database if NOFILENAMECHECK is specified.

The DUPLICATE TARGET DATABASE FOR STANDBY command creates a standby database; omitting FOR STANDBY creates a non-standby clone.