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

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

Answer :
  • 19C

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

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

Answer :
  • 8

What is new improvement being happen with LISTAGG function in 19c

Answer :
  • Distinct key word is added for removing duplicity in listagg function

The user in the local database must have _______ and _______ privileges in the CDB root Container for relocate pdb from remote pdb.

Answer :
  • Create session , create pluggable database

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

Answer :
  • 252

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

Answer :
  • orainstRoot.sh
  • root.sh