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.