Question: Which statement creates a new database schema named Sales and establish Sharon as the owner?

  1. `ALTER USER Sharon WITH DEFAULT_SCHEMA = Sales;`
  2. `ALTER USER Sharon SET SCHEMA Sales;`
  3. `CREATE SCHEMA Sales SET OWNER Sharon;`
  4. `CREATE SCHEMA Sales AUTHORIZATION Sharon;`

Answer: The correct answer of the above question is Option D:`CREATE SCHEMA Sales AUTHORIZATION Sharon;`