Free Access to Oracle.1Z0-083.v2025-12-01.q154 with Valid Practice Test (Page 20)

Question 91

Which three are true about requirements for various flashback operations?

A.flashback version query requires undo to retrieve all versions of a row that existed between two points in time.
B.flashback drop requires that the recyclebin parameter be set to on.
C.flashback drop requires undo to retrieve all versions of a row that existed between two points in time.
D.flashback data archive requires undo to store all versions of all rows of a table being tracked.
E.flashback version query requires that the recyclebin parameter be set to on.
F.flashback transaction query requires undo to retrieve all versions of a row that existed between two points in time.

Question 92

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

A.It recompiles all stored PL/SQL code by using utlrp.sql.
B.It empties the RECYCLE BIN.
C.It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
D.It sets all user tablespaces to "read-only" before starting the upgrade.
E.It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
F.It increases tablespace size, if required, to meet upgrade requirements.

Question 93

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

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

Question 94

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.All archive logs created after this backup are kept for two years.
B.The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
C.The SPFILE is included in the self-contaied archival backup.
D.The restore point is a label for the system change number (SCN) before the archival backup was taken.
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.

Question 95

Which two are true about common objects? (Choose two.)

A.They can be created only in CDB$ROOT.
B.They can be extended data-linked in CDB$ROOT.
C.They can exist in user-defined schemas only in application containers.
D.They can be created only in an application root.
E.They can be only metadata-linked in an application container.
F.They can exist in CDB$ROOT and an application root.

Question 91

Question 92

Question 93

Question 94

Question 95

Download PDF File