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
B.
The value assigned to the CURRENT SCHEMA special register is persistent across database
restarts
0
0
The CURRENT SCHEMA (or CURRENT_SCHEMA) special register specifies a VARCHAR(128) value that identifies the schema name used to qualify database object references, where applicable, in dynamically prepared SQL statements.
The initial value of CURRENT SCHEMA is the authorization ID of the current session user. The value can be changed by invoking the SET SCHEMA statement.
0
0