多选题 A database is configured in ARCHIVE LOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)
2023-07-27
共580道
相关试题
单选题 How do you confi gure a CDB for local undo mode?
单选题 Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed.No changes have been made to the standard PDB$SEED.How many default temporary tablespaces can be assigned in the CDB?
单选题 Choose the best 答案. Examine this output of an export from the current release of an Oracle multitenant database: $$ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$$pdbs; NAME OPEN_MODE --------------------------------------- PDB$$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $$ expdp system/oracle full=y What is the outcome?
单选题 Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: 1) Install the SALES_APP application, including the common tables, in the application root. 2) Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. 3) Create an application seed. 4) Install the SALES_APP application in the application seed. 5) Create the SALES_APP1 and SALES_APP2 application PDBs. 6) Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
7) Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed. 8) Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?
单选题 Examine this configuration: 1) CDB1 is a container database running in ARCHIVELOG mode. 2) Multiple uncommitted transactions are running in CDB1. 3) Redo log groups 1 and 2 are INACTIVE. 4) Redo log group 3 is the CURRENT group. All members of redo log group 3 are lost before it is archived. Examine these possible steps: 1) SHUTDOWN ABORT 2) STARTUP NOMOUNT
3) STARTUP MOUNT 4) ALTER DATABASE MOUNT 5) RESTORE DATABSE 6) RECOVER DATABASE NOREDO 7) RECOVER DATABASE UNTIL AVAILABLE 8) RESTORE ARCHIVELOG ALL 9) ALTER DATABSE OPEN 10)ALTER DATABASE OPEB RESETLOGS Choose the minimum required steps in the correct order to recover the database.
多选题 Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
单选题 A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?
多选题 A database is configured in ARCHIVE LOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required? (Choose two.)
