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.