1z0-074 Free Practice Test

Which three tasks are performed automatically byDatabase Upgrade Assistant (DBUA)when the
database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose three.)

1. A. It changes Oracle kernel parameters if required
2. B. It creates a restore point to restore the database if the upgrade fails
3. C. It drops all the invalid objects
4. D. It calls thecatctl.plscript to perform the upgrade process in parallel
5. E. It automatically resets theCOMPATIBLEparameter value to12.0.0
6. F. It modifies or creates new tablespaces as required

Correct Answer: BCD

APP1is an application container that has an application seed and two application PDBs,APP_PDB1andAPP_PDB2.
1.1 is the current version of the application. You execute this block in the application root:
<>

1. A. An error is thrown because the version number should be sequential, either 1.1 or 2.0.
2. B. An error is thrown because theCONTAINER=ALLclause is missing.
3. C. An error is thrown because thec##prefix is missing in the role name.
4. D. A common role is created only in the application root.
5. E. A common role is created only in the application root and application seed.
6. F. A common role is created in the application root, application seed,APP_PDB1, andAPP_PDB2.

Correct Answer: D

Examine this command:
<>

1. A. Up to four worker processes are allocated to export data and metadata
2. B. Four worker processes are allocated to export only data
3. C. Four worker processes are active to export only metadata
4. D. Four worker processes are allocated to export data and metadata
5. E. Four worker processes are allocated when there is sufficient CPU available

Correct Answer: D

ACDB,CDB1, has aLOCATIONSapplication container. NORTH_PDBandSOUTH_PDBare two application PDBs inLOCATIONS.
Both application PDBs are synchronized with the application installed in theLOCATIONS root… InCDB2, you create a remote clone,LOC_R, of theLOCATIONSapplication root.
You want to query data across theLOCATIONSapplication PDBs created inCDB1andCDB2. How can you do this?

1. A. by creating a proxy PDB inLOCATIONS_ROOTinCDB1, referencingLOC_R
2. B. by creating a proxy PDB inCDB1root, referencingLOC_R
3. C. by using private database links created inCDB1andCDB2
4. D. by using public database links created inCDB1andCDB2
5. E. by creating a proxy PDB inCDB2root, referencingLOC_R

Correct Answer: E

A multi-tenant container database (CDB) contains three PDBs.
Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)

1. A. The CDB should be inMOUNTstate.
2. B. The source and target platforms must have the same endianness.
3. C. TheCOMPATIBLEparameter must be set to 12.2 or greater in the CDB.
4. D. The source PDBs must be closed for a cross-platform PDB backup.
5. E. Flashback database must be enabled for the CDB.
6. F. The CDB must use Automatic Memory Management.

Correct Answer: BCD