Master SQL for Data Analysis - Creating - Database and Schema

What is the name of the admin console used to manage Ostgresql databases?

• AdminTool

• DBManager

• Gadmin

• PgAdmin

What is the default user called in the Ostgresql database?

• postgres

• admin

• root

• ostgres

Which SQL statement is used to create a new database?

• CREATE

• INSERT

• UPDATE

• DELETE

How can you create a new database using the query tool?

• Select 'New Database' from the menu

• Use the 'Add Database' button

• Type 'CREATE DATABASE' followed by the database name

• Right-click and choose 'Create New'

What should you do before deleting a database to ensure safety?

• Backup the database

• Export the database

• Disconnect from the database

• Rename the database

Which statement is used to remove a database?

• DROP DATABASE

• REMOVE DATABASE

• DELETE DATABASE

• ERASE DATABASE

What is the purpose of a database schema?

• To store user credentials

• To organize tables under a namespace

• To manage server connections

• To backup data