Which SQL command is commonly used to create a new schema?
Options
-
A.
CREATE SCHEMA
-
B.
MAKE SCHEMA
-
C.
ADD DATABASE OBJECT
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
A.
CREATE SCHEMA
Detailed Explanation
- CREATE SCHEMA: Creates a new schema in DBMSs that support this SQL statement.
- Example: CREATE SCHEMA college;
- Syntax and permissions may vary between database systems.
OOps! You are currently offline.