What does the following SQL statement do? CREATE USER "username" IDENTIFIED BY "password" DEFAULT TABLESPACE users QUOTA UNLIMITED ON users;

Question

Answer

1.  Deletes the user named "username" and removes any storage quotas previously assigned in the "users" tablespace.

Answer

3.  Creates a new user named "username" with a specified password and assigns them unlimited storage quota in the "users" tablespace.

Answer

4.  Retrieves information about the user named "username" and their current storage quota in the "users" tablespace.

Answer

2.  Modifies the password for the existing user named "username" and changes their default tablespace to "users".

Crowdly