Question: Which statement creates a new database schema named Sales and establish Sharon as the owner?
- `ALTER USER Sharon WITH DEFAULT_SCHEMA = Sales;`
- `ALTER USER Sharon SET SCHEMA Sales;`
- `CREATE SCHEMA Sales SET OWNER Sharon;`
- `CREATE SCHEMA Sales AUTHORIZATION Sharon;`
Answer: The correct answer of the above question is Option D:`CREATE SCHEMA Sales AUTHORIZATION Sharon;`