Online Access Free 1Z1-083 Exam Questions

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

• A.Tables with not null constraints cannot be recovered.
• B.Tables or table partitions with a foreign key cannot be recovered.
• C.Tables or table partitions from the system and sysaux tablespaces cannot be recovered.
• D.Tables or table partitions can be recovered only when the database is in mount state.
• E.Tables or table partitions can be recovered by using an auxiliary instance only.

Which two are true about automatic block repair? (Choose two.)

• A.It is not possible for media corrupt blocks.
• B.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
• C.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
• D.Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
• E.Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.

You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table?

• A.LOB segments associated with the CUSTOMERS table are flashed back.
• B.Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
• C.Materialized views that use the CUSTOMERS table are flashed back.
• D.All the triggers associated with the table are flashed back but are disabled.
• E.All the constraints defined on the table, except the referential integrity constraints, are flashed back.

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)

• A.Cloning HR_ROOT automatically clones HR_PDB1.
• B.CDB1 and CDB2 must be in shared undo mode.
• C.The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.
• D.A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
• E.All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

• A.It analyzes a period of time corresponding to the 12 hours of activity.
• B.Results are written to the alert log.
• C.It runs automatically after each AWR snapshot.
• D.It analyzes a period of time corresponding to the last day of activity.
• E.A DBA can run it manually.