Job-Ready SQL in an Afternoon - Creating Schemas

The video tutorial covers how to create and drop schemas in SQL databases, manage database connections, and handle errors when dropping databases. It explains the visibility of schemas and how to make them available. The tutorial also demonstrates creating and managing schemas, including using the public schema by default.

What is a common error encountered when trying to drop a connected database?

• The database is locked by another user.

• The database is read-only.

• The database does not exist.

• The database is currently open and connected.

What must be done before dropping a database you are connected to?

• Create a backup of the database.

• Change the connection to a different database.

• Rename the database.

• Delete all tables in the database.

How can you make schemas visible in some SQL editors?

• By restarting the SQL editor.

• By clicking on 'introspect schema'.

• By creating a new schema.

• By refreshing the database connection.

What command is used to create a new schema?

• CREATE TABLE

• CREATE DATABASE

• CREATE SCHEMA

• CREATE VIEW

Why might you choose to stick with the default public schema?

• It is the fastest schema to access.

• It is available by default and usually sufficient.

• It is the most secure schema available.

• It is the only schema that supports tables.