Oracle
1Z0-062 · Question #37
1Z0-062 Question #37: Real Exam Question with Answer & Explanation
The correct answer is A: You can conned as a common user by using the connect statement.. In a read-only CDB root, common users can connect via the CONNECT statement, Easy Connect, OS authentication, and a Net Service name, but local users have no presence in root and cannot connect there by any method.
Question
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?
Options
- AYou can conned as a common user by using the connect statement.
- BYou can connect as a local user by using the connect statement.
- CYou can connect by using easy connect.
- DYou can connect by using OS authentication.
- EYou can connect by using a Net Service name.
- FYou can connect as a local user by using the SET CONTAINER statement.
Explanation
In a read-only CDB root, common users can connect via the CONNECT statement, Easy Connect, OS authentication, and a Net Service name, but local users have no presence in root and cannot connect there by any method.
Common mistakes.
- B. Local users are schema accounts created inside a specific PDB and do not exist in the CDB root container, making it impossible to authenticate as a local user when connecting to root.
- F. SET CONTAINER switches an already-connected session between containers and requires a common user or a user with the appropriate privilege; local users have no authentication context in root and cannot use this statement to connect there.
Concept tested. CDB root connection methods, common vs. local users, THREADED_EXECUTION
Community Discussion
No community discussion yet for this question.