db"orq"

gold image-based installation in Oracle

18c and later releases?

can or cannot be performed by users

with the SYSBACKUP privilege?

target database and the recovery catalog database .In which two cases would an

automatic full resynchronization occur

between this target databases control file and the RMAN recovery catalog?

Infrastructure for a Standalone Server

using Oracle Universal Installer (OUD.
There is no existing Oracle installation on the server.
Which two are prerequisites?

Home Provisioning of Oracle software?

APP1_ROOT
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1

CONTAINER-CURRENT;
Which is true?

ARCHIVELOG mode.

FULL RMAN backups are taken daily 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?

two pluggable databases PDB1 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 CDBSROOT
Which three are true?

（含图）

$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba

SQL> ALTER SESSION SET CONTAINER=app1_root;

Session altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE '1.0' TO '2.0';

Pluggable database altered.

SQL> GRANT CREATE SESSION TO USER1;

Grant succeeded.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE TO '2.0';

Pluggable database altered

SQL> ALTER SESSION SET CONTAINER=app1_pdb1;

Session altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC;

Pluggable database altered.