READ Free Dumps For Oracle- 1z0-050
Question ID 1889 | You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. |
Option A | A. The tablespace having Flashback Archive is dropped. |
Option B | B. The Flashback Archive FLA1 is dropped only if it is empty. |
Option C | C. The Flashback Data Archive and historical data are dropped. |
Option D | D. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive. |
Correct Answer | D |
Question ID 1890 | You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. |
Option A | A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database. |
Option B | B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database. |
Option C | C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure. |
Option D | D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database. |
Correct Answer | B |