1z0-083 Free Practice Test

Which three are true about the SQL Tuning Advisor? (Choose three.)

1. A. It checks each query being analyzed for stale statistics.
2. B. It checks each query being analyzed for missing statistics.
3. C. It only recommends syntactic changes to SQL statements.
4. D. It can recommend semantic changes to SQL statements.
5. E. It considers all SQLstatements being analyzed by the advisor task as a group.
6. F. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Correct Answer: ABF

Oracle Managed Files (OMF) is enabled in a CDB and thiscommand is successfully executed:
<>

1. A. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.
2. B. An application seed PDB is created for APP1.
3. C. An application root PDB is created for APP1.
4. D. A default service is created for the application root APP1.
5. E. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
6. F. APP1 can never be unplugged.

Correct Answer: ABE

Examine this configuration:
< ><>>< ><>

1. A. It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’
2. B. It will create ‘/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’.
3. C. It will re-create ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’
4. D. It will create ‘/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’.
5. E. It will fail because there is no autobackup of the controlfiles.

Correct Answer: C

Which three are true? (Choose three.)

1. A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs containedin the application container.
2. B. Application-common TSDP policies are always container specific.
3. C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
4. D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
5. E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
6. F. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-ENDblock.
7. G. Unified auditing can be automatically synchronized to all application PDBs in an applicationcontainer.

Correct Answer: ADG

Examine this command:
$ rhpctl move database –sourcehome Oracle_home_path –destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

1. A. to switch an existing Oracle Database home to anewer release of Oracle software on the same server
2. B. to switch to a read-only Oracle home
3. C. to switch back to the previous Oracle home as part of a rollback operation
4. D. to switch the Oracle Database home when using a centralized Rapid Home Provisioningserver
5. E. to switch to a patched Oracle Database home

Correct Answer: CE
You can use rhpctl move gihome command with the same syntax to switch from the current Oracle Grid Infrastructure home to a patched home. The rhpctl command enables you to switch from your current Oracle Grid Infrastructure or Oracle Database home to patched Oracle home so that you can provision the new Oracle home as gold image. You can also use the rhpctl command to switch back to the old Oracle home, if you want to roll back the operation.