Oracle Database 19c: New Features for Administrators Ed 1 Quiz Questions and Answers

The protection allows Oracle DBAs or common users to ______, _______, _______, and _______ PDBs and other operations when Database Vault Operations Control is manually disabled. (Select all that apply)

Answer :
  • patch
  • back up
  • restore
  • upgrade

The _________parameter in the SYS.CONFIGURE_DV procedure allows you to define the scope of the DV_OWNER role grant operation.

Answer :
  • FORCE_LOCAL_DVOWNER

Which method is introducing in 19c, for automatic execution of fixups scripts and root.sh ?

Answer :
  • We can use, user provided root or sudo credentials for automatic failed prerequisites checks, for automatic execution of fixups and root.sh scripts.

How we can increase performance of export / import TTS in Oracle Database ?

Answer :
  • By using tablespace in keep_read_only

In which version of the database we can grant administrator privileges to and from schema-only accounts?

Answer :
  • 19C

Oracle Database 19c supports automatic execution of the ______ and ______ shell scripts using the user-provided root or sudo credentials.

Answer :
  • orainstRoot.sh
  • root.sh

What is the new features in pdb?

Answer :
  • PDB SNAPSHOT

In Oracle Database 19c, Decreasing the time of data pump TTS export and import operations by bypassing steps.

Answer :
  • Skips the rebuild of the bitmap to reclaim free space that is left unused
  • Leaves the tablespace read-only

How many PDB's We can create in 19c Container Database ?

Answer :
  • 252

How many snapshot we can create in 19c Database per PDB?

Answer :
  • 8