Your database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ You execute the following command: And then grant OPS$GUEST_USER the CREATE SESSION privilege. Which two statements are true? (Choose two.)
A.
GUEST_USER can query the tables created in the USERS tablespace by default.
B.
The authentication details for GUEST_USER are stored in the database password file.
C.
A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.
D.
GUEST_USER can log on to the database without specifying a username and password.
E.
GUEST_USER is forced to change the password at the first login.
https://oracle-base.com/articles/misc/os-authentication
To enable external (OS) authentication of database user.
-Create an os user (ex: timhall) using useradd command on unix:
useradd timhall
passwd timhall
-Check value for os_authent_prefix (default is OPS$): This prefix is required for the database to identify that the user is being authenticated by OS
-Add user to database: CREATE USER ops$timhall IDENTIFIED EXTERNALLY; GRANT CREATE SESSION TO ops$timhall;
upvoted 2 times
...
This section is not available anymore. Please use the main Exam Page.1z0-062 Exam Questions
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.
dfabac
2 years, 12 months agoRay520
3 years, 1 month ago