Oracle Database 12c: Installation and Administration — Question 169

Which three statements are true about user account administration? (Choose three.)

Answer options

• A. A user's current session is not affected when the user's profile is changed.
• B. Only users with the SYSDBA privilege can change the tablespace quota for other users.
• C. A new user account can be created only by SYS or SYSTEM users.
• D. A user's quota can be set for any permanent tablespace but not for the default temporary tablespace.
• E. A user requires only the CREATE SESSION privilege to change his or her own password.

Correct answer: A, D, E

Explanation

Statement A is correct because changes to a user's profile take effect only in new sessions. Statement D is true as users can have quotas on permanent tablespaces but not on the default temporary one. Statement E is also correct since the CREATE SESSION privilege is sufficient for a user to change their own password. Statements B and C are incorrect because other users with the appropriate privileges can also change quotas and create accounts, not just SYS or SYSTEM users.