Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:
CREATE PLUGGABLE DATABASE pdb1
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT)
CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ;
Which three are true about PDB1?
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)
CDB1 and CDB2 must be in shared undo mode.
A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
Cloning HR_ROOT automatically clones HR_PDB1.
The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.
A container database, CDB1, contains a pluggable database PDB1.
Another container database is called CDB2.
You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time.
Which three are required?
CDB1 must be in archivelog mode.
CDB2 must be in shared UNDO mode only.
CDB1 and CDB2 must be in shared UNDO mode.
CDB2 must be in archivelog mode.
CDB1 and CDB2 must both be in local UNDO mode.
And PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in
The CDB. Data file 24 of PDB2 was deleted and you need to restore and
Recover it.
The only RMAN backup that exists was created with the BACKUP
DATABASE command while connected to CDB$ROOT. Which three are true?
(Choose three.)
1) CDB1 and CDB2 are two container databases.
2) PDB1 is a pluggable database in CDB1.
3) PDB1_C1_SRV is a service for PDB1.
4) CDB1_LINK is a database link in CDB2 referring to PDB1.
5) CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database
Default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1
FROM PDB1@CDB1_LINK -
SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');
Which two are true? (Choose two.)
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.
1, 3, 5, 8, 6, 10
1, 3, 5, 6, 10
1, 3, 5, 7, 10
1, 2, 5, 7, 4, 10
Parameters.
Identify four RMAN commands that produce a multi-section Backup.
BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
Command in RMAN? (Choose all that apply.) choose two
It is used to change failure priority only for HIGH or LOW priorities.
It is used to execute the advised repair script.
It is used to change failure priority only for the CRITICAL priority.
It is used to explicitly close the open failures.
我来回答: