E is false.
SQL> CREATE LOCKDOWN PROFILE app_root_prof2;
CREATE LOCKDOWN PROFILE app_root_prof2
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
for me B , D and E are all correct according to documentation? https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-LOCKDOWN-PROFILE.html#GUID-1CDEC3A3-F3F1-4279-9370-36AACF416E0A why is E incorrect ?
confused, it can be created in app root, CDB Root, and specific PDBs as per documentation:
If you set PDB_LOCKDOWN while connected to a particular PDB, then the lockdown profile applies to that PDB and overrides the lockdown profile for the CDB or application container, if one exists.
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-LOCKDOWN-PROFILE.html#GUID-1CDEC3A3-F3F1-4279-9370-36AACF416E0A
"When a lockdown profile is assigned to a PDB, users in that PDB cannot perform the operations that are the disabled for the profile. To assign a lockdown profile, set its name for the value of the PDB_LOCKDOWN initialization parameter. You can assign a lockdown profile to individual PDBs, or to all PDBs in a CDB or application container, as follows:"
B: If you set PDB_LOCKDOWN while connected to an application root, then the lockdown profile applies to the application root and all PDBs in the application container.
D: If you set PDB_LOCKDOWN while connected to a CDB root, then the lockdown profile applies to all PDBs in the CDB. It does not apply to the CDB root.
as per documentation, lockdown profiles can be created in cdb$root and application root.
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
antonica
3 months, 2 weeks agogedde
4 months, 2 weeks agogreenday5494
7 months, 2 weeks agogreenday5494
7 months, 2 weeks ago_gio_
1 year agofrankkk
1 year, 5 months agojackymak
1 year, 5 months agohilaire
1 year, 6 months agovkra
1 year, 4 months agoilputto
1 year, 6 months ago