Which three RMAN persistent settings can be set explicitly? (Choose three.)
You wish to create jobs to satisfy these requirements:1. Automatically bulk load data from a flat file.2. Rebuild indexes on the SALES table after completion of the bulk load.How would you create these jobs?
One of the four database suffered an instance failure.At the next startup, from which point in the redo logs does instance recovery begin?
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.You create a common role c##role1 with the create table and select any table privileges.You then execute the commands:Which two statements are true?
Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;SQL> CREATE ROLE c##role1 CONTAINER=ALL;SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;SQL> REVOKE c##role1 FROM c##a_admin;What is the result of the revoke command?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
