Which of the following tool can you use to both design and create a Postgres database?

$1$ point

pgAdmin

psql

ERD Tool

Query Tool

$2.$

Question $2$

When using the pgAdmin Restore command, which of the following items can you regenerate in the database? $($Select three$)$

$1$ point

Data types

Passwords

Tables

Data

$3.$

Question $3$

What is the main difference between regular views and materialized views?

$1$ point

You can save regular views or future use

You can insert, update, or delete data in regular views

You can store regular views in memory

Regular views can improve performance

$4.$

Question $4$

When initiating the creation of a new table in a database through pgAdmin, which tab in the Create Table dialog box helps to define data types?

$1$ point

Parameters

Constraints

General

Columns

$5.$

Question $5$

Which of the following SQL statement defines a view in PostgreSQL?

$1$ point

JOIN

VIEW

CREATE VIEW

SELECT