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