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.
LOCAL user can set container class?
Local users cant connect to root. So answer is ACDE
The given answer of C,D,E,F is wrong. The question tells you an administrator user can login (CREATE SESSION) and can issue SET CONTAINER commands. It also tells you it is a CDB and that the multi-threaded architecture is disabled. That means OS authentication will work. So D is correct. As long as TCP/IP is configured, then using EZ Connect would work, so C is correct. Assuming there’s a listener and a tnsnames.ora file correctly configured would make E correct. Since the connection is to the ROOT container, that immediately eliminates any answer referencing LOCAL users because ROOT cannot have any LOCAL users. SELECT DISTINCT(COMMON) from DBA_USERS returns YES in CDB$ROOT. Further evidence of COMMON only users in root is provided if you attempt to create a local user in CDB$ROOT (i.e. a user without the C## prefix). Oracle returns an error if you attempt it. So, that eliminates B and F, leaving B as the fourth choice. Answer: ACDE.
H*T*H.
ACDE as noname correctly described!
A&C&D&E
SQL> help connect
CONNECT
——-
Connects a given username to the Oracle Database. When you run a
CONNECT command, the site profile, glogin.sql, and the user profile,
login.sql, are processed in that order. CONNECT does not reprompt
for username or password if the initial connection does not succeed.
CONN[ECT] [{logon|/|proxy}
[AS {SYSASM|SYSBACKUP|SYSDBA|SYSDG|SYSOPER|SYSRAC|SYSKM}]
[edition=value]]
where logon has the following syntax:
username[/password][@connect_identifier]
where proxy has the syntax:
proxyuser[username][/password][@connect_identifier]
NOTE: Brackets around username in proxy are required syntax
LOCAL USER IS DEDICATED FOR PDB, you cannot set containner in the connect statement.
Hi to every body, it’s my first pay a quick visit of this web site; this blog includes amazing and truly excellent data designed for readers.|
ACDE
ACDE
If CDB is read only, pdb within stays in mounted state and cannot be open. You cant connect local user while pdb is mounted state
SYS> conn c##test/test@pdb1;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Also, you switch container using set container but there is no way to also supply user/pwd. You then switch user using conn statement.
Was confuse with the question and common/local user.
Anyhow the answer still ACDE. Reason is you cannot create any local user(username without prefix c##) in CDB so there is no way to connect cdb by local user
ACDE