Multiple choice technology programming languages

identify the meaning of the following SQL statement CREATE USER PETRIE IDENTIFIED EXTERNALLY DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMPS QUOTA 12M ON forms

  1. The user is being validated by the enterprise directory service

  2. The user has unlimited quota on the USERS tablespace.

  3. The user’s quota will never exceed the size of the temporary tablespace.

  4. All options are correct.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The clause IDENTIFIED EXTERNALLY indicates that the user is authenticated by an external service, such as the operating system or an enterprise directory service, rather than by the database itself. Option B is incorrect because the quota is explicitly 12M, not unlimited. Option C is factually incorrect regarding temporary tablespaces.

Keep practicing — related questions