An administrator account is granted the CREATE SESSION and SET CONTAINER system
privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB
that has been opened in read only mode?
A.
You can conned as a common user by using the connect statement.
B.
You can connect as a local user by using the connect statement.
C.
You can connect by using easy connect.
D.
You can connect by using OS authentication.
E.
You can connect by using a Net Service name.
F.
You can connect as a local user by using the SET CONTAINER statement.
Explanation:
* The choice of threading model is dictated by the THREADED_EXECUTION initialization
parameter.
THREADED_EXECUTION=FALSE : The default value causes Oracle to run using the
multiprocess model.
THREADED_EXECUTION=TRUE : Oracle runs with the multithreaded model.
* OS Authentication is not supported with the multithreaded model.
* THREADED_EXECUTION
When this initialization parameter is set to TRUE, which enables the multithreaded Oracle model,
operating system authentication is not supported. Attempts to connect to the database using
operating system authentication (for example, CONNECT / AS SYSDBA or CONNECT / ) when
this initialization parameter is set to TRUE receive an ORA-01031″insufficient privileges” error.
F: The new SET CONTAINER statement within a call back function:
The advantage of SET CONTAINER is that the pool does not have to create a new connection to
a PDB, if there is an exisitng connection to a different PDB. The pool can use the existing
connection, and through SET CONTAINER, can connect to the desired PDB. This can be done
using:
ALTER SESSION SET CONTAINER=<PDB Name>
This avoids the need to create a new connection from scratch.
CDEF
•Local connection with operating system authentication
With the service name, you can access the PDB using the easy connect syntax or the net service name from the tnsnames.ora file. Oracle Net Services must be configured properly for clients to access this service.
You can connect to a container by using the SQL*Plus CONNECT command, or you can switch into a container with an ALTER SESSION SET CONTAINER SQL statement.
Common user connection
SQL> conn C##abhi/root123
Connected.
SQL>
Local user connection
SQL> conn C##abhi@ptstdb
Enter password:
Connected.
SQL>
SQL> conn / as sysdba
Connected.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 PTSTDB READ ONLY NO
SQL> select open_mode from V$database;
OPEN_MODE
——————–
READ ONLY
SQL>
So connection to local and common user works even when CDB and PDB is read only mode.
It seems there is something missing
Local user
SQL> conn e2e_src/root123@ptstdb
Connected.
SQL>
“D. You can connect by using OS authentication.” is wrong
https://docs.oracle.com/cloud/latest/db121/REFRN/refrn10335.htm#REFRN10335
When this initialization parameter is set to TRUE, which enables the multithreaded Oracle model, operating system authentication is not supported. Attempts to connect to the database using operating system authentication (for example, CONNECT / AS SYSDBA or CONNECT / ) when this initialization parameter is set to TRUE receive an ORA-01031 “insufficient privileges” error.
The solution to this error is to always use the password when connecting to the database.
The parameter is set to FALSE. Read the question again.
ACDE
LOCAL user can’t use SET CONTAINER – F is wrong
A – C – D – E
ACDE