Online Access Free 1Z1-083 Exam Questions

You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

• A.The restore point is a label for the system change number (SCN) before the archival backup was taken.
• B.All archive logs created after this backup are kept for two years.
• C.The SPFILE is included in the self-contaied archival backup.
• D.The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
• E.The control file is included in the self-contained archival backup.
• F.The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

Choose the best answer. Examine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
5. Each PDB has several tables with referential integrity constraints.
6. FLASHBACK DATABASE is ON.
7. UNDO RETENTION GUARANTEE is enabled.
Multiple undesired multitable changes were made in all the PDBs.
Which method can be used to undo the changes using a single command?

• A.flashback database
• B.flashback transaction
• C.restore and recover database
• D.flashback table and transaction
• E.flashback table

Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

• A.Run the SQL Tunning Advisor.
• B.Run the Memory Advisor for the shared pool.
• C.Run the SQL Access Advisor.
• D.Run the Memory Advisor for the System Global Area.
• E.Run the Memory Advisor for the Program Global Area.

Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)

• A.It can be used to upgrade only single-instance databases running on Oracle Restart.
• B.It can be used to deploy new homes without disrupting active databases.
• C.It can be used to patch existing Oracle software installations.
• D.It can be used to create templates of Oracle homes as gold images of only Oracle databases.
• E.It can be used only on nodes with Oracle Grid Infrastructure installed.
• F.It can be used to create a single-instance Oracle Database in an already-installed Oracle home.

Choose the best answer. Examine this configuration:
1. CDB1 is an Oracle container database from an older release.
2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command:
$ /u01/app/oracle/product/18.1.0/db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?

• A.CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3
• B.CDB$ROOT, PDB1, PDB2, PDB3, and PDB4
• C.CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4
• D.CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4
• E.CDB$ROOT, PDB2, PDB1, and PDB3