Free Access to Oracle.1Z0-083.v2022-09-01.q174 with Valid Practice Test (Page 30)

Question 141

Which three are true about Database Point-in-Time Recovery? (Choose three.)

A.The database must be open RESETLOGS after Database Point-in-Time Recovery.
B.Thedatabase must be in MOUNT state when performing Database Point-in-Time Recovery.
C.The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
D.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
E.The target point for the recovery must bespecified as a stime or System Change Number (SCN).
F.The Database must be in ARCHIVELOG mode.

Question 142

Which two are true about RMAN duplexed backup sets? (Choose two.)

A.A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.
B.A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.
C.A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.
D.A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.
E.A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.
F.A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

Question 143

Examine the command for creating pluggable database PDB2 in container database CDB2. Select three options, any one of which is required for it to execute successfully. (Choose three.)

A.Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
B.Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
C.Add only the CREATE_FILE_DEST clause to the statement.
D.Enable only OMF.
E.Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
F.Set only the PDB_FILE_NAME_CONVERT parameter.

Question 144

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

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

Question 145

Which two are true about server-generated alerts? (Choose two.)

A.Stateful alerts must be created by a DBA after resolving the problem.
B.Stateless alerts can be purged manually from the alert history.
C.Stateless alerts can be cleared manually.
D.Stateless alerts are automatically cleared.
E.Stateful alerts are purged automatically from the alert history.

Question 141

Question 142

Question 143

Question 144

Question 145

Download PDF File