In Oracle Database 12c, when does a transaction begin?

• A. when the first executable SQL statement is encountered
• B. when a user explicitly issues a "begin" statement
• C. when a transaction is assigned to an available undo data segment to record undo entries for the new transaction
• D. when a transaction ID is allocated for it.

Which two statements are true when you execute an invoker's rights procedure?

• A. The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.
• B. Invoking users can control who can access their privileges when they run an invoker's rights procedure.
• C. The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.
• D. The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

After a ___________ statement is issued, a transaction ends. (select three)

• A. ROLLBACK
• B. SELECT
• C. COMMIT
• D. SAVEPOINT
• E. CREATE

Your customer has two CDBs: one for Production and one for development. You are asked to create a new development PDB (salesdev) from an existing production PDB (salesprd). Which two options would accomplish this?

• A. Connected as the salesprd local DBA, you create an XML using:
  SQL> ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO ' /tmp/salesprd-xml' ;
  Copy the XML file and all salesprd-related files to the target CDB and start plugging the copy into
  the development CDB using:
  SQL> CREATE PLUGGABLE DATABASE salesdev USING' /tmp/salesprd.xml';
• B. You alter the salesprd source database to open in read-only mode, and start cloning the source
  database:
  SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;
  SQL> CREATE PLUGGABLE DATABASE salesdev FROM salesprd;
• C. You copy all the PDBSSEEDdata files from the production CDB into the development CDB and
  execute this on the development CDB;
  SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm IDENTIFIED by
  password;
• D. You alter the salesprd source database to open in read-only mode:
  SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;
  In the development CDB, you create a databaselink "PRD" that connects to the root of the source
  CDB, and start cloning the source PDB:
  SQL> CREATE PLUGGABLE DATABASE salesdevFROM salesprd@prd;