Which are characteristics of schemas in an Azure SQL Server database?Instruction: Choose all options that best answer the question. Answer ChoicesThey contain tablesThey are contained within a tableThey must be dropped before their tables are droppedThey contain databasesTheir tables must be dropped before they are dropped

The correct answers are:

1. They contain tables: In Azure SQL Server database, a schema is a logical container for database objects such as tables, views, indexes, etc. So, it's correct to say that schemas contain tables.

2. They must be dropped before their tables are dropped: This is incorrect. In fact, you cannot drop a schema that has objects (like tables) associated with it. You must first drop the objects before you can drop the schema.

3. Their tables must be dropped before they are dropped: This is correct for the same reason as above. You must first drop the tables (or other objects) within a schema before you can drop the schema itself.

4. They are contained within a table: This is incorrect. Schemas are not contained within tables. Rather, tables are contained within schemas.

5. They contain databases: This is also incorrect. Schemas do not contain databases. They are a component within a database.