1z0-067 Free Practice Test

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user. The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user.
A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open.
In the CATD3i2c database, you execute the commands:
: r-ar.
RKAN> CONNECT CATALOG rci2c/passI2c@catdbi2c
RKAN> IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; What is the outcome of the import?

1. A. It fails because the target database and recovery catalog database are of different versions.
2. B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.
3. C. It succeeds but the database is not automatically registered in the rc:2c catalog.
4. D. It fails because RMAN is not connected to the target database with r3:T=:42324:.

Correct Answer: B

The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user. The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user. A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands: Srman
RMAN> CONNECT CATALOG rc12c/pass12c@catdbI2c
RMAN> IMPOST CATALOG rc1l/pwdcatl11@catdbl1 DBID=I423241; What is the outcome of the import?

1. A. It fails because the target database and recovery catalog database are of different versions.
2. B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
3. C. It succeeds but the database is not automatically registered in the Rc12c catalog.
4. D. It fails because RMAN is not connected to the target database with DBID=1423241.

Correct Answer: A
The version of the source recovery catalog schema must be equal to the current version of the destination recovery catalog schem
A. If they are not equal, then upgrade the schemas to the same version.
https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm#RCMRF198

In which situation can you use Flashback Database?

1. A. when undoing a shrink data file operation
2. B. when retrieving a dropped tablespace
3. C. when returning to a point in time before the restoration or re-creation of a control file
4. D. when returning to a point in time before the most recent open resetlogs operation

Correct Answer: D
TO BEFORE RESETLOGS Returns the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS. Note: FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to Oracle Database 10g Release 2 or later. http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194

Your database instance is started using an SPFILE. You are connected to cdb$root, as a DB

1. A. You issue:SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;Which two statements are true about the statistics level parameter?
2. B. It is immediately set to all in the SPFILE and the CDB instance.
3. C. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
4. D. It is immediately set to all only for cd3Sroot.
5. E. It is immediately set to all in all PDBs where the statistics_level parameter is not set.
6. F. It is set to all for all PDBs only in the SPFIL

Correct Answer: AD
When the STATISTICS_LEVEL parameter is modified by ALTER SYSTEM, all advisories or statistics are dynamically turned on or off, depending on the new value of STATISTICS_LEVEL. When modified by ALTER SESSION, the following advisories or statistics are turned on or off in the local session only.
Their system-wide state is not changed.

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

1. A. The backup as copy can only be taken to disk
2. B. The backup as copy can only be taken to tape
3. C. Backup can be performed only when the instance is shutdown
4. D. Backup will constitute all used and unused blocks in the database

Correct Answer: AD