Which three statements are true about user account administration? (Choose three)
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.
ADE
No additional privileges needed to change your own password.
ADE
A: correct “Any adjusted profile limit overrides the previous setting for that profile limit. By adjusting a limit with a value of DEFAULT, the resource limit reverts to the default limit set for the database. All profiles not adjusted when altering a profile retain the previous settings. Any changes to a profile do not affect current sessions. New profile settings are used only for sessions created after a profile is modified.”
B: Correct
C: correct “To create a user, you must have the CREATE USER system privilege. Because it is a powerful privilege, a DBA or security administrator is normally the only user who has the CREATE USER system privilege.”
D: wrong “By default, a user has no quota on any tablespace in the database. If the user has the privilege to create a schema object, you must assign a quota to allow the user to create objects. Minimally, assign users a quota for the default tablespace, and additional quotas for other tablespaces in which they can create objects.”
E: wrong “A newly created user cannot connect to the database until granted the CREATE SESSION system privilege”
https://docs.oracle.com/cd/B10501_01/server.920/a96521/users.htm#15280
D is true, you can not any quota for the temp tablespace, but you can for other tablespaces.
‘CREATE USER system privilege’ can be granted to any other users then SYS or SYSTEM users.
ABC i agree with younes
verified in the exam.
correct answer:
ADE