1Z0-062 · Question #3
You execute the commands: Which two statements are true?
The correct answer is A. The create user command fails if any role with the name Sidney exists in the database. D. The user sidney can connect to the database instance but requires relevant privileges to create. In Oracle Database, a username and a role name share the same namespace, so CREATE USER fails if a matching role exists, and a newly created user still needs explicit privileges to perform operations.
Question
You execute the commands:
Which two statements are true?
Exhibit
Options
- AThe create user command fails if any role with the name Sidney exists in the database.
- BThe user sidney can connect to the database instance but cannot perform sort operations
- CThe user sidney is created but cannot connect to the database instance because no profile is
- DThe user sidney can connect to the database instance but requires relevant privileges to create
- EThe user sidney is created and authenticated by the operating system.
How the community answered
(50 responses)- A78% (39)
- B2% (1)
- C14% (7)
- E6% (3)
Why each option
In Oracle Database, a username and a role name share the same namespace, so CREATE USER fails if a matching role exists, and a newly created user still needs explicit privileges to perform operations.
Oracle enforces a single namespace for users and roles, so if a role named SIDNEY already exists, the CREATE USER SIDNEY statement raises ORA-01920 and fails immediately.
The inability to perform sort operations relates to a missing or insufficient temporary tablespace, but the default temporary tablespace is assigned automatically and a newly created user can perform sorts unless explicitly restricted.
Oracle automatically assigns the DEFAULT profile when no profile is specified in CREATE USER, so the user can connect as long as CREATE SESSION is granted.
The CREATE USER statement itself grants no system or object privileges, so the user receives CREATE SESSION implicitly from a grant (or the command includes it), allowing connection, but any DDL such as creating tables requires explicit privilege grants.
OS authentication requires the username to be prefixed with OPS$ (or the value of OS_AUTHENT_PREFIX) and the user to be created with IDENTIFIED EXTERNALLY, neither of which is implied by the commands shown.
Concept tested: Oracle CREATE USER namespace rules and default privileges
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-USER.html
Topics
Community Discussion
No community discussion yet for this question.