Which of the following is NOT true about schemas?
A.
If a schema name is not specified, either by qualifying a database object name or by executing
the SET CURRENT SCHEMA statement, the authorization ID of the current session user is used
as the schema name by default
B.
The value assigned to the CURRENT SCHEMA special register is persistent across database
restarts
C.
A schema enables the creation of multiple objects in a database without encountering
namespace collisions
D.
When most database objects are created, they are either implicitly or explicitly assigned to a
schema